Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.setting AS setting_2,
  t0.value AS value_3,
  t0.type AS type_4
FROM
  s_setting t0

SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3, t0.type AS type_4 FROM s_setting t0;

SELECT
  DISTINCT count(DISTINCT d0_.id) AS sclr_0
FROM
  d_product d0_
  INNER JOIN r_product_shipping r1_ ON d0_.id = r1_.product_id
WHERE
  d0_.active = 1
  AND r1_.qty > 0

SELECT DISTINCT count(DISTINCT d0_.id) AS sclr_0 FROM d_product d0_ INNER JOIN r_product_shipping r1_ ON d0_.id = r1_.product_id WHERE d0_.active = 1 AND r1_.qty > 0;

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.id AS id_1
FROM
  d_product d0_
  INNER JOIN r_product_shipping r1_ ON d0_.id = r1_.product_id
WHERE
  d0_.active = 1
  AND r1_.qty > 0
ORDER BY
  d0_.id DESC
LIMIT
  8

SELECT DISTINCT d0_.id AS id_0, d0_.id AS id_1 FROM d_product d0_ INNER JOIN r_product_shipping r1_ ON d0_.id = r1_.product_id WHERE d0_.active = 1 AND r1_.qty > 0 ORDER BY d0_.id DESC LIMIT 8;

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.name_en AS name_en_2,
  d0_.description AS description_3,
  d0_.description_en AS description_en_4,
  d0_.type AS type_5,
  d0_.price AS price_6,
  d0_.real_price AS real_price_7,
  d0_.promoted AS promoted_8,
  d0_.discount AS discount_9,
  d0_.tax AS tax_10,
  d0_.tax_type AS tax_type_11,
  d0_.slug AS slug_12,
  d0_.keyword AS keyword_13,
  d0_.image AS image_14,
  d0_.query_search AS query_search_15,
  d0_.conditions AS conditions_16,
  d0_.suffix AS suffix_17,
  d0_.deleted AS deleted_18,
  d0_.active AS active_19,
  d0_.created_at AS created_at_20,
  d0_.updated_at AS updated_at_21,
  d0_.provider_id AS provider_id_22
FROM
  d_product d0_
  INNER JOIN r_product_shipping r1_ ON d0_.id = r1_.product_id
WHERE
  d0_.active = 1
  AND r1_.qty > 0
  AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  d0_.id DESC

SELECT DISTINCT d0_.id AS id_0, d0_.name AS name_1, d0_.name_en AS name_en_2, d0_.description AS description_3, d0_.description_en AS description_en_4, d0_.type AS type_5, d0_.price AS price_6, d0_.real_price AS real_price_7, d0_.promoted AS promoted_8, d0_.discount AS discount_9, d0_.tax AS tax_10, d0_.tax_type AS tax_type_11, d0_.slug AS slug_12, d0_.keyword AS keyword_13, d0_.image AS image_14, d0_.query_search AS query_search_15, d0_.conditions AS conditions_16, d0_.suffix AS suffix_17, d0_.deleted AS deleted_18, d0_.active AS active_19, d0_.created_at AS created_at_20, d0_.updated_at AS updated_at_21, d0_.provider_id AS provider_id_22 FROM d_product d0_ INNER JOIN r_product_shipping r1_ ON d0_.id = r1_.product_id WHERE d0_.active = 1 AND r1_.qty > 0 AND d0_.id IN (201, 200, 199, 198, 197, 196, 195, 194) ORDER BY d0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.delivery AS delivery_3,
  t0.qty AS qty_4,
  t0.product_id AS product_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.name_en AS name_en_9,
  t6.description AS description_10,
  t6.description_en AS description_en_11,
  t6.type AS type_12,
  t6.price AS price_13,
  t6.real_price AS real_price_14,
  t6.promoted AS promoted_15,
  t6.discount AS discount_16,
  t6.tax AS tax_17,
  t6.tax_type AS tax_type_18,
  t6.slug AS slug_19,
  t6.keyword AS keyword_20,
  t6.image AS image_21,
  t6.query_search AS query_search_22,
  t6.conditions AS conditions_23,
  t6.suffix AS suffix_24,
  t6.deleted AS deleted_25,
  t6.active AS active_26,
  t6.created_at AS created_at_27,
  t6.updated_at AS updated_at_28,
  t6.provider_id AS provider_id_29,
  t0.municipality_id AS municipality_id_30,
  t31.id AS id_32,
  t31.name AS name_33,
  t31.province_id AS province_id_34
