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 = 'es' 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 = 'contact' AND p0_.id_lang = 4;

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_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 = 'es' 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 = 'es' 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 = 4) 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
  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 = 'contact' 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
  t0.id_configuration AS id_configuration_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  ps_configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id_configuration AS id_configuration_1, t0.name AS name_2, t0.value AS value_3 FROM ps_configuration t0 WHERE t0.name = 'LOGO_NAVIDAD' 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 = 'es' 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 = 'es' 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 = 4) 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 = 2 AND m0_.visibility = 1 ORDER BY m0_.position ASC;

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
  *
FROM
  `ps_lang`
WHERE
  iso_code = :iso_code
  AND active = 1

SELECT * FROM `ps_lang` WHERE iso_code = :iso_code AND active = 1;

SELECT
  iso_code
FROM
  `ps_lang`
WHERE
  id_lang = :id_lang
  AND active = 1

SELECT iso_code FROM `ps_lang` WHERE id_lang = :id_lang AND active = 1;

SELECT
  cp.internal_reference,
  i.id_image,
  i.name AS image_name,
  pl.name,
  pl.description,
  p.price,
  p.wholesale_price,
  cp.quantity,
  (
    p.weight + IFNULL(pa.weight, 0)
  ) AS weight,
  p.width,
  p.height,
  p.depth,
  p.ean13,
  IFNULL(p.upc, "") upc,
  p.cache_is_pack,
  ROUND(
    (sp.reduction * 100) / p.price
  ) AS percentage_discount,
  sp.reduction AS money_discount,
  p.delay,
  cp.quantity AS quantity_total,
  p.is_virtual,
  p.id_category_default,
  p.active,
  p.reference AS parent_reference,
  cp.id_product,
  cp.id_product_attribute,
  cp.id_cart_product,
  sp.reduction,
  cp.future_stock,
  cp.purchase_order,
  cp.id_purchase_line,
  GROUP_CONCAT(
    DISTINCT a.name
    ORDER BY
      a.id_attribute SEPARATOR ", "
  ) AS attribute_name,
  p.id_supplier,
  p.id_taxonomy_default,
  p.id_tax,
  COALESCE(t.rate, 21) AS tax_rate,
  COALESCE(tl.name, "IVA 20%") AS tax_name,
  COALESCE(pa.reference, p.reference) AS reference,
  cp.locks,
  p.id_category_default,
  pl.name AS default_name,
  txl.name AS default_category_name,
  p.producto_electronico,
  cp.extern_stock,
  cp.extern_stock_3_5,
  p.estimate_cost_price,
  psa.id_warehouse,
  pw.allow_fulfillment
FROM
  ps_cart c
  LEFT JOIN ps_cart_product cp ON c.id_cart = cp.id_cart
  LEFT JOIN ps_product p ON p.id_product = cp.id_product
  LEFT JOIN ps_product_lang_es pl ON pl.id_product = p.id_product
  LEFT JOIN ps_image AS i ON p.id_product = i.id_product
  LEFT JOIN ps_specific_price sp ON sp.id_product = p.id_product
  LEFT JOIN ps_product_attribute AS pa ON pa.id_product_attribute = cp.id_product_attribute
  LEFT JOIN ps_product_attribute_combination AS pac ON pac.id_product_attribute = cp.id_product_attribute
  LEFT JOIN ps_attribute AS a ON a.id_attribute = pac.id_attribute
  AND (
    a.id_lang = :id_lang
    OR a.id_lang IS NULL
  )
  INNER JOIN ps_stock_available AS psa ON psa.id_product = cp.id_product
  AND psa.id_product_attribute = cp.id_product_attribute
  INNER JOIN ps_warehouse AS pw ON psa.id_warehouse = pw.id
  LEFT JOIN ps_tax_rule AS ptr ON ptr.id_tax_rules_group = p.id_tax
  AND ptr.country_origin = pw.country
  AND ptr.id_country = :id_shipping_country
  LEFT JOIN ps_tax t ON t.id_tax = ptr.id_tax
  LEFT JOIN ps_tax_lang AS tl ON ptr.id_tax = tl.id_tax
  AND (
    tl.id_lang = :id_lang
    OR tl.id_lang = 1
  )
  LEFT JOIN taxonomy_lang AS txl ON txl.id_taxonomy = p.id_taxonomy_default
  AND (
    txl.id_lang = :id_lang
    OR txl.id_lang IS NULL
  )
WHERE
  c.id_cart = :id_cart
  AND sp.from_quantity <= 1
  AND (
    i.cover = 1
    OR i.id_image IS NULL
  )
GROUP BY
  id_cart_product
