Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.cif AS cif_4,
  t0.slug AS slug_5,
  t0.company_name AS company_name_6,
  t0.mobile AS mobile_7,
  t0.mobile_associated AS mobile_associated_8,
  t0.whatsapp AS whatsapp_9,
  t0.whatsapp_campaigns AS whatsapp_campaigns_10,
  t0.whatsapp_campaigns_name AS whatsapp_campaigns_name_11,
  t0.website AS website_12,
  t0.fax AS fax_13,
  t0.sms AS sms_14,
  t0.email AS email_15,
  t0.budget_email AS budget_email_16,
  t0.garage_appointment_notification_emails AS garage_appointment_notification_emails_17,
  t0.timetable_morning AS timetable_morning_18,
  t0.timetable_afternoon AS timetable_afternoon_19,
  t0.timetable_saturday AS timetable_saturday_20,
  t0.works_with_collective AS works_with_collective_21,
  t0.other_services AS other_services_22,
  t0.image_name AS image_name_23,
  t0.intern_observations AS intern_observations_24,
  t0.maintenance_plans_enabled AS maintenance_plans_enabled_25,
  t0.maintenance_plans AS maintenance_plans_26,
  t0.garage_ecimage_name AS garage_ecimage_name_27,
  t0.garage_ecimage_url AS garage_ecimage_url_28,
  t0.e_commerce_warning_message AS e_commerce_warning_message_29,
  t0.legal_information AS legal_information_30,
  t0.legal_information_ca AS legal_information_ca_31,
  t0.featured_box AS featured_box_32,
  t0.featured_box_ca AS featured_box_ca_33,
  t0.facebook_url AS facebook_url_34,
  t0.twitter_url AS twitter_url_35,
  t0.instagram_url AS instagram_url_36,
  t0.e_commerce_website AS e_commerce_website_37,
  t0.catalan_language AS catalan_language_38,
  t0.points_limit AS points_limit_39,
  t0.erp AS erp_40,
  t0.gerente AS gerente_41,
  t0.allow_budget_request AS allow_budget_request_42,
  t0.allow_garage_appointment AS allow_garage_appointment_43,
  t0.grips AS grips_44,
  t0.vulco_truck_rate AS vulco_truck_rate_45,
  t0.removed_at AS removed_at_46,
  t0.created_at AS created_at_47,
  t0.updated_at AS updated_at_48,
  t0.phone AS phone_49,
  t0.published AS published_50,
  t0.site AS site_51,
  t0.user_id AS user_id_52,
  t0.address_id AS address_id_53,
  t54.street1 AS street1_55,
  t54.street2 AS street2_56,
  t54.number AS number_57,
  t54.locality AS locality_58,
  t54.zone AS zone_59,
  t54.zip_code AS zip_code_60,
  t54.lat AS lat_61,
  t54.lon AS lon_62,
  t54.show_in_site AS show_in_site_63,
  t54.phone AS phone_64,
  t54.mobile AS mobile_65,
  t54.fax AS fax_66,
  t54.email AS email_67,
  t54.timetable_morning AS timetable_morning_68,
  t54.timetable_afternoon AS timetable_afternoon_69,
  t54.timetable_saturday AS timetable_saturday_70,
  t54.removed_at AS removed_at_71,
  t54.id AS id_72,
  t54.created_at AS created_at_73,
  t54.updated_at AS updated_at_74,
  t54.site AS site_75,
  t54.province_id AS province_id_76,
  t0.schedules_id AS schedules_id_77,
  t78.monday_status AS monday_status_79,
  t78.monday_morning_begin AS monday_morning_begin_80,
  t78.monday_morning_end AS monday_morning_end_81,
  t78.monday_afternoon_begin AS monday_afternoon_begin_82,
  t78.monday_afternoon_end AS monday_afternoon_end_83,
  t78.tuesday_status AS tuesday_status_84,
  t78.tuesday_morning_begin AS tuesday_morning_begin_85,
  t78.tuesday_morning_end AS tuesday_morning_end_86,
  t78.tuesday_afternoon_begin AS tuesday_afternoon_begin_87,
  t78.tuesday_afternoon_end AS tuesday_afternoon_end_88,
  t78.wednesday_status AS wednesday_status_89,
  t78.wednesday_morning_begin AS wednesday_morning_begin_90,
  t78.wednesday_morning_end AS wednesday_morning_end_91,
  t78.wednesday_afternoon_begin AS wednesday_afternoon_begin_92,
  t78.wednesday_afternoon_end AS wednesday_afternoon_end_93,
  t78.thursday_status AS thursday_status_94,
  t78.thursday_morning_begin AS thursday_morning_begin_95,
  t78.thursday_morning_end AS thursday_morning_end_96,
  t78.thursday_afternoon_begin AS thursday_afternoon_begin_97,
  t78.thursday_afternoon_end AS thursday_afternoon_end_98,
  t78.friday_status AS friday_status_99,
  t78.friday_morning_begin AS friday_morning_begin_100,
  t78.friday_morning_end AS friday_morning_end_101,
  t78.friday_afternoon_begin AS friday_afternoon_begin_102,
  t78.friday_afternoon_end AS friday_afternoon_end_103,
  t78.saturday_status AS saturday_status_104,
  t78.saturday_morning_begin AS saturday_morning_begin_105,
  t78.saturday_morning_end AS saturday_morning_end_106,
  t78.saturday_afternoon_begin AS saturday_afternoon_begin_107,
  t78.saturday_afternoon_end AS saturday_afternoon_end_108,
  t78.sunday_status AS sunday_status_109,
  t78.sunday_morning_begin AS sunday_morning_begin_110,
  t78.sunday_morning_end AS sunday_morning_end_111,
  t78.sunday_afternoon_begin AS sunday_afternoon_begin_112,
  t78.sunday_afternoon_end AS sunday_afternoon_end_113,
  t78.removed_at AS removed_at_114,
  t78.id AS id_115,
  t78.created_at AS created_at_116,
  t78.updated_at AS updated_at_117,
  t0.garage_about_us_id AS garage_about_us_id_118,
  t119.description AS description_120,
  t119.removed_at AS removed_at_121,
  t119.id AS id_122,
  t119.created_at AS created_at_123,
  t119.updated_at AS updated_at_124,
  t119.image_name AS image_name_125,
  t119.image_name2 AS image_name2_126,
  t119.image_name3 AS image_name3_127,
  t119.image_name4 AS image_name4_128,
  t129.id AS id_130,
  t129.name AS name_131,
  t129.surnames AS surnames_132,
  t129.mail AS mail_133,
  t129.phone_service AS phone_service_134,
  t129.is_representative AS is_representative_135,
  t129.created_at AS created_at_136,
  t129.image_name AS image_name_137,
  t129.phone AS phone_138,
  t129.site AS site_139,
  t129.updated_at AS updated_at_140,
  t129.garage_id AS garage_id_141
