Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t0.type AS type_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.status AS status_8,
  t0.date_created AS date_created_9,
  t0.logo_filename AS logo_filename_10,
  t0.inspection_duration AS inspection_duration_11,
  t0.with_onsite_lto AS with_onsite_lto_12,
  t0.max_booking_per_time_slot AS max_booking_per_time_slot_13,
  t0.max_booking_per_day AS max_booking_per_day_14,
  t0.is_activated AS is_activated_15,
  t0.city_id AS city_id_16
FROM
  inspection_center t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.type AS type_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.status AS status_8, t0.date_created AS date_created_9, t0.logo_filename AS logo_filename_10, t0.inspection_duration AS inspection_duration_11, t0.with_onsite_lto AS with_onsite_lto_12, t0.max_booking_per_time_slot AS max_booking_per_time_slot_13, t0.max_booking_per_day AS max_booking_per_day_14, t0.is_activated AS is_activated_15, t0.city_id AS city_id_16 FROM inspection_center t0 WHERE t0.slug = 'mvic-manila' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_created AS date_created_3,
  t0.status AS status_4,
  t0.price AS price_5,
  t0.description AS description_6,
  t0.inspection_center_id AS inspection_center_id_7,
  t0.vehicle_category_id AS vehicle_category_id_8
FROM
  package t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3, t0.status AS status_4, t0.price AS price_5, t0.description AS description_6, t0.inspection_center_id AS inspection_center_id_7, t0.vehicle_category_id AS vehicle_category_id_8 FROM package t0 WHERE t0.id = 0x01917255B307E74E6C16975BB38833AC;

SELECT
  t0.id AS id_1,
  t0.day_of_week AS day_of_week_2,
  t0.am_opening_time AS am_opening_time_3,
  t0.am_closing_time AS am_closing_time_4,
  t0.pm_opening_time AS pm_opening_time_5,
  t0.pm_closing_time AS pm_closing_time_6,
  t0.inspection_center_id AS inspection_center_id_7
FROM
  inspection_center_schedule t0
WHERE
  t0.inspection_center_id = ?

SELECT t0.id AS id_1, t0.day_of_week AS day_of_week_2, t0.am_opening_time AS am_opening_time_3, t0.am_closing_time AS am_closing_time_4, t0.pm_opening_time AS pm_opening_time_5, t0.pm_closing_time AS pm_closing_time_6, t0.inspection_center_id AS inspection_center_id_7 FROM inspection_center_schedule t0 WHERE t0.inspection_center_id = 0x01916F9A81BE319723F75C0914E6EE6B;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_created AS date_created_3,
  t0.is_primary AS is_primary_4,
  t0.is_active AS is_active_5,
  t0.logo_filename AS logo_filename_6
FROM
  insurance_provider t0
WHERE
  t0.is_active = ?
  AND t0.is_primary = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3, t0.is_primary AS is_primary_4, t0.is_active AS is_active_5, t0.logo_filename AS logo_filename_6 FROM insurance_provider t0 WHERE t0.is_active = 1 AND t0.is_primary = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.date_created AS date_created_3,
  t0.status AS status_4,
  t0.price AS price_5,
  t0.description AS description_6,
  t0.inspection_center_id AS inspection_center_id_7,
  t0.vehicle_category_id AS vehicle_category_id_8
FROM
  package t0
WHERE
  t0.inspection_center_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.date_created AS date_created_3, t0.status AS status_4, t0.price AS price_5, t0.description AS description_6, t0.inspection_center_id AS inspection_center_id_7, t0.vehicle_category_id AS vehicle_category_id_8 FROM package t0 WHERE t0.inspection_center_id = 0x01916F9A81BE319723F75C0914E6EE6B;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.price AS price_3,
  t0.date_created AS date_created_4,
  t0.basic_premium AS basic_premium_5,
  t0.documentary_stamp_tax AS documentary_stamp_tax_6,
  t0.expanded_value_added_tax AS expanded_value_added_tax_7,
  t0.local_government_tax AS local_government_tax_8,
  t0.coc_verification_facility_fee AS coc_verification_facility_fee_9,
  t0.bayad_center_fee AS bayad_center_fee_10,
  t0.lto_interconnectivity_fee AS lto_interconnectivity_fee_11,
  t0.insurance_provider_id AS insurance_provider_id_12,
  t0.vehicle_category_id AS vehicle_category_id_13
FROM
  ctpl_package t0
