Symfony Profiler

select
  book_type_id,
  book_id,
  book_type_desc,
  sec_id,
  comp_sec_title
from
  books_and_sections_view
where
  vehicle_syskey = :id
order by
  book_type_id,
  sec_seq_no

select book_type_id, book_id, book_type_desc, sec_id, comp_sec_title
from books_and_sections_view
where vehicle_syskey=2715
order by book_type_id, sec_seq_no
;

select
  1
from
  dtcs_view
where
  vehicle_syskey = :id
limit
  1

select 1
        from dtcs_view
where vehicle_syskey=2715 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 = 52 AND t0.seo_url = 'Rendezvous___AWD' AND t0.model_year = 2006 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 = 'Buick' LIMIT 1;