http://gm.saturn.team/Chevrolet/TrailBlazer___2WD/2006/58/30/5178/61979

Query Metrics

109 Database Queries
9 Different statements
14.53 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.68 ms
(0.00%)
84
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" => 2769
  "info_id" => "1567205"
]
1.97 ms
(0.00%)
1
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
  "TrailBlazer___2WD"
  2006
]
1.71 ms
(0.00%)
18
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "1614550"
]
0.64 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.info_id AS info_id_2, t0.sio_type AS sio_type_3, t0.ref_desc AS ref_desc_4, t0.release_date AS release_date_5, t0.mspsdsub_key AS mspsdsub_key_6, t0.cell_seq_no AS cell_seq_no_7, t0.svc_info_type_no AS svc_info_type_no_8, t0.svc_info_type_desc AS svc_info_type_desc_9, t0.psd_sie_title_id AS psd_sie_title_id_10, t0.psd_sie_title_desc AS psd_sie_title_desc_11, t0.sie_seq_no AS sie_seq_no_12, t0.svc_info_qua_no AS svc_info_qua_no_13, t0.svc_info_qua_desc AS svc_info_qua_desc_14, t0.pub_psd_id AS pub_psd_id_15, t0.cell_id AS cell_id_16 FROM sio_rti t0 WHERE t0.cell_id = ? LIMIT 1
Parameters:
[
  61979
]
0.45 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.comp_sec_title AS comp_sec_title_2, t0.sec_id AS sec_id_3, t0.sec_seq_no AS sec_seq_no_4, t0.book_id AS book_id_5 FROM ms_psd_section t0 WHERE t0.sec_id = ? AND t0.book_id = ? ORDER BY t0.comp_sec_title ASC LIMIT 1
Parameters:
[
  30
  58
]
0.45 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.comp_subsec_title AS comp_subsec_title_2, t0.mspsdsub_key AS mspsdsub_key_3, t0.psd_subsec_title_id AS psd_subsec_title_id_4, t0.subsec_seq_no AS subsec_seq_no_5, t0.svc_cat_no AS svc_cat_no_6, t0.sec_id AS sec_id_7, t0.book_id AS book_id_8 FROM ms_psd_subsection t0 WHERE t0.sec_id = ? AND t0.book_id = ? AND t0.mspsdsub_key = ? ORDER BY t0.comp_subsec_title ASC LIMIT 1
Parameters:
[
  30
  58
  5178
]
0.31 ms
(0.00%)
1
select info_id, title
                 from content_cell_view
        where vehicle_syskey=:vehicle and cell_id=:cell_id
Parameters:
[
  "cell_id" => 61979
  "vehicle" => 2769
]
0.17 ms
(0.00%)
1
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"
]
0.15 ms
(0.00%)
1
select doc from document_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => 1614584
]

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\Vehicle No errors.
App\Entity\Make No errors.
App\Entity\SioRti No errors.
App\Entity\MsPsdSubsection No errors.
App\Entity\MsPsdSection No errors.
App\Entity\PubPsdName No errors.
App\Entity\CellIdPsdTitleIdMap No errors.
App\Entity\MsPsdBook No errors.
App\Entity\Platform No errors.