FROM
  r_product_shipping t0
  LEFT JOIN d_product t6 ON t0.product_id = t6.id
  INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.delivery AS delivery_3, t0.qty AS qty_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.name AS name_8, t6.name_en AS name_en_9, t6.description AS description_10, t6.description_en AS description_en_11, t6.type AS type_12, t6.price AS price_13, t6.real_price AS real_price_14, t6.promoted AS promoted_15, t6.discount AS discount_16, t6.tax AS tax_17, t6.tax_type AS tax_type_18, t6.slug AS slug_19, t6.keyword AS keyword_20, t6.image AS image_21, t6.query_search AS query_search_22, t6.conditions AS conditions_23, t6.suffix AS suffix_24, t6.deleted AS deleted_25, t6.active AS active_26, t6.created_at AS created_at_27, t6.updated_at AS updated_at_28, t6.provider_id AS provider_id_29, t0.municipality_id AS municipality_id_30, t31.id AS id_32, t31.name AS name_33, t31.province_id AS province_id_34 FROM r_product_shipping t0 LEFT JOIN d_product t6 ON t0.product_id = t6.id INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id WHERE t0.product_id = 201;

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.delivery AS delivery_3,
  t0.qty AS qty_4,
  t0.product_id AS product_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.name_en AS name_en_9,
  t6.description AS description_10,
  t6.description_en AS description_en_11,
  t6.type AS type_12,
  t6.price AS price_13,
  t6.real_price AS real_price_14,
  t6.promoted AS promoted_15,
  t6.discount AS discount_16,
  t6.tax AS tax_17,
  t6.tax_type AS tax_type_18,
  t6.slug AS slug_19,
  t6.keyword AS keyword_20,
  t6.image AS image_21,
  t6.query_search AS query_search_22,
  t6.conditions AS conditions_23,
  t6.suffix AS suffix_24,
  t6.deleted AS deleted_25,
  t6.active AS active_26,
  t6.created_at AS created_at_27,
  t6.updated_at AS updated_at_28,
  t6.provider_id AS provider_id_29,
  t0.municipality_id AS municipality_id_30,
  t31.id AS id_32,
  t31.name AS name_33,
  t31.province_id AS province_id_34
FROM
  r_product_shipping t0
  LEFT JOIN d_product t6 ON t0.product_id = t6.id
  INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.delivery AS delivery_3, t0.qty AS qty_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.name AS name_8, t6.name_en AS name_en_9, t6.description AS description_10, t6.description_en AS description_en_11, t6.type AS type_12, t6.price AS price_13, t6.real_price AS real_price_14, t6.promoted AS promoted_15, t6.discount AS discount_16, t6.tax AS tax_17, t6.tax_type AS tax_type_18, t6.slug AS slug_19, t6.keyword AS keyword_20, t6.image AS image_21, t6.query_search AS query_search_22, t6.conditions AS conditions_23, t6.suffix AS suffix_24, t6.deleted AS deleted_25, t6.active AS active_26, t6.created_at AS created_at_27, t6.updated_at AS updated_at_28, t6.provider_id AS provider_id_29, t0.municipality_id AS municipality_id_30, t31.id AS id_32, t31.name AS name_33, t31.province_id AS province_id_34 FROM r_product_shipping t0 LEFT JOIN d_product t6 ON t0.product_id = t6.id INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id WHERE t0.product_id = 200;

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.delivery AS delivery_3,
  t0.qty AS qty_4,
  t0.product_id AS product_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.name_en AS name_en_9,
  t6.description AS description_10,
  t6.description_en AS description_en_11,
  t6.type AS type_12,
  t6.price AS price_13,
  t6.real_price AS real_price_14,
  t6.promoted AS promoted_15,
  t6.discount AS discount_16,
  t6.tax AS tax_17,
  t6.tax_type AS tax_type_18,
  t6.slug AS slug_19,
  t6.keyword AS keyword_20,
  t6.image AS image_21,
  t6.query_search AS query_search_22,
  t6.conditions AS conditions_23,
  t6.suffix AS suffix_24,
  t6.deleted AS deleted_25,
  t6.active AS active_26,
  t6.created_at AS created_at_27,
  t6.updated_at AS updated_at_28,
  t6.provider_id AS provider_id_29,
  t0.municipality_id AS municipality_id_30,
  t31.id AS id_32,
  t31.name AS name_33,
  t31.province_id AS province_id_34
