http://gm.saturn.team/GMC_Truck/GMC_MD_Conventional__C_Model_/1991/bulletins/347111

Query Metrics

47 Database Queries
5 Different statements
6.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.29 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:
[
  347111
]
2 0.08 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:
[
  "GMC_Truck"
]
3 1.54 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:
[
  84
  "GMC_MD_Conventional__C_Model_"
  1991
]
4 0.55 ms
select doc from bulletin_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => 347111
]
5 0.15 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "999999992"
]
6 0.11 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "999999994"
]
7 0.25 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335087"
]
8 0.10 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335089"
]
9 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335091"
]
10 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335093"
]
11 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335095"
]
12 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335097"
]
13 0.12 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335099"
]
14 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335101"
]
15 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335103"
]
16 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335105"
]
17 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335107"
]
18 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335109"
]
19 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335111"
]
20 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335113"
]
21 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335115"
]
22 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335117"
]
23 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335119"
]
24 0.12 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335121"
]
25 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335123"
]
26 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335125"
]
27 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335127"
]
28 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335129"
]
29 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335131"
]
30 0.09 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335133"
]
31 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335135"
]
32 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335137"
]
33 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335139"
]
34 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335141"
]
35 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335143"
]
36 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335145"
]
37 0.21 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335147"
]
38 0.10 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335149"
]
39 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335151"
]
40 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335153"
]
41 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335155"
]
42 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335157"
]
43 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335159"
]
44 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335161"
]
45 0.08 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335163"
]
46 0.07 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335165"
]
47 0.11 ms
select doc from text_object_en_us where obj_syskey=:info_id
Parameters:
[
  "info_id" => "335167"
]

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