Symfony Profiler

SELECT
  t0.id_lang AS id_lang_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso_code AS iso_code_4,
  t0.language_code AS language_code_5,
  t0.date_format_lite AS date_format_lite_6,
  t0.date_format_full AS date_format_full_7,
  t0.dictionary AS dictionary_8,
  t0.currency_format AS currency_format_9,
  t0.iso_code_real AS iso_code_real_10,
  t0.name_english AS name_english_11
FROM
  ps_lang t0
WHERE
  t0.iso_code = ?
LIMIT
  1

SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = 'lv' LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  p0_.id AS id_0,
  p0_.meta_title AS meta_title_1,
  p0_.meta_description AS meta_description_2,
  p0_.name AS name_3,
  p0_.meta_keywords AS meta_keywords_4,
  p0_.content AS content_5,
  p0_.link_rewrite AS link_rewrite_6,
  p0_.redirect AS redirect_7,
  p0_.id_cms AS id_cms_8,
  p0_.id_lang AS id_lang_9
FROM
  ps_cms_lang p0_
  INNER JOIN ps_cms p1_ ON p0_.id_cms = p1_.id_cms
WHERE
  p0_.link_rewrite = ?
  AND p0_.id_lang = ?

SELECT p0_.id AS id_0, p0_.meta_title AS meta_title_1, p0_.meta_description AS meta_description_2, p0_.name AS name_3, p0_.meta_keywords AS meta_keywords_4, p0_.content AS content_5, p0_.link_rewrite AS link_rewrite_6, p0_.redirect AS redirect_7, p0_.id_cms AS id_cms_8, p0_.id_lang AS id_lang_9 FROM ps_cms_lang p0_ INNER JOIN ps_cms p1_ ON p0_.id_cms = p1_.id_cms WHERE p0_.link_rewrite = 'vispardotakas.html' AND p0_.id_lang = 21;

SELECT
  t0.id_cms AS id_cms_1,
  t0.id_cms_block AS id_cms_block_2,
  t0.position AS position_3,
  t0.tpl AS tpl_4,
  t0.mainNavLinkActive AS mainNavLinkActive_5,
  t0.facebook_img AS facebook_img_6,
  t0.notes AS notes_7,
  t0.legacy AS legacy_8,
  t0.active AS active_9
FROM
  ps_cms t0
WHERE
  t0.id_cms = ?

SELECT t0.id_cms AS id_cms_1, t0.id_cms_block AS id_cms_block_2, t0.position AS position_3, t0.tpl AS tpl_4, t0.mainNavLinkActive AS mainNavLinkActive_5, t0.facebook_img AS facebook_img_6, t0.notes AS notes_7, t0.legacy AS legacy_8, t0.active AS active_9 FROM ps_cms t0 WHERE t0.id_cms = 25;

SELECT
  t0.id_cart AS id_cart_1,
  t0.delivery_option AS delivery_option_2,
  t0.id_lang AS id_lang_3,
  t0.id_currency AS id_currency_4,
  t0.id_guest AS id_guest_5,
  t0.secure_key AS secure_key_6,
  t0.recyclable AS recyclable_7,
  t0.date_upd AS date_upd_8,
  t0.date_add AS date_add_9,
  t0.is_virtual AS is_virtual_10,
  t0.is_sync AS is_sync_11,
  t0.id_sincronate_shop_configuration AS id_sincronate_shop_configuration_12,
  t0.is_mobile AS is_mobile_13,
  t0.dropshipping AS dropshipping_14,
  t0.payment AS payment_15,
  t0.payment_method_type AS payment_method_type_16,
  t0.payment_method_id AS payment_method_id_17,
  t0.pack_stored_payment_method_id AS pack_stored_payment_method_id_18,
  t0.services_stored_payment_method_id AS services_stored_payment_method_id_19,
  t0.total_products AS total_products_20,
  t0.total_envio AS total_envio_21,
  t0.logistic_weight AS logistic_weight_22,
  t0.carrier_comment AS carrier_comment_23,
  t0.ref_order_supplier AS ref_order_supplier_24,
  t0.is_system AS is_system_25,
  t0.selling_channel AS selling_channel_26,
  t0.additional_parameters AS additional_parameters_27,
  t0.date_amazon AS date_amazon_28,
  t0.fba AS fba_29,
  t0.max_delivery_datetime AS max_delivery_datetime_30,
  t0.max_expedition_datetime AS max_expedition_datetime_31,
  t0.shipment_choices AS shipment_choices_32,
  t0.id_order AS id_order_33,
  t0.id_carrier AS id_carrier_34,
  t0.id_address_delivery AS id_address_delivery_35,
  t0.id_address_invoice AS id_address_invoice_36,
  t0.id_customer AS id_customer_37,
  t0.pack_payment_method_id AS pack_payment_method_id_38,
  t0.services_payment_method_id AS services_payment_method_id_39,
  t0.code_discount_id AS code_discount_id_40,
  t0.cart_parent_id AS cart_parent_id_41