FROM
  r_product_shipping t0
  LEFT JOIN d_product t6 ON t0.product_id = t6.id
  INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.delivery AS delivery_3, t0.qty AS qty_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.name AS name_8, t6.name_en AS name_en_9, t6.description AS description_10, t6.description_en AS description_en_11, t6.type AS type_12, t6.price AS price_13, t6.real_price AS real_price_14, t6.promoted AS promoted_15, t6.discount AS discount_16, t6.tax AS tax_17, t6.tax_type AS tax_type_18, t6.slug AS slug_19, t6.keyword AS keyword_20, t6.image AS image_21, t6.query_search AS query_search_22, t6.conditions AS conditions_23, t6.suffix AS suffix_24, t6.deleted AS deleted_25, t6.active AS active_26, t6.created_at AS created_at_27, t6.updated_at AS updated_at_28, t6.provider_id AS provider_id_29, t0.municipality_id AS municipality_id_30, t31.id AS id_32, t31.name AS name_33, t31.province_id AS province_id_34 FROM r_product_shipping t0 LEFT JOIN d_product t6 ON t0.product_id = t6.id INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id WHERE t0.product_id = 199;

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.delivery AS delivery_3,
  t0.qty AS qty_4,
  t0.product_id AS product_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.name_en AS name_en_9,
  t6.description AS description_10,
  t6.description_en AS description_en_11,
  t6.type AS type_12,
  t6.price AS price_13,
  t6.real_price AS real_price_14,
  t6.promoted AS promoted_15,
  t6.discount AS discount_16,
  t6.tax AS tax_17,
  t6.tax_type AS tax_type_18,
  t6.slug AS slug_19,
  t6.keyword AS keyword_20,
  t6.image AS image_21,
  t6.query_search AS query_search_22,
  t6.conditions AS conditions_23,
  t6.suffix AS suffix_24,
  t6.deleted AS deleted_25,
  t6.active AS active_26,
  t6.created_at AS created_at_27,
  t6.updated_at AS updated_at_28,
  t6.provider_id AS provider_id_29,
  t0.municipality_id AS municipality_id_30,
  t31.id AS id_32,
  t31.name AS name_33,
  t31.province_id AS province_id_34
FROM
  r_product_shipping t0
  LEFT JOIN d_product t6 ON t0.product_id = t6.id
  INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.delivery AS delivery_3, t0.qty AS qty_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.name AS name_8, t6.name_en AS name_en_9, t6.description AS description_10, t6.description_en AS description_en_11, t6.type AS type_12, t6.price AS price_13, t6.real_price AS real_price_14, t6.promoted AS promoted_15, t6.discount AS discount_16, t6.tax AS tax_17, t6.tax_type AS tax_type_18, t6.slug AS slug_19, t6.keyword AS keyword_20, t6.image AS image_21, t6.query_search AS query_search_22, t6.conditions AS conditions_23, t6.suffix AS suffix_24, t6.deleted AS deleted_25, t6.active AS active_26, t6.created_at AS created_at_27, t6.updated_at AS updated_at_28, t6.provider_id AS provider_id_29, t0.municipality_id AS municipality_id_30, t31.id AS id_32, t31.name AS name_33, t31.province_id AS province_id_34 FROM r_product_shipping t0 LEFT JOIN d_product t6 ON t0.product_id = t6.id INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id WHERE t0.product_id = 198;

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.delivery AS delivery_3,
  t0.qty AS qty_4,
  t0.product_id AS product_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.name_en AS name_en_9,
  t6.description AS description_10,
  t6.description_en AS description_en_11,
  t6.type AS type_12,
  t6.price AS price_13,
  t6.real_price AS real_price_14,
  t6.promoted AS promoted_15,
  t6.discount AS discount_16,
  t6.tax AS tax_17,
  t6.tax_type AS tax_type_18,
  t6.slug AS slug_19,
  t6.keyword AS keyword_20,
  t6.image AS image_21,
  t6.query_search AS query_search_22,
  t6.conditions AS conditions_23,
  t6.suffix AS suffix_24,
  t6.deleted AS deleted_25,
  t6.active AS active_26,
  t6.created_at AS created_at_27,
  t6.updated_at AS updated_at_28,
  t6.provider_id AS provider_id_29,
  t0.municipality_id AS municipality_id_30,
  t31.id AS id_32,
  t31.name AS name_33,
  t31.province_id AS province_id_34
