http://gm.saturn.team/Chevrolet/TrailBlazer___2WD/2006/60/26

Query Metrics

4 Database Queries
4 Different statements
2.78 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.56 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
]
0.64 ms
(0.00%)
1
select mspsdsub_key, comp_subsec_title
         from subsections_view
where vehicle_syskey=:id and book_id = :book_id and sec_id = :sec_id
order by comp_subsec_title
Parameters:
[
  "sec_id" => 26
  "book_id" => 60
  "id" => 2769
]
0.31 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:
[
  26
  60
]
0.27 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"
]

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