WHERE
  t0.is_active = ?
  AND t0.vehicle_category_id = ?
  AND t0.insurance_provider_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.price AS price_3, t0.date_created AS date_created_4, t0.basic_premium AS basic_premium_5, t0.documentary_stamp_tax AS documentary_stamp_tax_6, t0.expanded_value_added_tax AS expanded_value_added_tax_7, t0.local_government_tax AS local_government_tax_8, t0.coc_verification_facility_fee AS coc_verification_facility_fee_9, t0.bayad_center_fee AS bayad_center_fee_10, t0.lto_interconnectivity_fee AS lto_interconnectivity_fee_11, t0.insurance_provider_id AS insurance_provider_id_12, t0.vehicle_category_id AS vehicle_category_id_13 FROM ctpl_package t0 WHERE t0.is_active = 1 AND t0.vehicle_category_id = 0x01910939A2B0A891D57B9B1C668D3234 AND t0.insurance_provider_id = 0x01910939A2ED3B4CA8FAF5D42F1A2E2A LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.price AS price_3,
  t0.date_created AS date_created_4,
  t0.basic_premium AS basic_premium_5,
  t0.documentary_stamp_tax AS documentary_stamp_tax_6,
  t0.expanded_value_added_tax AS expanded_value_added_tax_7,
  t0.local_government_tax AS local_government_tax_8,
  t0.coc_verification_facility_fee AS coc_verification_facility_fee_9,
  t0.bayad_center_fee AS bayad_center_fee_10,
  t0.lto_interconnectivity_fee AS lto_interconnectivity_fee_11,
  t0.insurance_provider_id AS insurance_provider_id_12,
  t0.vehicle_category_id AS vehicle_category_id_13
FROM
  ctpl_package t0
WHERE
  t0.is_active = ?
  AND t0.vehicle_category_id = ?
  AND t0.insurance_provider_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.price AS price_3, t0.date_created AS date_created_4, t0.basic_premium AS basic_premium_5, t0.documentary_stamp_tax AS documentary_stamp_tax_6, t0.expanded_value_added_tax AS expanded_value_added_tax_7, t0.local_government_tax AS local_government_tax_8, t0.coc_verification_facility_fee AS coc_verification_facility_fee_9, t0.bayad_center_fee AS bayad_center_fee_10, t0.lto_interconnectivity_fee AS lto_interconnectivity_fee_11, t0.insurance_provider_id AS insurance_provider_id_12, t0.vehicle_category_id AS vehicle_category_id_13 FROM ctpl_package t0 WHERE t0.is_active = 1 AND t0.vehicle_category_id = 0x01910939A2C074EBAD4D1E6CFC841F4A AND t0.insurance_provider_id = 0x01910939A2ED3B4CA8FAF5D42F1A2E2A LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.price AS price_3,
  t0.date_created AS date_created_4,
  t0.basic_premium AS basic_premium_5,
  t0.documentary_stamp_tax AS documentary_stamp_tax_6,
  t0.expanded_value_added_tax AS expanded_value_added_tax_7,
  t0.local_government_tax AS local_government_tax_8,
  t0.coc_verification_facility_fee AS coc_verification_facility_fee_9,
  t0.bayad_center_fee AS bayad_center_fee_10,
  t0.lto_interconnectivity_fee AS lto_interconnectivity_fee_11,
  t0.insurance_provider_id AS insurance_provider_id_12,
  t0.vehicle_category_id AS vehicle_category_id_13
FROM
  ctpl_package t0
WHERE
  t0.is_active = ?
  AND t0.vehicle_category_id = ?
  AND t0.insurance_provider_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.price AS price_3, t0.date_created AS date_created_4, t0.basic_premium AS basic_premium_5, t0.documentary_stamp_tax AS documentary_stamp_tax_6, t0.expanded_value_added_tax AS expanded_value_added_tax_7, t0.local_government_tax AS local_government_tax_8, t0.coc_verification_facility_fee AS coc_verification_facility_fee_9, t0.bayad_center_fee AS bayad_center_fee_10, t0.lto_interconnectivity_fee AS lto_interconnectivity_fee_11, t0.insurance_provider_id AS insurance_provider_id_12, t0.vehicle_category_id AS vehicle_category_id_13 FROM ctpl_package t0 WHERE t0.is_active = 1 AND t0.vehicle_category_id = 0x01910939A2DEC7785958FC56C1B3EF68 AND t0.insurance_provider_id = 0x01910939A2ED3B4CA8FAF5D42F1A2E2A LIMIT 1;