FROM
  r_product_shipping t0
  LEFT JOIN d_product t6 ON t0.product_id = t6.id
  INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.delivery AS delivery_3, t0.qty AS qty_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.name AS name_8, t6.name_en AS name_en_9, t6.description AS description_10, t6.description_en AS description_en_11, t6.type AS type_12, t6.price AS price_13, t6.real_price AS real_price_14, t6.promoted AS promoted_15, t6.discount AS discount_16, t6.tax AS tax_17, t6.tax_type AS tax_type_18, t6.slug AS slug_19, t6.keyword AS keyword_20, t6.image AS image_21, t6.query_search AS query_search_22, t6.conditions AS conditions_23, t6.suffix AS suffix_24, t6.deleted AS deleted_25, t6.active AS active_26, t6.created_at AS created_at_27, t6.updated_at AS updated_at_28, t6.provider_id AS provider_id_29, t0.municipality_id AS municipality_id_30, t31.id AS id_32, t31.name AS name_33, t31.province_id AS province_id_34 FROM r_product_shipping t0 LEFT JOIN d_product t6 ON t0.product_id = t6.id INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id WHERE t0.product_id = 197;

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.delivery AS delivery_3,
  t0.qty AS qty_4,
  t0.product_id AS product_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.name_en AS name_en_9,
  t6.description AS description_10,
  t6.description_en AS description_en_11,
  t6.type AS type_12,
  t6.price AS price_13,
  t6.real_price AS real_price_14,
  t6.promoted AS promoted_15,
  t6.discount AS discount_16,
  t6.tax AS tax_17,
  t6.tax_type AS tax_type_18,
  t6.slug AS slug_19,
  t6.keyword AS keyword_20,
  t6.image AS image_21,
  t6.query_search AS query_search_22,
  t6.conditions AS conditions_23,
  t6.suffix AS suffix_24,
  t6.deleted AS deleted_25,
  t6.active AS active_26,
  t6.created_at AS created_at_27,
  t6.updated_at AS updated_at_28,
  t6.provider_id AS provider_id_29,
  t0.municipality_id AS municipality_id_30,
  t31.id AS id_32,
  t31.name AS name_33,
  t31.province_id AS province_id_34
FROM
  r_product_shipping t0
  LEFT JOIN d_product t6 ON t0.product_id = t6.id
  INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.delivery AS delivery_3, t0.qty AS qty_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.name AS name_8, t6.name_en AS name_en_9, t6.description AS description_10, t6.description_en AS description_en_11, t6.type AS type_12, t6.price AS price_13, t6.real_price AS real_price_14, t6.promoted AS promoted_15, t6.discount AS discount_16, t6.tax AS tax_17, t6.tax_type AS tax_type_18, t6.slug AS slug_19, t6.keyword AS keyword_20, t6.image AS image_21, t6.query_search AS query_search_22, t6.conditions AS conditions_23, t6.suffix AS suffix_24, t6.deleted AS deleted_25, t6.active AS active_26, t6.created_at AS created_at_27, t6.updated_at AS updated_at_28, t6.provider_id AS provider_id_29, t0.municipality_id AS municipality_id_30, t31.id AS id_32, t31.name AS name_33, t31.province_id AS province_id_34 FROM r_product_shipping t0 LEFT JOIN d_product t6 ON t0.product_id = t6.id INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id WHERE t0.product_id = 196;

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.delivery AS delivery_3,
  t0.qty AS qty_4,
  t0.product_id AS product_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.name_en AS name_en_9,
  t6.description AS description_10,
  t6.description_en AS description_en_11,
  t6.type AS type_12,
  t6.price AS price_13,
  t6.real_price AS real_price_14,
  t6.promoted AS promoted_15,
  t6.discount AS discount_16,
  t6.tax AS tax_17,
  t6.tax_type AS tax_type_18,
  t6.slug AS slug_19,
  t6.keyword AS keyword_20,
  t6.image AS image_21,
  t6.query_search AS query_search_22,
  t6.conditions AS conditions_23,
  t6.suffix AS suffix_24,
  t6.deleted AS deleted_25,
  t6.active AS active_26,
  t6.created_at AS created_at_27,
  t6.updated_at AS updated_at_28,
  t6.provider_id AS provider_id_29,
  t0.municipality_id AS municipality_id_30,
  t31.id AS id_32,
  t31.name AS name_33,
  t31.province_id AS province_id_34
