Symfony Profiler

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 = 2 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 = 2 AND t0.book_id = 58 AND t0.mspsdsub_key = 4837 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 = 'Express' AND t0.model_year = 2006 LIMIT 1;

select
  info_id,
  cell_id,
  psd_sie_title_desc,
  svc_info_qua_desc,
  mspsdsub_key
from
  cell_list_view
where
  vehicle_syskey = :id
  and book_id = :book_id
  and sec_id = :sec_id
  and mspsdsub_key = :mspsdsub_key
order by
  svc_info_qua_desc,
  psd_sie_title_desc

select info_id, cell_id, psd_sie_title_desc, svc_info_qua_desc, mspsdsub_key
         from cell_list_view
where vehicle_syskey=2698 and book_id = 58 and sec_id = 2 and mspsdsub_key = 4837
order by svc_info_qua_desc, psd_sie_title_desc
;