Query Metrics
88
Database Queries
9
Different statements
9.46 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.27 ms |
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:
[
52416
]
|
| 2 | 0.16 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:
[ 10 58 ] |
| 3 | 0.13 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:
[ 10 58 5182 ] |
| 4 | 0.06 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"
]
|
| 5 | 0.58 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 ] |
| 6 | 0.21 ms |
select info_id, title from content_cell_view where vehicle_syskey=:vehicle and cell_id=:cell_id
Parameters:
[ "cell_id" => 52416 "vehicle" => 2685 ] |
| 7 | 0.20 ms |
select doc from document_en_us where obj_syskey=:info_id
Parameters:
[ "info_id" => 1658396 ] |
| 8 | 0.21 ms |
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[ "info_id" => "1658072" ] |
| 9 | 0.25 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" => 2685 "info_id" => "1671219" ] |
| 10 | 0.20 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" => 2685 "info_id" => "1463696" ] |
| 11 | 0.30 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" => 2685 "info_id" => "1645910" ] |
| 12 | 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" => 2685 "info_id" => "1658074" ] |
| 13 | 0.11 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" => 2685 "info_id" => "1657890" ] |
| 14 | 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" => 2685 "info_id" => "1657890" ] |
| 15 | 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" => 2685 "info_id" => "1657940" ] |
| 16 | 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" => 2685 "info_id" => "1657934" ] |
| 17 | 0.09 ms |
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[ "info_id" => "1658074" ] |
| 18 | 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" => 2685 "info_id" => "1671219" ] |
| 19 | 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" => 2685 "info_id" => "1463696" ] |
| 20 | 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" => 2685 "info_id" => "1645910" ] |
| 21 | 0.11 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" => 2685 "info_id" => "1658076" ] |
| 22 | 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" => 2685 "info_id" => "1658072" ] |
| 23 | 0.21 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" => 2685 "info_id" => "1711906" ] |
| 24 | 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" => 2685 "info_id" => "1657936" ] |
| 25 | 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" => 2685 "info_id" => "1657936" ] |
| 26 | 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" => 2685 "info_id" => "1711906" ] |
| 27 | 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" => 2685 "info_id" => "1657936" ] |
| 28 | 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" => 2685 "info_id" => "1711906" ] |
| 29 | 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" => 2685 "info_id" => "1657925" ] |
| 30 | 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" => 2685 "info_id" => "1657923" ] |
| 31 | 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" => 2685 "info_id" => "1657936" ] |
| 32 | 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" => 2685 "info_id" => "1711906" ] |
| 33 | 0.08 ms |
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[ "info_id" => "1658076" ] |
| 34 | 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" => 2685 "info_id" => "1671219" ] |
| 35 | 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" => 2685 "info_id" => "1463696" ] |
| 36 | 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" => 2685 "info_id" => "1645910" ] |
| 37 | 0.20 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" => 2685 "info_id" => "1713404" ] |
| 38 | 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" => 2685 "info_id" => "1658074" ] |
| 39 | 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" => 2685 "info_id" => "1657890" ] |
| 40 | 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" => 2685 "info_id" => "1657890" ] |
| 41 | 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" => 2685 "info_id" => "1713404" ] |
| 42 | 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" => 2685 "info_id" => "1658064" ] |
| 43 | 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" => 2685 "info_id" => "1658068" ] |
| 44 | 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" => 2685 "info_id" => "1658091" ] |
| 45 | 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" => 2685 "info_id" => "1658045" ] |
| 46 | 0.10 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" => 2685 "info_id" => "1658177" ] |
| 47 | 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" => 2685 "info_id" => "1657934" ] |
| 48 | 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" => 2685 "info_id" => "1657925" ] |
| 49 | 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" => 2685 "info_id" => "1657936" ] |
| 50 | 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" => 2685 "info_id" => "1711906" ] |
| 51 | 0.20 ms |
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[ "info_id" => "1713404" ] |
| 52 | 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" => 2685 "info_id" => "1671219" ] |
| 53 | 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" => 2685 "info_id" => "1463696" ] |
| 54 | 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" => 2685 "info_id" => "1645910" ] |
| 55 | 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" => 2685 "info_id" => "1658077" ] |
| 56 | 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" => 2685 "info_id" => "1658076" ] |
| 57 | 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" => 2685 "info_id" => "1658076" ] |
| 58 | 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" => 2685 "info_id" => "1658077" ] |
| 59 | 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" => 2685 "info_id" => "1657936" ] |
| 60 | 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" => 2685 "info_id" => "1711906" ] |
| 61 | 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" => 2685 "info_id" => "1657923" ] |
| 62 | 0.07 ms |
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[ "info_id" => "1658077" ] |
| 63 | 0.10 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" => 2685 "info_id" => "1671219" ] |
| 64 | 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" => 2685 "info_id" => "1463696" ] |
| 65 | 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" => 2685 "info_id" => "1645910" ] |
| 66 | 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" => 2685 "info_id" => "1658081" ] |
| 67 | 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" => 2685 "info_id" => "1713404" ] |
| 68 | 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" => 2685 "info_id" => "1657890" ] |
| 69 | 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" => 2685 "info_id" => "1657890" ] |
| 70 | 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" => 2685 "info_id" => "1657908" ] |
| 71 | 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" => 2685 "info_id" => "1658167" ] |
| 72 | 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" => 2685 "info_id" => "1713404" ] |
| 73 | 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" => 2685 "info_id" => "1711906" ] |
| 74 | 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" => 2685 "info_id" => "1711906" ] |
| 75 | 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" => 2685 "info_id" => "1657936" ] |
| 76 | 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" => 2685 "info_id" => "1711906" ] |
| 77 | 0.10 ms |
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[ "info_id" => "1658081" ] |
| 78 | 0.11 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" => 2685 "info_id" => "1671219" ] |
| 79 | 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" => 2685 "info_id" => "1463696" ] |
| 80 | 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" => 2685 "info_id" => "1645910" ] |
| 81 | 0.07 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" => 2685 "info_id" => "1658077" ] |
| 82 | 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" => 2685 "info_id" => "1657894" ] |
| 83 | 0.07 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" => 2685 "info_id" => "1657894" ] |
| 84 | 0.07 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" => 2685 "info_id" => "1657890" ] |
| 85 | 0.07 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" => 2685 "info_id" => "1657890" ] |
| 86 | 0.07 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" => 2685 "info_id" => "1658159" ] |
| 87 | 0.07 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" => 2685 "info_id" => "1658177" ] |
| 88 | 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" => 2685 "info_id" => "1711906" ] |
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. |