Symfony Profiler

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

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 = 61981 LIMIT 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

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 = 30 AND t0.book_id = 58 ORDER BY t0.comp_sec_title ASC LIMIT 1;

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

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 = 30 AND t0.book_id = 58 AND t0.mspsdsub_key = 5178 ORDER BY t0.comp_subsec_title ASC LIMIT 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

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 = 'Chevrolet' LIMIT 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

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 = 48 AND t0.seo_url = 'TrailBlazer___2WD' AND t0.model_year = 2006 LIMIT 1;

select
  info_id,
  title
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and cell_id = :cell_id

select info_id, title
                 from content_cell_view
        where vehicle_syskey=2769 and cell_id=61981;

select
  doc
from
  document_en_us
where
  obj_syskey = :info_id

select doc from document_en_us where obj_syskey=1614605;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614593';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614594'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614594';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614595'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614593'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='665383'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614595';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614596'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614594'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614596';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614597'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614595'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614597';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614598'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614596'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614598';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614599'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614597'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='665383'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614599'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614599';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614600'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614598'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614598'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614600';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614601'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614599'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614601'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614601';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614602'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614600'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614600'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614602';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614603'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614601'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1614603';

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1567205'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1619728'
        limit 1;

select
  book_id,
  sec_id,
  mspsdsub_key,
  cell_id
from
  content_cell_view
where
  vehicle_syskey = :vehicle
  and info_id = :info_id
limit
  1

select book_id, sec_id, mspsdsub_key, cell_id
                 from content_cell_view
        where vehicle_syskey=2769 and info_id='1614602'
        limit 1;