FROM
  ps_cart t0
WHERE
  t0.id_cart = ?

SELECT t0.id_cart AS id_cart_1, t0.delivery_option AS delivery_option_2, t0.id_lang AS id_lang_3, t0.id_currency AS id_currency_4, t0.id_guest AS id_guest_5, t0.secure_key AS secure_key_6, t0.recyclable AS recyclable_7, t0.date_upd AS date_upd_8, t0.date_add AS date_add_9, t0.is_virtual AS is_virtual_10, t0.is_sync AS is_sync_11, t0.id_sincronate_shop_configuration AS id_sincronate_shop_configuration_12, t0.is_mobile AS is_mobile_13, t0.dropshipping AS dropshipping_14, t0.payment AS payment_15, t0.payment_method_type AS payment_method_type_16, t0.payment_method_id AS payment_method_id_17, t0.pack_stored_payment_method_id AS pack_stored_payment_method_id_18, t0.services_stored_payment_method_id AS services_stored_payment_method_id_19, t0.total_products AS total_products_20, t0.total_envio AS total_envio_21, t0.logistic_weight AS logistic_weight_22, t0.carrier_comment AS carrier_comment_23, t0.ref_order_supplier AS ref_order_supplier_24, t0.is_system AS is_system_25, t0.selling_channel AS selling_channel_26, t0.additional_parameters AS additional_parameters_27, t0.date_amazon AS date_amazon_28, t0.fba AS fba_29, t0.max_delivery_datetime AS max_delivery_datetime_30, t0.max_expedition_datetime AS max_expedition_datetime_31, t0.shipment_choices AS shipment_choices_32, t0.id_order AS id_order_33, t0.id_carrier AS id_carrier_34, t0.id_address_delivery AS id_address_delivery_35, t0.id_address_invoice AS id_address_invoice_36, t0.id_customer AS id_customer_37, t0.pack_payment_method_id AS pack_payment_method_id_38, t0.services_payment_method_id AS services_payment_method_id_39, t0.code_discount_id AS code_discount_id_40, t0.cart_parent_id AS cart_parent_id_41 FROM ps_cart t0 WHERE t0.id_cart = 0;

SELECT
  t0_.id_taxonomy AS id_taxonomy_0,
  t0_.id_parent AS id_parent_1,
  t0_.name AS name_2,
  t0_.description AS description_3,
  t0_.link_rewrite AS link_rewrite_4,
  t0_.product_count AS product_count_5,
  t0_.id_image AS id_image_6,
  t0_.image_name AS image_name_7,
  t0_.is_gif AS is_gif_8
FROM
  taxonomy_info t0_
WHERE
  t0_.id_language = ?
  AND t0_.id_taxonomy NOT IN (?)
ORDER BY
  t0_.name ASC

SELECT t0_.id_taxonomy AS id_taxonomy_0, t0_.id_parent AS id_parent_1, t0_.name AS name_2, t0_.description AS description_3, t0_.link_rewrite AS link_rewrite_4, t0_.product_count AS product_count_5, t0_.id_image AS id_image_6, t0_.image_name AS image_name_7, t0_.is_gif AS is_gif_8 FROM taxonomy_info t0_ WHERE t0_.id_language = 21 AND t0_.id_taxonomy NOT IN (31548) ORDER BY t0_.name ASC;

