Symfony Profiler

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;

SELECT
  v0_.reference AS reference_0,
  v0_.name AS name_1,
  v0_.description AS description_2,
  v0_.rate_price_amount AS rate_price_amount_3,
  v0_.rate_price_currency AS rate_price_currency_4,
  v0_.cost_price AS cost_price_5,
  v0_.pvp_price AS pvp_price_6,
  v0_.sale_price AS sale_price_7,
  v0_.position_group AS position_group_8,
  v0_.sigaus AS sigaus_9,
  v0_.green_point AS green_point_10,
  v0_.eco_tax AS eco_tax_11,
  v0_.weight AS weight_12,
  v0_.transport_points AS transport_points_13,
  v0_.promotion AS promotion_14,
  v0_.image_url AS image_url_15,
  v0_.supplier_reference AS supplier_reference_16,
  v0_.volume AS volume_17,
  v0_.units AS units_18,
  v0_.image_name AS image_name_19,
  v0_.document_name AS document_name_20,
  v0_.document_real_name AS document_real_name_21,
  v0_.no_lineal_discount_enabled AS no_lineal_discount_enabled_22,
  v0_.only_admin_visible AS only_admin_visible_23,
  v0_.featured AS featured_24,
  v0_.meta_catalog AS meta_catalog_25,
  v0_.removed_at AS removed_at_26,
  v0_.id AS id_27,
  v0_.created_at AS created_at_28,
  v0_.updated_at AS updated_at_29,
  v0_.published AS published_30,
  v0_.site AS site_31,
  v0_.family_id AS family_id_32
FROM
  vulco_product v0_
  INNER JOIN vulco_family v1_ ON v0_.family_id = v1_.id
  AND (v1_.published = 1)
  AND (v1_.site = 'es')
  AND (v1_.removed_at IS NULL)
  AND (v1_.published = 1)
  INNER JOIN vulco_supplier v2_ ON v1_.supplier_id = v2_.id
  AND (v2_.published = 1)
  AND (v2_.site = 'es')
  AND (v2_.removed_at IS NULL)
WHERE
  (
    v0_.published = 1
    AND v0_.only_admin_visible = 0
    AND v0_.meta_catalog = 1
    AND v0_.site = ?
  )
  AND (v0_.published = 1)
  AND (v0_.site = 'es')
  AND (v0_.removed_at IS NULL)
ORDER BY
  v0_.id ASC

SELECT v0_.reference AS reference_0, v0_.name AS name_1, v0_.description AS description_2, v0_.rate_price_amount AS rate_price_amount_3, v0_.rate_price_currency AS rate_price_currency_4, v0_.cost_price AS cost_price_5, v0_.pvp_price AS pvp_price_6, v0_.sale_price AS sale_price_7, v0_.position_group AS position_group_8, v0_.sigaus AS sigaus_9, v0_.green_point AS green_point_10, v0_.eco_tax AS eco_tax_11, v0_.weight AS weight_12, v0_.transport_points AS transport_points_13, v0_.promotion AS promotion_14, v0_.image_url AS image_url_15, v0_.supplier_reference AS supplier_reference_16, v0_.volume AS volume_17, v0_.units AS units_18, v0_.image_name AS image_name_19, v0_.document_name AS document_name_20, v0_.document_real_name AS document_real_name_21, v0_.no_lineal_discount_enabled AS no_lineal_discount_enabled_22, v0_.only_admin_visible AS only_admin_visible_23, v0_.featured AS featured_24, v0_.meta_catalog AS meta_catalog_25, v0_.removed_at AS removed_at_26, v0_.id AS id_27, v0_.created_at AS created_at_28, v0_.updated_at AS updated_at_29, v0_.published AS published_30, v0_.site AS site_31, v0_.family_id AS family_id_32 FROM vulco_product v0_ INNER JOIN vulco_family v1_ ON v0_.family_id = v1_.id AND (v1_.published = 1) AND (v1_.site = 'es') AND (v1_.removed_at IS NULL) AND (v1_.published = 1) INNER JOIN vulco_supplier v2_ ON v1_.supplier_id = v2_.id AND (v2_.published = 1) AND (v2_.site = 'es') AND (v2_.removed_at IS NULL) WHERE (v0_.published = 1 AND v0_.only_admin_visible = 0 AND v0_.meta_catalog = 1 AND v0_.site = 'es') AND (v0_.published = 1) AND (v0_.site = 'es') AND (v0_.removed_at IS NULL) ORDER BY v0_.id ASC;