FROM
  r_product_shipping t0
  LEFT JOIN d_product t6 ON t0.product_id = t6.id
  INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.delivery AS delivery_3, t0.qty AS qty_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.name AS name_8, t6.name_en AS name_en_9, t6.description AS description_10, t6.description_en AS description_en_11, t6.type AS type_12, t6.price AS price_13, t6.real_price AS real_price_14, t6.promoted AS promoted_15, t6.discount AS discount_16, t6.tax AS tax_17, t6.tax_type AS tax_type_18, t6.slug AS slug_19, t6.keyword AS keyword_20, t6.image AS image_21, t6.query_search AS query_search_22, t6.conditions AS conditions_23, t6.suffix AS suffix_24, t6.deleted AS deleted_25, t6.active AS active_26, t6.created_at AS created_at_27, t6.updated_at AS updated_at_28, t6.provider_id AS provider_id_29, t0.municipality_id AS municipality_id_30, t31.id AS id_32, t31.name AS name_33, t31.province_id AS province_id_34 FROM r_product_shipping t0 LEFT JOIN d_product t6 ON t0.product_id = t6.id INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id WHERE t0.product_id = 195;

SELECT
  t0.id AS id_1,
  t0.cost AS cost_2,
  t0.delivery AS delivery_3,
  t0.qty AS qty_4,
  t0.product_id AS product_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.name_en AS name_en_9,
  t6.description AS description_10,
  t6.description_en AS description_en_11,
  t6.type AS type_12,
  t6.price AS price_13,
  t6.real_price AS real_price_14,
  t6.promoted AS promoted_15,
  t6.discount AS discount_16,
  t6.tax AS tax_17,
  t6.tax_type AS tax_type_18,
  t6.slug AS slug_19,
  t6.keyword AS keyword_20,
  t6.image AS image_21,
  t6.query_search AS query_search_22,
  t6.conditions AS conditions_23,
  t6.suffix AS suffix_24,
  t6.deleted AS deleted_25,
  t6.active AS active_26,
  t6.created_at AS created_at_27,
  t6.updated_at AS updated_at_28,
  t6.provider_id AS provider_id_29,
  t0.municipality_id AS municipality_id_30,
  t31.id AS id_32,
  t31.name AS name_33,
  t31.province_id AS province_id_34
FROM
  r_product_shipping t0
  LEFT JOIN d_product t6 ON t0.product_id = t6.id
  INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.cost AS cost_2, t0.delivery AS delivery_3, t0.qty AS qty_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.name AS name_8, t6.name_en AS name_en_9, t6.description AS description_10, t6.description_en AS description_en_11, t6.type AS type_12, t6.price AS price_13, t6.real_price AS real_price_14, t6.promoted AS promoted_15, t6.discount AS discount_16, t6.tax AS tax_17, t6.tax_type AS tax_type_18, t6.slug AS slug_19, t6.keyword AS keyword_20, t6.image AS image_21, t6.query_search AS query_search_22, t6.conditions AS conditions_23, t6.suffix AS suffix_24, t6.deleted AS deleted_25, t6.active AS active_26, t6.created_at AS created_at_27, t6.updated_at AS updated_at_28, t6.provider_id AS provider_id_29, t0.municipality_id AS municipality_id_30, t31.id AS id_32, t31.name AS name_33, t31.province_id AS province_id_34 FROM r_product_shipping t0 LEFT JOIN d_product t6 ON t0.product_id = t6.id INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id WHERE t0.product_id = 194;