ORDER BY
  cp.id_cart_product ASC

SELECT cp.internal_reference, i.id_image, i.name AS image_name, pl.name, pl.description, p.price,p.wholesale_price, cp.quantity, (p.weight+ IFNULL(pa.weight, 0)) AS weight, p.width, p.height, p.depth, 
                       p.ean13, IFNULL(p.upc , "") upc, p.cache_is_pack, ROUND((sp.reduction * 100) / p.price) AS percentage_discount, sp.reduction AS money_discount, p.delay,
                       cp.quantity AS quantity_total, p.is_virtual, p.id_category_default, p.active, p.reference AS parent_reference,
                        cp.id_product, cp.id_product_attribute, cp.id_cart_product, sp.reduction, cp.future_stock, cp.purchase_order, cp.id_purchase_line,
                        GROUP_CONCAT(DISTINCT a.name ORDER BY a.id_attribute SEPARATOR ", ") AS attribute_name, p.id_supplier, p.id_taxonomy_default, 
                        p.id_tax, COALESCE(t.rate, 21) AS tax_rate, COALESCE(tl.name, "IVA 20%") AS tax_name, COALESCE(pa.reference, p.reference) AS reference, cp.locks, p.id_category_default, 
                        pl.name AS default_name, txl.name AS default_category_name, p.producto_electronico, cp.extern_stock, cp.extern_stock_3_5, p.estimate_cost_price, psa.id_warehouse, pw.allow_fulfillment
                FROM ps_cart c 
                LEFT JOIN ps_cart_product cp 
                    ON c.id_cart = cp.id_cart 
                LEFT JOIN ps_product p 
                    ON p.id_product = cp.id_product 
                LEFT JOIN ps_product_lang_es pl 
                    ON pl.id_product = p.id_product 
                LEFT JOIN ps_image AS i 
                    ON p.id_product = i.id_product 
                LEFT JOIN ps_specific_price sp 
                    ON sp.id_product = p.id_product 
                LEFT JOIN ps_product_attribute AS pa 
                    ON pa.id_product_attribute = cp.id_product_attribute
                LEFT JOIN ps_product_attribute_combination AS pac 
                    ON pac.id_product_attribute = cp.id_product_attribute 
                LEFT JOIN ps_attribute AS a 
                    ON a.id_attribute = pac.id_attribute AND (a.id_lang = :id_lang OR a.id_lang IS NULL)
                INNER JOIN ps_stock_available AS psa ON psa.id_product = cp.id_product AND psa.id_product_attribute = cp.id_product_attribute
                INNER JOIN ps_warehouse AS pw ON psa.id_warehouse = pw.id
                LEFT JOIN ps_tax_rule AS ptr ON ptr.id_tax_rules_group = p.id_tax AND ptr.country_origin = pw.country AND ptr.id_country = :id_shipping_country
                LEFT JOIN ps_tax t ON t.id_tax = ptr.id_tax
                LEFT JOIN ps_tax_lang AS tl ON ptr.id_tax = tl.id_tax AND (tl.id_lang = :id_lang OR tl.id_lang = 1)
                LEFT JOIN taxonomy_lang AS txl ON txl.id_taxonomy = p.id_taxonomy_default AND (txl.id_lang = :id_lang OR txl.id_lang IS NULL)
                WHERE c.id_cart = :id_cart
                  AND sp.from_quantity <= 1 
                  AND (i.cover = 1 OR i.id_image IS NULL) 
                GROUP BY id_cart_product
                ORDER BY cp.id_cart_product ASC;

SELECT
  tc.id_tickets_category,
  tc.id_tickets_category_parent,
  tc.public_id,
  tcl.name,
  tcl_en.name AS name_en,
  tcl.name,
  tcl.description,
  tct.name AS type_name,
  tc.id_hs_pipeline,
  tc.id_hs_pipeline_stage,
  tc.id_hs_category
FROM
  ps_tickets_category AS tc
  INNER JOIN ps_tickets_category_lang AS tcl ON tcl.id_tickets_category = tc.id_tickets_category
  AND tcl.id_lang = :id_lang
  LEFT JOIN ps_tickets_category_lang AS tcl_en ON tcl_en.id_tickets_category = tc.id_tickets_category
  AND tcl_en.id_lang = 1
  INNER JOIN ps_tickets_category_type AS tct ON tct.id_tickets_category_type = tc.id_type
  AND tct.id_lang = tcl.id_lang
WHERE
  tc.id_tickets_category_parent = :id_parent
  AND tc.id_form = :id_form

