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 = 147986 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 = 10 AND t0.book_id = 99 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 = 10 AND t0.book_id = 99 AND t0.mspsdsub_key = 7709 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 = 'Captiva' AND t0.model_year = 2009 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=3227 and cell_id=147986;

select
  doc
from
  document_en_us
where
  obj_syskey = :info_id

select doc from document_en_us where obj_syskey=1987450;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1986808';

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=3227 and info_id='1992140'
        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=3227 and info_id='1996481'
        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=3227 and info_id='1986809'
        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=3227 and info_id='1986852'
        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=3227 and info_id='1986805'
        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=3227 and info_id='1986869'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1986809';

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=3227 and info_id='1992140'
        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=3227 and info_id='1996481'
        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=3227 and info_id='1986812'
        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=3227 and info_id='1986808'
        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=3227 and info_id='1986859'
        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=3227 and info_id='1986859'
        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=3227 and info_id='1986859'
        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=3227 and info_id='1986805'
        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=3227 and info_id='1986802'
        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=3227 and info_id='1986871'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1986812';

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=3227 and info_id='1992140'
        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=3227 and info_id='1996481'
        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=3227 and info_id='1986815'
        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=3227 and info_id='1986809'
        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=3227 and info_id='1961259'
        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=3227 and info_id='1961254'
        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=3227 and info_id='1961384'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1986815';

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=3227 and info_id='1992140'
        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=3227 and info_id='1996481'
        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=3227 and info_id='1986816'
        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=3227 and info_id='1986812'
        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=3227 and info_id='1961377'
        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=3227 and info_id='1961347'
        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=3227 and info_id='1961353'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1986816';

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=3227 and info_id='1992140'
        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=3227 and info_id='1996481'
        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=3227 and info_id='1986817'
        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=3227 and info_id='1986815'
        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=3227 and info_id='1962029'
        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=3227 and info_id='1961203'
        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=3227 and info_id='1962029'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1986817';

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=3227 and info_id='1992140'
        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=3227 and info_id='1996481'
        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=3227 and info_id='1986818'
        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=3227 and info_id='1986816'
        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=3227 and info_id='1961222'
        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=3227 and info_id='1962021'
        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=3227 and info_id='1962016'
        limit 1;

select
  doc
from
  text_object_en_us
where
  obj_syskey = :info_id

select doc from text_object_en_us where obj_syskey='1986818';