FROM
  vulco_garage t0
  LEFT JOIN vulco_address t54 ON t0.address_id = t54.id
  AND (
    (t54.site = 'es')
    AND (t54.removed_at IS NULL)
  )
  LEFT JOIN vulco_garage_schedules t78 ON t0.schedules_id = t78.id
  AND (
    (t78.removed_at IS NULL)
  )
  LEFT JOIN vulco_garage_about_us t119 ON t0.garage_about_us_id = t119.id
  AND (
    (t119.removed_at IS NULL)
  )
  LEFT JOIN vulco_garage_owner t129 ON t129.garage_id = t0.id
WHERE
  t0.id = ?
  AND (
    (t0.published = 1)
    AND (t0.site = 'es')
    AND (t0.removed_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.cif AS cif_4, t0.slug AS slug_5, t0.company_name AS company_name_6, t0.mobile AS mobile_7, t0.mobile_associated AS mobile_associated_8, t0.whatsapp AS whatsapp_9, t0.whatsapp_campaigns AS whatsapp_campaigns_10, t0.whatsapp_campaigns_name AS whatsapp_campaigns_name_11, t0.website AS website_12, t0.fax AS fax_13, t0.sms AS sms_14, t0.email AS email_15, t0.budget_email AS budget_email_16, t0.garage_appointment_notification_emails AS garage_appointment_notification_emails_17, t0.timetable_morning AS timetable_morning_18, t0.timetable_afternoon AS timetable_afternoon_19, t0.timetable_saturday AS timetable_saturday_20, t0.works_with_collective AS works_with_collective_21, t0.other_services AS other_services_22, t0.image_name AS image_name_23, t0.intern_observations AS intern_observations_24, t0.maintenance_plans_enabled AS maintenance_plans_enabled_25, t0.maintenance_plans AS maintenance_plans_26, t0.garage_ecimage_name AS garage_ecimage_name_27, t0.garage_ecimage_url AS garage_ecimage_url_28, t0.e_commerce_warning_message AS e_commerce_warning_message_29, t0.legal_information AS legal_information_30, t0.legal_information_ca AS legal_information_ca_31, t0.featured_box AS featured_box_32, t0.featured_box_ca AS featured_box_ca_33, t0.facebook_url AS facebook_url_34, t0.twitter_url AS twitter_url_35, t0.instagram_url AS instagram_url_36, t0.e_commerce_website AS e_commerce_website_37, t0.catalan_language AS catalan_language_38, t0.points_limit AS points_limit_39, t0.erp AS erp_40, t0.gerente AS gerente_41, t0.allow_budget_request AS allow_budget_request_42, t0.allow_garage_appointment AS allow_garage_appointment_43, t0.grips AS grips_44, t0.vulco_truck_rate AS vulco_truck_rate_45, t0.removed_at AS removed_at_46, t0.created_at AS created_at_47, t0.updated_at AS updated_at_48, t0.phone AS phone_49, t0.published AS published_50, t0.site AS site_51, t0.user_id AS user_id_52, t0.address_id AS address_id_53, t54.street1 AS street1_55, t54.street2 AS street2_56, t54.number AS number_57, t54.locality AS locality_58, t54.zone AS zone_59, t54.zip_code AS zip_code_60, t54.lat AS lat_61, t54.lon AS lon_62, t54.show_in_site AS show_in_site_63, t54.phone AS phone_64, t54.mobile AS mobile_65, t54.fax AS fax_66, t54.email AS email_67, t54.timetable_morning AS timetable_morning_68, t54.timetable_afternoon AS timetable_afternoon_69, t54.timetable_saturday AS timetable_saturday_70, t54.removed_at AS removed_at_71, t54.id AS id_72, t54.created_at AS created_at_73, t54.updated_at AS updated_at_74, t54.site AS site_75, t54.province_id AS province_id_76, t0.schedules_id AS schedules_id_77, t78.monday_status AS monday_status_79, t78.monday_morning_begin AS monday_morning_begin_80, t78.monday_morning_end AS monday_morning_end_81, t78.monday_afternoon_begin AS monday_afternoon_begin_82, t78.monday_afternoon_end AS monday_afternoon_end_83, t78.tuesday_status AS tuesday_status_84, t78.tuesday_morning_begin AS tuesday_morning_begin_85, t78.tuesday_morning_end AS tuesday_morning_end_86, t78.tuesday_afternoon_begin AS tuesday_afternoon_begin_87, t78.tuesday_afternoon_end AS tuesday_afternoon_end_88, t78.wednesday_status AS wednesday_status_89, t78.wednesday_morning_begin AS wednesday_morning_begin_90, t78.wednesday_morning_end AS wednesday_morning_end_91, t78.wednesday_afternoon_begin AS wednesday_afternoon_begin_92, t78.wednesday_afternoon_end AS wednesday_afternoon_end_93, t78.thursday_status AS thursday_status_94, t78.thursday_morning_begin AS thursday_morning_begin_95, t78.thursday_morning_end AS thursday_morning_end_96, t78.thursday_afternoon_begin AS thursday_afternoon_begin_97, t78.thursday_afternoon_end AS thursday_afternoon_end_98, t78.friday_status AS friday_status_99, t78.friday_morning_begin AS friday_morning_begin_100, t78.friday_morning_end AS friday_morning_end_101, t78.friday_afternoon_begin AS friday_afternoon_begin_102, t78.friday_afternoon_end AS friday_afternoon_end_103, t78.saturday_status AS saturday_status_104, t78.saturday_morning_begin AS saturday_morning_begin_105, t78.saturday_morning_end AS saturday_morning_end_106, t78.saturday_afternoon_begin AS saturday_afternoon_begin_107, t78.saturday_afternoon_end AS saturday_afternoon_end_108, t78.sunday_status AS sunday_status_109, t78.sunday_morning_begin AS sunday_morning_begin_110, t78.sunday_morning_end AS sunday_morning_end_111, t78.sunday_afternoon_begin AS sunday_afternoon_begin_112, t78.sunday_afternoon_end AS sunday_afternoon_end_113, t78.removed_at AS removed_at_114, t78.id AS id_115, t78.created_at AS created_at_116, t78.updated_at AS updated_at_117, t0.garage_about_us_id AS garage_about_us_id_118, t119.description AS description_120, t119.removed_at AS removed_at_121, t119.id AS id_122, t119.created_at AS created_at_123, t119.updated_at AS updated_at_124, t119.image_name AS image_name_125, t119.image_name2 AS image_name2_126, t119.image_name3 AS image_name3_127, t119.image_name4 AS image_name4_128, t129.id AS id_130, t129.name AS name_131, t129.surnames AS surnames_132, t129.mail AS mail_133, t129.phone_service AS phone_service_134, t129.is_representative AS is_representative_135, t129.created_at AS created_at_136, t129.image_name AS image_name_137, t129.phone AS phone_138, t129.site AS site_139, t129.updated_at AS updated_at_140, t129.garage_id AS garage_id_141 FROM vulco_garage t0 LEFT JOIN vulco_address t54 ON t0.address_id = t54.id AND ((t54.site = 'es') AND (t54.removed_at IS NULL)) LEFT JOIN vulco_garage_schedules t78 ON t0.schedules_id = t78.id AND ((t78.removed_at IS NULL)) LEFT JOIN vulco_garage_about_us t119 ON t0.garage_about_us_id = t119.id AND ((t119.removed_at IS NULL)) LEFT JOIN vulco_garage_owner t129 ON t129.garage_id = t0.id WHERE t0.id = '181' AND ((t0.published = 1) AND (t0.site = 'es') AND (t0.removed_at IS NULL)) LIMIT 1;

SELECT
  v0_.name AS name_0,
  v0_.begin AS begin_1,
  v0_.end AS end_2,
  v0_.link AS link_3,
  v0_.removed_at AS removed_at_4,
  v0_.id AS id_5,
  v0_.created_at AS created_at_6,
  v0_.updated_at AS updated_at_7,
  v0_.image_name AS image_name_8,
  v0_.image_name2 AS image_name2_9,
  v0_.site AS site_10,
  v0_.published AS published_11,
  v0_.cooperative_media_id AS cooperative_media_id_12
FROM
  vulco_national_promotion_v2 v0_
  INNER JOIN vulco_garage v1_ ON (
    EXISTS (
      SELECT
        1
      FROM
        vulco_national_promotion_v2_garage v2_
      WHERE
        v2_.national_promotion_id = v0_.id
        AND v2_.garage_id IN (v1_.id)
    )
  )
  AND (v1_.published = 1)
  AND (v1_.site = 'es')
  AND (v1_.removed_at IS NULL)
WHERE
  (
    v1_.id = ?
    AND DATE(v0_.begin) <= DATE(?)
    AND DATE(v0_.end) >= DATE(?)
    AND v0_.published = ?
  )
  AND (v0_.site = 'es')
  AND (v0_.removed_at IS NULL)
ORDER BY
  v0_.begin DESC

SELECT v0_.name AS name_0, v0_.begin AS begin_1, v0_.end AS end_2, v0_.link AS link_3, v0_.removed_at AS removed_at_4, v0_.id AS id_5, v0_.created_at AS created_at_6, v0_.updated_at AS updated_at_7, v0_.image_name AS image_name_8, v0_.image_name2 AS image_name2_9, v0_.site AS site_10, v0_.published AS published_11, v0_.cooperative_media_id AS cooperative_media_id_12 FROM vulco_national_promotion_v2 v0_ INNER JOIN vulco_garage v1_ ON (EXISTS (SELECT 1 FROM vulco_national_promotion_v2_garage v2_ WHERE v2_.national_promotion_id = v0_.id AND v2_.garage_id IN (v1_.id))) AND (v1_.published = 1) AND (v1_.site = 'es') AND (v1_.removed_at IS NULL) WHERE (v1_.id = 181 AND DATE(v0_.begin) <= DATE('2026-01-17 12:33:09') AND DATE(v0_.end) >= DATE('2026-01-17 12:33:09') AND v0_.published = 1) AND (v0_.site = 'es') AND (v0_.removed_at IS NULL) ORDER BY v0_.begin DESC;

SELECT
  t0.name AS name_1,
  t0.removed_at AS removed_at_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.site AS site_6,
  t0.region_id AS region_id_7,
  t8.name AS name_9,
  t8.code AS code_10,
  t8.removed_at AS removed_at_11,
  t8.id AS id_12,
  t8.created_at AS created_at_13,
  t8.updated_at AS updated_at_14,
  t8.site AS site_15
FROM
  vulco_province t0
  LEFT JOIN vulco_region t8 ON t0.region_id = t8.id
  AND (
    (t8.site = 'es')
    AND (t8.removed_at IS NULL)
  )
WHERE
  t0.id IN (?)
  AND (
    (t0.site = 'es')
    AND (t0.removed_at IS NULL)
  )

SELECT t0.name AS name_1, t0.removed_at AS removed_at_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.site AS site_6, t0.region_id AS region_id_7, t8.name AS name_9, t8.code AS code_10, t8.removed_at AS removed_at_11, t8.id AS id_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.site AS site_15 FROM vulco_province t0 LEFT JOIN vulco_region t8 ON t0.region_id = t8.id AND ((t8.site = 'es') AND (t8.removed_at IS NULL)) WHERE t0.id IN (3) AND ((t0.site = 'es') AND (t0.removed_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.begin AS begin_2,
  t0.name AS name_3,
  t0.has_customer_comments_enabled AS has_customer_comments_enabled_4,
  t0.has_how_did_you_find_us_question_enabled AS has_how_did_you_find_us_question_enabled_5,
  t0.customer_comments_text_helper AS customer_comments_text_helper_6,
  t0.active AS active_7,
  t0.removed_at AS removed_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.site AS site_11
FROM
  vulco_satisfaction_survey t0
WHERE
  t0.name = ?
  AND (
    (t0.site = 'es')
    AND (t0.removed_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.begin AS begin_2, t0.name AS name_3, t0.has_customer_comments_enabled AS has_customer_comments_enabled_4, t0.has_how_did_you_find_us_question_enabled AS has_how_did_you_find_us_question_enabled_5, t0.customer_comments_text_helper AS customer_comments_text_helper_6, t0.active AS active_7, t0.removed_at AS removed_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.site AS site_11 FROM vulco_satisfaction_survey t0 WHERE t0.name = '0000-ES-default-satisfaction-survey-name' AND ((t0.site = 'es') AND (t0.removed_at IS NULL)) LIMIT 1;