SELECT tc.id_tickets_category,tc.id_tickets_category_parent,tc.public_id,tcl.name,tcl_en.name AS name_en,tcl.name,tcl.description,tct.name AS type_name, tc.id_hs_pipeline, tc.id_hs_pipeline_stage, tc.id_hs_category
                                                FROM ps_tickets_category AS tc
                                                INNER JOIN ps_tickets_category_lang AS tcl ON tcl.id_tickets_category = tc.id_tickets_category AND tcl.id_lang = :id_lang
                                                LEFT JOIN ps_tickets_category_lang AS tcl_en ON tcl_en.id_tickets_category = tc.id_tickets_category AND tcl_en.id_lang = 1
                                                INNER JOIN ps_tickets_category_type AS tct ON tct.id_tickets_category_type = tc.id_type AND tct.id_lang = tcl.id_lang
                                                WHERE tc.id_tickets_category_parent = :id_parent AND tc.id_form = :id_form;

SELECT
  tc.id_tickets_category,
  tc.id_tickets_category_parent,
  ti.type,
  ti.id,
  ti.name,
  til.label,
  ti.required
FROM
  ps_tickets_category AS tc
  INNER JOIN ps_tickets_inputs AS ti ON ti.id_tickets_category = tc.id_tickets_category
  INNER JOIN ps_tickets_inputs_lang AS til ON til.id_tickets_inputs = ti.id_tickets_inputs
  AND til.id_lang = :id_lang
WHERE
  tc.id_tickets_category = :id_tickets_category
  AND tc.id_form = :id_form

SELECT tc.id_tickets_category,tc.id_tickets_category_parent,ti.type,ti.id,ti.name,til.label,ti.required
                                                    FROM ps_tickets_category AS tc
                                                    INNER JOIN ps_tickets_inputs AS ti ON ti.id_tickets_category = tc.id_tickets_category
                                                    INNER JOIN ps_tickets_inputs_lang AS til ON til.id_tickets_inputs = ti.id_tickets_inputs AND til.id_lang = :id_lang
                                                    WHERE tc.id_tickets_category = :id_tickets_category AND tc.id_form = :id_form;

SELECT
  tc.id_tickets_category,
  tc.id_tickets_category_parent,
  tc.public_id,
  tcl.name,
  tcl_en.name AS name_en,
  tcl.name,
  tcl.description,
  tct.name AS type_name,
  tc.id_hs_pipeline,
  tc.id_hs_pipeline_stage,
  tc.id_hs_category
FROM
  ps_tickets_category AS tc
  INNER JOIN ps_tickets_category_lang AS tcl ON tcl.id_tickets_category = tc.id_tickets_category
  AND tcl.id_lang = :id_lang
  LEFT JOIN ps_tickets_category_lang AS tcl_en ON tcl_en.id_tickets_category = tc.id_tickets_category
  AND tcl_en.id_lang = 1
  INNER JOIN ps_tickets_category_type AS tct ON tct.id_tickets_category_type = tc.id_type
  AND tct.id_lang = tcl.id_lang
WHERE
  tc.id_tickets_category_parent = :id_parent
  AND tc.id_form = :id_form

SELECT tc.id_tickets_category,tc.id_tickets_category_parent,tc.public_id,tcl.name,tcl_en.name AS name_en,tcl.name,tcl.description,tct.name AS type_name, tc.id_hs_pipeline, tc.id_hs_pipeline_stage, tc.id_hs_category
                                                FROM ps_tickets_category AS tc
                                                INNER JOIN ps_tickets_category_lang AS tcl ON tcl.id_tickets_category = tc.id_tickets_category AND tcl.id_lang = :id_lang
                                                LEFT JOIN ps_tickets_category_lang AS tcl_en ON tcl_en.id_tickets_category = tc.id_tickets_category AND tcl_en.id_lang = 1
                                                INNER JOIN ps_tickets_category_type AS tct ON tct.id_tickets_category_type = tc.id_type AND tct.id_lang = tcl.id_lang
                                                WHERE tc.id_tickets_category_parent = :id_parent AND tc.id_form = :id_form;

SELECT
  tc.id_tickets_category,
  tc.id_tickets_category_parent,
  ti.type,
  ti.id,
  ti.name,
  til.label,
  ti.required
FROM
  ps_tickets_category AS tc
  INNER JOIN ps_tickets_inputs AS ti ON ti.id_tickets_category = tc.id_tickets_category
  INNER JOIN ps_tickets_inputs_lang AS til ON til.id_tickets_inputs = ti.id_tickets_inputs
  AND til.id_lang = :id_lang
WHERE
  tc.id_tickets_category = :id_tickets_category
  AND tc.id_form = :id_form

