http://gm.saturn.team/Chevrolet/Corvette/2006/doc/1651708

Query Metrics

21 Database Queries
5 Different statements
6.66 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.94 ms
SELECT t0.info_id AS info_id_1, t0.ref_desc AS ref_desc_2, t0.release_date AS release_date_3, t0.release_stat AS release_stat_4, t0.sio_type AS sio_type_5 FROM sio t0 WHERE t0.info_id = ? LIMIT 1
Parameters:
[
  1651708
]
2 0.39 ms
SELECT t0.mktg_div_id AS mktg_div_id_1, t0.mktg_div_name AS mktg_div_name_2, t0.mktg_div_vin_letter AS mktg_div_vin_letter_3, t0.seo_url AS seo_url_4 FROM make t0 WHERE t0.seo_url = ? LIMIT 1
Parameters:
[
  "Chevrolet"
]
3 3.02 ms
SELECT t0.vehicle_syskey AS vehicle_syskey_1, t0.model_desc AS model_desc_2, t0.model_id AS model_id_3, t0.model_year AS model_year_4, t0.vehicle_vin_letter AS vehicle_vin_letter_5, t0.seo_url AS seo_url_6, t0.platform_id AS platform_id_7, t0.mktg_div_id AS mktg_div_id_8 FROM vehicle t0 WHERE t0.mktg_div_id = ? AND t0.seo_url = ? AND t0.model_year = ? LIMIT 1
Parameters:
[
  48
  "Corvette"
  2006
]
4 0.48 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => 1651708
]
5 0.31 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1618601"
]
6 0.44 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1618161"
]
7 0.09 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1632002"
]
8 0.17 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1651709"
]
9 0.06 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "17618"
]
10 0.08 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1617284"
]
11 0.16 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1602180"
]
12 0.06 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1616947"
]
13 0.06 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1616952"
]
14 0.05 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1617005"
]
15 0.05 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1602552"
]
16 0.05 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1616952"
]
17 0.05 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1601164"
]
18 0.05 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1601168"
]
19 0.05 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1617194"
]
20 0.05 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1617197"
]
21 0.05 ms
select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=:vehicle and info_id=:info_id
        limit 1
Parameters:
[
  "vehicle" => 2691
  "info_id" => "1617051"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Make No errors.
App\Entity\Vehicle No errors.
App\Entity\Sio No errors.
App\Entity\Platform No errors.