SELECT
  t0.id_lang AS id_lang_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso_code AS iso_code_4,
  t0.language_code AS language_code_5,
  t0.date_format_lite AS date_format_lite_6,
  t0.date_format_full AS date_format_full_7,
  t0.dictionary AS dictionary_8,
  t0.currency_format AS currency_format_9,
  t0.iso_code_real AS iso_code_real_10,
  t0.name_english AS name_english_11
FROM
  ps_lang t0
WHERE
  t0.iso_code = ?
LIMIT
  1

SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = 'lv' LIMIT 1;

SELECT
  t0.id_lang AS id_lang_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso_code AS iso_code_4,
  t0.language_code AS language_code_5,
  t0.date_format_lite AS date_format_lite_6,
  t0.date_format_full AS date_format_full_7,
  t0.dictionary AS dictionary_8,
  t0.currency_format AS currency_format_9,
  t0.iso_code_real AS iso_code_real_10,
  t0.name_english AS name_english_11
FROM
  ps_lang t0
WHERE
  t0.iso_code = ?
LIMIT
  1

SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = 'lv' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.parent AS sclr_1,
  m0_.link_type AS link_type_2,
  m0_.link_value AS link_value_3,
  m0_.tag AS tag_4,
  m0_.number_columns AS number_columns_5,
  m0_.colspan AS colspan_6,
  m0_.additional AS additional_7,
  m0_.icon AS icon_8,
  m0_.target AS target_9,
  IF(
    m1_.title IS NULL
    OR m1_.title = '',
    IF(
      m2_.title IS NULL
      OR m2_.title = '',
      IF(
        m3_.title IS NULL
        OR m3_.title = '',
        '',
        m3_.title
      ),
      m2_.title
    ),
    m1_.title
  ) AS sclr_10,
  IF(
    m1_.subtitle IS NULL
    OR m1_.subtitle = '',
    IF(
      m2_.subtitle IS NULL
      OR m2_.subtitle = '',
      IF(
        m3_.subtitle IS NULL
        OR m3_.subtitle = '',
        '',
        m3_.subtitle
      ),
      m2_.subtitle
    ),
    m1_.subtitle
  ) AS sclr_11
FROM
  menu_item m0_
  LEFT JOIN menu_item_lang m1_ ON m0_.id = m1_.menu_item_id
  AND (m1_.language_id = ?)
  LEFT JOIN menu_item_lang m2_ ON m0_.id = m2_.menu_item_id
  AND (m2_.language_id = 1)
  LEFT JOIN menu_item_lang m3_ ON m0_.id = m3_.menu_item_id
  AND (m3_.language_id = 4)
WHERE
  m0_.menu_id = ?
  AND m0_.visibility = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.parent AS sclr_1, m0_.link_type AS link_type_2, m0_.link_value AS link_value_3, m0_.tag AS tag_4, m0_.number_columns AS number_columns_5, m0_.colspan AS colspan_6, m0_.additional AS additional_7, m0_.icon AS icon_8, m0_.target AS target_9, IF(m1_.title IS NULL OR m1_.title = '', IF(m2_.title IS NULL OR m2_.title = '', IF(m3_.title IS NULL OR m3_.title = '', '', m3_.title), m2_.title), m1_.title) AS sclr_10, IF(m1_.subtitle IS NULL OR m1_.subtitle = '', IF(m2_.subtitle IS NULL OR m2_.subtitle = '', IF(m3_.subtitle IS NULL OR m3_.subtitle = '', '', m3_.subtitle), m2_.subtitle), m1_.subtitle) AS sclr_11 FROM menu_item m0_ LEFT JOIN menu_item_lang m1_ ON m0_.id = m1_.menu_item_id AND (m1_.language_id = 21) LEFT JOIN menu_item_lang m2_ ON m0_.id = m2_.menu_item_id AND (m2_.language_id = 1) LEFT JOIN menu_item_lang m3_ ON m0_.id = m3_.menu_item_id AND (m3_.language_id = 4) WHERE m0_.menu_id = 1 AND m0_.visibility = 1 ORDER BY m0_.position ASC;

SELECT
  t0.id_lang AS id_lang_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso_code AS iso_code_4,
  t0.language_code AS language_code_5,
  t0.date_format_lite AS date_format_lite_6,
  t0.date_format_full AS date_format_full_7,
  t0.dictionary AS dictionary_8,
  t0.currency_format AS currency_format_9,
  t0.iso_code_real AS iso_code_real_10,
  t0.name_english AS name_english_11
