Query Metrics
15
Database Queries
5
Different statements
8.17 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.08 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:
[
528201
]
|
| 2 | 0.65 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 | 2.59 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 "Chevy_K_Pickup___4WD__CNG_" 2000 ] |
| 4 | 0.82 ms |
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[ "info_id" => 528201 ] |
| 5 | 0.85 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" => 2013 "info_id" => "391384" ] |
| 6 | 0.42 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" => 2013 "info_id" => "528207" ] |
| 7 | 0.18 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" => 2013 "info_id" => "376396" ] |
| 8 | 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" => 2013 "info_id" => "376394" ] |
| 9 | 0.15 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" => 2013 "info_id" => "289786" ] |
| 10 | 0.36 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" => 2013 "info_id" => "395335" ] |
| 11 | 0.18 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" => 2013 "info_id" => "6756" ] |
| 12 | 0.15 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" => 2013 "info_id" => "6756" ] |
| 13 | 0.14 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" => 2013 "info_id" => "6756" ] |
| 14 | 0.28 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" => 2013 "info_id" => "375400" ] |
| 15 | 0.15 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" => 2013 "info_id" => "528211" ] |
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. |