SELECT tc.id_tickets_category,tc.id_tickets_category_parent,ti.type,ti.id,ti.name,til.label,ti.required
                                                    FROM ps_tickets_category AS tc
                                                    INNER JOIN ps_tickets_inputs AS ti ON ti.id_tickets_category = tc.id_tickets_category
                                                    INNER JOIN ps_tickets_inputs_lang AS til ON til.id_tickets_inputs = ti.id_tickets_inputs AND til.id_lang = :id_lang
                                                    WHERE tc.id_tickets_category = :id_tickets_category AND tc.id_form = :id_form;

SELECT
  tc.id_tickets_category,
  tc.id_tickets_category_parent,
  tc.public_id,
  tcl.name,
  tcl_en.name AS name_en,
  tcl.name,
  tcl.description,
  tct.name AS type_name,
  tc.id_hs_pipeline,
  tc.id_hs_pipeline_stage,
  tc.id_hs_category
FROM
  ps_tickets_category AS tc
  INNER JOIN ps_tickets_category_lang AS tcl ON tcl.id_tickets_category = tc.id_tickets_category
  AND tcl.id_lang = :id_lang
  LEFT JOIN ps_tickets_category_lang AS tcl_en ON tcl_en.id_tickets_category = tc.id_tickets_category
  AND tcl_en.id_lang = 1
  INNER JOIN ps_tickets_category_type AS tct ON tct.id_tickets_category_type = tc.id_type
  AND tct.id_lang = tcl.id_lang
WHERE
  tc.id_tickets_category_parent = :id_parent
  AND tc.id_form = :id_form

SELECT tc.id_tickets_category,tc.id_tickets_category_parent,tc.public_id,tcl.name,tcl_en.name AS name_en,tcl.name,tcl.description,tct.name AS type_name, tc.id_hs_pipeline, tc.id_hs_pipeline_stage, tc.id_hs_category
                                                FROM ps_tickets_category AS tc
                                                INNER JOIN ps_tickets_category_lang AS tcl ON tcl.id_tickets_category = tc.id_tickets_category AND tcl.id_lang = :id_lang
                                                LEFT JOIN ps_tickets_category_lang AS tcl_en ON tcl_en.id_tickets_category = tc.id_tickets_category AND tcl_en.id_lang = 1
                                                INNER JOIN ps_tickets_category_type AS tct ON tct.id_tickets_category_type = tc.id_type AND tct.id_lang = tcl.id_lang
                                                WHERE tc.id_tickets_category_parent = :id_parent AND tc.id_form = :id_form;

SELECT
  tc.id_tickets_category,
  tc.id_tickets_category_parent,
  ti.type,
  ti.id,
  ti.name,
  til.label,
  ti.required
FROM
  ps_tickets_category AS tc
  INNER JOIN ps_tickets_inputs AS ti ON ti.id_tickets_category = tc.id_tickets_category
  INNER JOIN ps_tickets_inputs_lang AS til ON til.id_tickets_inputs = ti.id_tickets_inputs
  AND til.id_lang = :id_lang
WHERE
  tc.id_tickets_category = :id_tickets_category
  AND tc.id_form = :id_form

SELECT tc.id_tickets_category,tc.id_tickets_category_parent,ti.type,ti.id,ti.name,til.label,ti.required
                                                    FROM ps_tickets_category AS tc
                                                    INNER JOIN ps_tickets_inputs AS ti ON ti.id_tickets_category = tc.id_tickets_category
                                                    INNER JOIN ps_tickets_inputs_lang AS til ON til.id_tickets_inputs = ti.id_tickets_inputs AND til.id_lang = :id_lang
                                                    WHERE tc.id_tickets_category = :id_tickets_category AND tc.id_form = :id_form;

SELECT
  tc.id_tickets_category,
  tc.id_tickets_category_parent,
  tc.public_id,
  tcl.name,
  tcl_en.name AS name_en,
  tcl.name,
  tcl.description,
  tct.name AS type_name,
  tc.id_hs_pipeline,
  tc.id_hs_pipeline_stage,
  tc.id_hs_category
FROM
  ps_tickets_category AS tc
  INNER JOIN ps_tickets_category_lang AS tcl ON tcl.id_tickets_category = tc.id_tickets_category
  AND tcl.id_lang = :id_lang
  LEFT JOIN ps_tickets_category_lang AS tcl_en ON tcl_en.id_tickets_category = tc.id_tickets_category
  AND tcl_en.id_lang = 1
  INNER JOIN ps_tickets_category_type AS tct ON tct.id_tickets_category_type = tc.id_type
  AND tct.id_lang = tcl.id_lang
WHERE
  tc.id_tickets_category_parent = :id_parent
  AND tc.id_form = :id_form