FROM
  ps_lang t0

SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0;

SELECT
  p0_.id_cms AS sclr_0,
  p1_.id_lang AS id_lang_1,
  p0_.link_rewrite AS link_rewrite_2
FROM
  ps_cms_lang p0_
  INNER JOIN ps_lang p1_ ON p0_.id_lang = p1_.id_lang

SELECT p0_.id_cms AS sclr_0, p1_.id_lang AS id_lang_1, p0_.link_rewrite AS link_rewrite_2 FROM ps_cms_lang p0_ INNER JOIN ps_lang p1_ ON p0_.id_lang = p1_.id_lang;

SELECT
  t0.id AS id_1,
  t0.meta_title AS meta_title_2,
  t0.meta_description AS meta_description_3,
  t0.name AS name_4,
  t0.meta_keywords AS meta_keywords_5,
  t0.content AS content_6,
  t0.link_rewrite AS link_rewrite_7,
  t0.redirect AS redirect_8,
  t0.id_cms AS id_cms_9,
  t0.id_lang AS id_lang_10
FROM
  ps_cms_lang t0
WHERE
  t0.link_rewrite = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.name AS name_4, t0.meta_keywords AS meta_keywords_5, t0.content AS content_6, t0.link_rewrite AS link_rewrite_7, t0.redirect AS redirect_8, t0.id_cms AS id_cms_9, t0.id_lang AS id_lang_10 FROM ps_cms_lang t0 WHERE t0.link_rewrite = 'vispardotakas.html' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.link_type AS link_type_2,
  t0.link_value AS link_value_3,
  t0.position AS position_4,
  t0.tag AS tag_5,
  t0.icon AS icon_6,
  t0.number_columns AS number_columns_7,
  t0.visibility AS visibility_8,
  t0.colspan AS colspan_9,
  t0.target AS target_10,
  t0.additional AS additional_11,
  t0.menu_id AS menu_id_12,
  t0.parent AS parent_13
FROM
  menu_item t0
WHERE
  t0.link_value = ?
  AND t0.menu_id = ?
  AND t0.visibility = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.link_type AS link_type_2, t0.link_value AS link_value_3, t0.position AS position_4, t0.tag AS tag_5, t0.icon AS icon_6, t0.number_columns AS number_columns_7, t0.visibility AS visibility_8, t0.colspan AS colspan_9, t0.target AS target_10, t0.additional AS additional_11, t0.menu_id AS menu_id_12, t0.parent AS parent_13 FROM menu_item t0 WHERE t0.link_value = 25 AND t0.menu_id = 1 AND t0.visibility = 1 LIMIT 1;

SELECT
  p0_.id_lang AS id_lang_0,
  p0_.name AS name_1,
  p0_.iso_code AS iso_code_2,
  p0_.iso_code_real AS iso_code_real_3
FROM
  ps_lang p0_
WHERE
  p0_.active = 1

SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.iso_code AS iso_code_2, p0_.iso_code_real AS iso_code_real_3 FROM ps_lang p0_ WHERE p0_.active = 1;

SELECT
  p0_.id_category AS id_category_0,
  p0_.active AS active_1,
  p0_.is_root_category AS is_root_category_2,
  p0_.date_add AS date_add_3,
  p0_.date_upd AS date_upd_4,
  p0_.reference AS reference_5,
  p1_.name AS name_6,
  p1_.description AS description_7,
  p1_.link_rewrite AS link_rewrite_8,
  p1_.meta_title AS meta_title_9,
  p1_.meta_description AS meta_description_10,
  p1_.meta_keywords AS meta_keywords_11,
  p1_.id_category AS id_category_12,
  p1_.id_lang AS id_lang_13
FROM
  ps_category p0_
  INNER JOIN ps_category_lang p1_ ON p0_.id_category = p1_.id_category
WHERE
  p0_.id_category IN (?, ?, ?, ?)
  AND p1_.id_lang = ?