SELECT
  t0.name AS name_1,
  t0.user_group_access_type AS user_group_access_type_2,
  t0.user_access_type AS user_access_type_3,
  t0.removed_at AS removed_at_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.published AS published_8,
  t0.site AS site_9,
  t0.supplier_id AS supplier_id_10,
  t11.legal_name AS legal_name_12,
  t11.commercial_name AS commercial_name_13,
  t11.address AS address_14,
  t11.fax AS fax_15,
  t11.website AS website_16,
  t11.contact_person AS contact_person_17,
  t11.contact_email AS contact_email_18,
  t11.order_email AS order_email_19,
  t11.order_cc_email AS order_cc_email_20,
  t11.image_url AS image_url_21,
  t11.delivery_time AS delivery_time_22,
  t11.shipment_type AS shipment_type_23,
  t11.fixed_shipment_cost AS fixed_shipment_cost_24,
  t11.fixed_shipment_min_order AS fixed_shipment_min_order_25,
  t11.fixed_shipment_min_order_type AS fixed_shipment_min_order_type_26,
  t11.fixed_shipment_to_do_not_in_min_order_type AS fixed_shipment_to_do_not_in_min_order_type_27,
  t11.scale_shipment_min_points_to_block_order AS scale_shipment_min_points_to_block_order_28,
  t11.scale_shipment_min_points_to_free_shipment AS scale_shipment_min_points_to_free_shipment_29,
  t11.image_name AS image_name_30,
  t11.rappel_central_vulco AS rappel_central_vulco_31,
  t11.rappel_percentage AS rappel_percentage_32,
  t11.rappel_text AS rappel_text_33,
  t11.removed_at AS removed_at_34,
  t11.id AS id_35,
  t11.created_at AS created_at_36,
  t11.updated_at AS updated_at_37,
  t11.phone AS phone_38,
  t11.published AS published_39,
  t11.site AS site_40,
  t11.user_id AS user_id_41,
  t0.super_family_id AS super_family_id_42,
  t43.name AS name_44,
  t43.position AS position_45,
  t43.removed_at AS removed_at_46,
  t43.id AS id_47,
  t43.created_at AS created_at_48,
  t43.updated_at AS updated_at_49,
  t43.published AS published_50,
  t43.site AS site_51,
  t0.family_no_lineal_discount_id AS family_no_lineal_discount_id_52
FROM
  vulco_family t0
  LEFT JOIN vulco_supplier t11 ON t0.supplier_id = t11.id
  AND (
    (t11.published = 1)
    AND (t11.site = 'es')
    AND (t11.removed_at IS NULL)
  )
  LEFT JOIN vulco_super_family t43 ON t0.super_family_id = t43.id
  AND (
    (t43.published = 1)
    AND (t43.site = 'es')
    AND (t43.removed_at IS NULL)
  )
WHERE
  t0.id IN (?)
  AND (
    (t0.published = 1)
    AND (t0.site = 'es')
    AND (t0.removed_at IS NULL)
  )

SELECT t0.name AS name_1, t0.user_group_access_type AS user_group_access_type_2, t0.user_access_type AS user_access_type_3, t0.removed_at AS removed_at_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published AS published_8, t0.site AS site_9, t0.supplier_id AS supplier_id_10, t11.legal_name AS legal_name_12, t11.commercial_name AS commercial_name_13, t11.address AS address_14, t11.fax AS fax_15, t11.website AS website_16, t11.contact_person AS contact_person_17, t11.contact_email AS contact_email_18, t11.order_email AS order_email_19, t11.order_cc_email AS order_cc_email_20, t11.image_url AS image_url_21, t11.delivery_time AS delivery_time_22, t11.shipment_type AS shipment_type_23, t11.fixed_shipment_cost AS fixed_shipment_cost_24, t11.fixed_shipment_min_order AS fixed_shipment_min_order_25, t11.fixed_shipment_min_order_type AS fixed_shipment_min_order_type_26, t11.fixed_shipment_to_do_not_in_min_order_type AS fixed_shipment_to_do_not_in_min_order_type_27, t11.scale_shipment_min_points_to_block_order AS scale_shipment_min_points_to_block_order_28, t11.scale_shipment_min_points_to_free_shipment AS scale_shipment_min_points_to_free_shipment_29, t11.image_name AS image_name_30, t11.rappel_central_vulco AS rappel_central_vulco_31, t11.rappel_percentage AS rappel_percentage_32, t11.rappel_text AS rappel_text_33, t11.removed_at AS removed_at_34, t11.id AS id_35, t11.created_at AS created_at_36, t11.updated_at AS updated_at_37, t11.phone AS phone_38, t11.published AS published_39, t11.site AS site_40, t11.user_id AS user_id_41, t0.super_family_id AS super_family_id_42, t43.name AS name_44, t43.position AS position_45, t43.removed_at AS removed_at_46, t43.id AS id_47, t43.created_at AS created_at_48, t43.updated_at AS updated_at_49, t43.published AS published_50, t43.site AS site_51, t0.family_no_lineal_discount_id AS family_no_lineal_discount_id_52 FROM vulco_family t0 LEFT JOIN vulco_supplier t11 ON t0.supplier_id = t11.id AND ((t11.published = 1) AND (t11.site = 'es') AND (t11.removed_at IS NULL)) LEFT JOIN vulco_super_family t43 ON t0.super_family_id = t43.id AND ((t43.published = 1) AND (t43.site = 'es') AND (t43.removed_at IS NULL)) WHERE t0.id IN (162) AND ((t0.published = 1) AND (t0.site = 'es') AND (t0.removed_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.document_name AS document_name_2,
  t0.document_type AS document_type_3,
  t0.num_downloads AS num_downloads_4,
  t0.start_date AS start_date_5,
  t0.end_date AS end_date_6,
  t0.removed_at AS removed_at_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.supplier_category_id AS supplier_category_id_11,
  t0.supplier_id AS supplier_id_12
FROM
  vulco_supplier_document t0
WHERE
  t0.supplier_id = ?
  AND (
    (t0.removed_at IS NULL)
  )
ORDER BY
  t0.created_at DESC

SELECT t0.name AS name_1, t0.document_name AS document_name_2, t0.document_type AS document_type_3, t0.num_downloads AS num_downloads_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.removed_at AS removed_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.supplier_category_id AS supplier_category_id_11, t0.supplier_id AS supplier_id_12 FROM vulco_supplier_document t0 WHERE t0.supplier_id = 97 AND ((t0.removed_at IS NULL)) ORDER BY t0.created_at DESC;