Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.class_type AS class_type_4,
  t0.province_id AS province_id_5
FROM
  city t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.class_type AS class_type_4, t0.province_id AS province_id_5 FROM city t0;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.slug AS slug_2,
  i0_.address AS address_3,
  i0_.type AS type_4,
  i0_.latitude AS latitude_5,
  i0_.longitude AS longitude_6,
  i0_.status AS status_7,
  i0_.date_created AS date_created_8,
  i0_.logo_filename AS logo_filename_9,
  i0_.inspection_duration AS inspection_duration_10,
  i0_.with_onsite_lto AS with_onsite_lto_11,
  i0_.max_booking_per_time_slot AS max_booking_per_time_slot_12,
  i0_.max_booking_per_day AS max_booking_per_day_13,
  i0_.is_activated AS is_activated_14,
  i0_.city_id AS city_id_15
FROM
  inspection_center i0_
WHERE
  i0_.status = ?

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.slug AS slug_2, i0_.address AS address_3, i0_.type AS type_4, i0_.latitude AS latitude_5, i0_.longitude AS longitude_6, i0_.status AS status_7, i0_.date_created AS date_created_8, i0_.logo_filename AS logo_filename_9, i0_.inspection_duration AS inspection_duration_10, i0_.with_onsite_lto AS with_onsite_lto_11, i0_.max_booking_per_time_slot AS max_booking_per_time_slot_12, i0_.max_booking_per_day AS max_booking_per_day_13, i0_.is_activated AS is_activated_14, i0_.city_id AS city_id_15 FROM inspection_center i0_ WHERE i0_.status = 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.date_created AS date_created_3,
  t0.file_size AS file_size_4,
  t0.file_type AS file_type_5,
  t0.inspection_center_id AS inspection_center_id_6
FROM
  inspection_center_image t0
WHERE
  t0.inspection_center_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.date_created AS date_created_3, t0.file_size AS file_size_4, t0.file_type AS file_type_5, t0.inspection_center_id AS inspection_center_id_6 FROM inspection_center_image t0 WHERE t0.inspection_center_id = 0x01916F8658611CB187700436B57F23A2;

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 = 0x01916F8658611CB187700436B57F23A2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.icon_class AS icon_class_3
FROM
  amenity t0
  INNER JOIN inspection_center_amenity ON t0.id = inspection_center_amenity.amenity_id
WHERE
  inspection_center_amenity.inspection_center_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_class AS icon_class_3 FROM amenity t0 INNER JOIN inspection_center_amenity ON t0.id = inspection_center_amenity.amenity_id WHERE inspection_center_amenity.inspection_center_id = 0x01916F8658611CB187700436B57F23A2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.inspection_center_id AS inspection_center_id_3
FROM
  inspection_center_perk t0
WHERE
  t0.inspection_center_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.inspection_center_id AS inspection_center_id_3 FROM inspection_center_perk t0 WHERE t0.inspection_center_id = 0x01916F8658611CB187700436B57F23A2;

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 = 0x01916F8658611CB187700436B57F23A2;

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.name AS name_2,
  t0.is_active AS is_active_3,
  t0.date_created AS date_created_4,
  t0.css_icon_class_name AS css_icon_class_name_5
FROM
  vehicle_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.date_created AS date_created_4, t0.css_icon_class_name AS css_icon_class_name_5 FROM vehicle_category t0 WHERE t0.id = 0x01910939A2B0A891D57B9B1C668D3234;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.date_created AS date_created_3,
  t0.file_size AS file_size_4,
  t0.file_type AS file_type_5,
  t0.inspection_center_id AS inspection_center_id_6
FROM
  inspection_center_image t0
WHERE
  t0.inspection_center_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.date_created AS date_created_3, t0.file_size AS file_size_4, t0.file_type AS file_type_5, t0.inspection_center_id AS inspection_center_id_6 FROM inspection_center_image t0 WHERE t0.inspection_center_id = 0x01916F9A81BE319723F75C0914E6EE6B;

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.icon_class AS icon_class_3
FROM
  amenity t0
  INNER JOIN inspection_center_amenity ON t0.id = inspection_center_amenity.amenity_id
WHERE
  inspection_center_amenity.inspection_center_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_class AS icon_class_3 FROM amenity t0 INNER JOIN inspection_center_amenity ON t0.id = inspection_center_amenity.amenity_id WHERE inspection_center_amenity.inspection_center_id = 0x01916F9A81BE319723F75C0914E6EE6B;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.inspection_center_id AS inspection_center_id_3
FROM
  inspection_center_perk t0
WHERE
  t0.inspection_center_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.inspection_center_id AS inspection_center_id_3 FROM inspection_center_perk 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.name AS name_2,
  t0.is_active AS is_active_3,
  t0.date_created AS date_created_4,
  t0.css_icon_class_name AS css_icon_class_name_5
FROM
  vehicle_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.date_created AS date_created_4, t0.css_icon_class_name AS css_icon_class_name_5 FROM vehicle_category t0 WHERE t0.id = 0x01910939A2C074EBAD4D1E6CFC841F4A;

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.date_created AS date_created_4,
  t0.css_icon_class_name AS css_icon_class_name_5
FROM
  vehicle_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.date_created AS date_created_4, t0.css_icon_class_name AS css_icon_class_name_5 FROM vehicle_category t0 WHERE t0.id = 0x01910939A2DEC7785958FC56C1B3EF68;