SELECT p0_.id_category AS id_category_0, p0_.active AS active_1, p0_.is_root_category AS is_root_category_2, p0_.date_add AS date_add_3, p0_.date_upd AS date_upd_4, p0_.reference AS reference_5, p1_.name AS name_6, p1_.description AS description_7, p1_.link_rewrite AS link_rewrite_8, p1_.meta_title AS meta_title_9, p1_.meta_description AS meta_description_10, p1_.meta_keywords AS meta_keywords_11, p1_.id_category AS id_category_12, p1_.id_lang AS id_lang_13 FROM ps_category p0_ INNER JOIN ps_category_lang p1_ ON p0_.id_category = p1_.id_category WHERE p0_.id_category IN (2672, 2202, 2488, 3150) AND p1_.id_lang = 21;

SELECT
  p0_.id_tag AS id_tag_0,
  p0_.name AS name_1,
  p0_.link_rewrite AS link_rewrite_2,
  p0_.alt AS alt_3,
  p0_.description AS description_4,
  p0_.Book_keeper AS Book_keeper_5,
  p0_.active AS active_6,
  p0_.deleted AS deleted_7,
  p0_.id_lang AS id_lang_8
FROM
  ps_tag p0_
WHERE
  p0_.id_tag IN (?, ?, ?, ?, ?)
  AND p0_.id_lang = ?

SELECT p0_.id_tag AS id_tag_0, p0_.name AS name_1, p0_.link_rewrite AS link_rewrite_2, p0_.alt AS alt_3, p0_.description AS description_4, p0_.Book_keeper AS Book_keeper_5, p0_.active AS active_6, p0_.deleted AS deleted_7, p0_.id_lang AS id_lang_8 FROM ps_tag p0_ WHERE p0_.id_tag IN (35, 100, 66, 72, 85) AND p0_.id_lang = 21;

SELECT
  p0_.id_manufacturer AS id_manufacturer_0,
  p0_.name AS name_1,
  p1_.link_rewrite AS link_rewrite_2,
  p2_.iso_code AS iso_code_3
FROM
  ps_manufacturer p0_
  INNER JOIN ps_manufacturer_lang p1_ ON p0_.id_manufacturer = p1_.id_manufacturer
  INNER JOIN ps_lang p2_ ON p1_.id_lang = p2_.id_lang
WHERE
  p0_.id_manufacturer IN (?)
  AND p2_.id_lang = ?
  AND p0_.active = ?

SELECT p0_.id_manufacturer AS id_manufacturer_0, p0_.name AS name_1, p1_.link_rewrite AS link_rewrite_2, p2_.iso_code AS iso_code_3 FROM ps_manufacturer p0_ INNER JOIN ps_manufacturer_lang p1_ ON p0_.id_manufacturer = p1_.id_manufacturer INNER JOIN ps_lang p2_ ON p1_.id_lang = p2_.id_lang WHERE p0_.id_manufacturer IN (2317) AND p2_.id_lang = 21 AND p0_.active = 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 17088;

SELECT
  t0_.id AS id_0
FROM
  taxonomy t0_
WHERE
  t0_.id_parent IN (?)
  AND t0_.active = 1
  AND t0_.id NOT IN (?)

SELECT t0_.id AS id_0 FROM taxonomy t0_ WHERE t0_.id_parent IN (17088) AND t0_.active = 1 AND t0_.id NOT IN (31548);

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 17089;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 17094;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 17108;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 17113;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 17182;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 17190;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 17191;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 17208;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 20454;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 20455;

SELECT
  t0_.id AS id_0,
  t0_.reference AS reference_1,
  t1_.name AS name_2,
  t1_.link_rewrite AS link_rewrite_3,
  t2_.num_products AS num_products_4
FROM
  taxonomy t0_
  LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy
  AND (t1_.id_lang = ?)
  LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy)
WHERE
  t0_.id = ?

SELECT t0_.id AS id_0, t0_.reference AS reference_1, t1_.name AS name_2, t1_.link_rewrite AS link_rewrite_3, t2_.num_products AS num_products_4 FROM taxonomy t0_ LEFT JOIN taxonomy_lang t1_ ON t0_.id = t1_.id_taxonomy AND (t1_.id_lang = 21) LEFT JOIN taxonomy_statistics t2_ ON (t0_.id = t2_.id_taxonomy) WHERE t0_.id = 20456;