http://gm.saturn.team/Chevrolet/Monte_Carlo/2006/58/31/5194

Query Metrics

5 Database Queries
5 Different statements
2.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.39 ms
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:
[
  31
  58
]
2 0.29 ms
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:
[
  31
  58
  5194
]
3 0.13 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"
]
4 1.18 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
  "Monte_Carlo"
  2006
]
5 0.54 ms
select info_id, cell_id, psd_sie_title_desc, svc_info_qua_desc, mspsdsub_key
         from cell_list_view
where vehicle_syskey=:id and book_id = :book_id and sec_id = :sec_id and mspsdsub_key = :mspsdsub_key
order by svc_info_qua_desc, psd_sie_title_desc
Parameters:
[
  "sec_id" => 31
  "book_id" => 58
  "mspsdsub_key" => 5194
  "id" => 2685
]

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\MsPsdSection No errors.
App\Entity\MsPsdSubsection No errors.
App\Entity\MsPsdBook No errors.
App\Entity\Platform No errors.