Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.conversion_rate AS conversion_rate_4,
  t0.rounding AS rounding_5,
  t0.is_default AS is_default_6
FROM
  currency t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.conversion_rate AS conversion_rate_4, t0.rounding AS rounding_5, t0.is_default AS is_default_6 FROM currency t0 WHERE t0.is_default = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.menu_name AS menu_name_3,
  t0.description AS description_4,
  t0.html AS html_5,
  t0.title AS title_6,
  t0.is_active AS is_active_7,
  t0.slug AS slug_8,
  t0.javascript AS javascript_9,
  t0.sequence AS sequence_10,
  t0.is_menu AS is_menu_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.state AS state_14,
  t0.has_comments AS has_comments_15,
  t0.is_indexable AS is_indexable_16,
  t0.created_at AS created_at_17,
  t0.published_at AS published_at_18,
  t0.category_type_id AS category_type_id_19,
  t0.upload_id AS upload_id_20,
  t21.id AS id_22,
  t21.sales_unit AS sales_unit_23,
  t21.opportunity_type AS opportunity_type_24,
  t21.category_id AS category_id_25
FROM
  p_category t0
  LEFT JOIN category_sap t21 ON t21.category_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20, t21.id AS id_22, t21.sales_unit AS sales_unit_23, t21.opportunity_type AS opportunity_type_24, t21.category_id AS category_id_25 FROM p_category t0 LEFT JOIN category_sap t21 ON t21.category_id = t0.id WHERE t0.slug = 'stineni-prumyslovych-hal' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  p0_.slug AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  p0_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
  LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id
WHERE
  p1_.category_super_id = ?
  AND p0_.category_type_id IN (?, ?)
  AND p0_.is_active = 1
  AND p0_.id > 10
ORDER BY
  p1_.sequence ASC,
  p0_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p1_.category_super_id = 142 AND p0_.category_type_id IN (6, 5) AND p0_.is_active = 1 AND p0_.id > 10 ORDER BY p1_.sequence ASC, p0_.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sales_unit AS sales_unit_2,
  t0.opportunity_type AS opportunity_type_3,
  t0.category_id AS category_id_4
FROM
  category_sap t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sales_unit AS sales_unit_2, t0.opportunity_type AS opportunity_type_3, t0.category_id AS category_id_4 FROM category_sap t0 WHERE t0.category_id = 71;

SELECT
  t0.id AS id_1,
  t0.sales_unit AS sales_unit_2,
  t0.opportunity_type AS opportunity_type_3,
  t0.category_id AS category_id_4
FROM
  category_sap t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sales_unit AS sales_unit_2, t0.opportunity_type AS opportunity_type_3, t0.category_id AS category_id_4 FROM category_sap t0 WHERE t0.category_id = 72;

SELECT
  t0.id AS id_1,
  t0.sales_unit AS sales_unit_2,
  t0.opportunity_type AS opportunity_type_3,
  t0.category_id AS category_id_4
FROM
  category_sap t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sales_unit AS sales_unit_2, t0.opportunity_type AS opportunity_type_3, t0.category_id AS category_id_4 FROM category_sap t0 WHERE t0.category_id = 74;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template AS template_3,
  t0.slug_prefix AS slug_prefix_4,
  t0.controller_name AS controller_name_5
FROM
  category_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.slug_prefix AS slug_prefix_4, t0.controller_name AS controller_name_5 FROM category_type t0 WHERE t0.id = 5;

SELECT
  u0_.id AS id_0
FROM
  upload_group u0_
  LEFT JOIN category_upload_group c1_ ON u0_.id = c1_.upload_group_id
WHERE
  c1_.category_id = ?

SELECT u0_.id AS id_0 FROM upload_group u0_ LEFT JOIN category_upload_group c1_ ON u0_.id = c1_.upload_group_id WHERE c1_.category_id = 71;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.extension AS extension_2,
  u0_.mime AS mime_3,
  u0_.title AS title_4,
  u0_.short_description AS short_description_5,
  u0_.description AS description_6,
  u0_.created AS created_7,
  u0_.path AS path_8,
  u0_.original_name AS original_name_9,
  u0_.width AS width_10,
  u0_.height AS height_11,
  u0_.sequence AS sequence_12,
  u0_.note AS note_13,
  u0_.upload_group_id AS upload_group_id_14,
  u0_.upload_type_id AS upload_type_id_15
FROM
  upload u0_
WHERE
  u0_.upload_group_id IN (?, ?)
  AND u0_.upload_type_id = ?
LIMIT
  1

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.note AS note_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (76, 130) AND u0_.upload_type_id = 5 LIMIT 1;

SELECT
  u0_.id AS id_0
FROM
  upload_group u0_
  LEFT JOIN category_upload_group c1_ ON u0_.id = c1_.upload_group_id
WHERE
  c1_.category_id = ?

SELECT u0_.id AS id_0 FROM upload_group u0_ LEFT JOIN category_upload_group c1_ ON u0_.id = c1_.upload_group_id WHERE c1_.category_id = 72;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.extension AS extension_2,
  u0_.mime AS mime_3,
  u0_.title AS title_4,
  u0_.short_description AS short_description_5,
  u0_.description AS description_6,
  u0_.created AS created_7,
  u0_.path AS path_8,
  u0_.original_name AS original_name_9,
  u0_.width AS width_10,
  u0_.height AS height_11,
  u0_.sequence AS sequence_12,
  u0_.note AS note_13,
  u0_.upload_group_id AS upload_group_id_14,
  u0_.upload_type_id AS upload_type_id_15
FROM
  upload u0_
WHERE
  u0_.upload_group_id IN (?, ?)
  AND u0_.upload_type_id = ?
LIMIT
  1

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.note AS note_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (77, 131) AND u0_.upload_type_id = 5 LIMIT 1;

SELECT
  u0_.id AS id_0
FROM
  upload_group u0_
  LEFT JOIN category_upload_group c1_ ON u0_.id = c1_.upload_group_id
WHERE
  c1_.category_id = ?

SELECT u0_.id AS id_0 FROM upload_group u0_ LEFT JOIN category_upload_group c1_ ON u0_.id = c1_.upload_group_id WHERE c1_.category_id = 74;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.extension AS extension_2,
  u0_.mime AS mime_3,
  u0_.title AS title_4,
  u0_.short_description AS short_description_5,
  u0_.description AS description_6,
  u0_.created AS created_7,
  u0_.path AS path_8,
  u0_.original_name AS original_name_9,
  u0_.width AS width_10,
  u0_.height AS height_11,
  u0_.sequence AS sequence_12,
  u0_.note AS note_13,
  u0_.upload_group_id AS upload_group_id_14,
  u0_.upload_type_id AS upload_type_id_15
FROM
  upload u0_
WHERE
  u0_.upload_group_id IN (?, ?)
  AND u0_.upload_type_id = ?
LIMIT
  1

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.note AS note_13, u0_.upload_group_id AS upload_group_id_14, u0_.upload_type_id AS upload_type_id_15 FROM upload u0_ WHERE u0_.upload_group_id IN (132, 260) AND u0_.upload_type_id = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template AS template_3,
  t0.slug_prefix AS slug_prefix_4,
  t0.controller_name AS controller_name_5
FROM
  category_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.slug_prefix AS slug_prefix_4, t0.controller_name AS controller_name_5 FROM category_type t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template AS template_3,
  t0.controller_name AS controller_name_4
FROM
  menu_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM menu_type t0 WHERE t0.id = '4';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.html AS html_4,
  p0_.title AS title_5,
  p0_.is_active AS is_active_6,
  p0_.slug AS slug_7,
  p0_.javascript AS javascript_8,
  p0_.sequence AS sequence_9,
  p0_.is_menu AS is_menu_10,
  p0_.latitude AS latitude_11,
  p0_.longitude AS longitude_12,
  p0_.state AS state_13,
  p0_.has_comments AS has_comments_14,
  p0_.is_indexable AS is_indexable_15,
  p0_.created_at AS created_at_16,
  p0_.published_at AS published_at_17,
  p0_.category_type_id AS category_type_id_18,
  p0_.upload_id AS upload_id_19
FROM
  p_category p0_
  LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id
  LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id
WHERE
  p0_.is_active = ?
  AND p0_.id >= ?
  AND p1_.id IS NULL
  AND c2_.menu_type_id = ?
ORDER BY
  c2_.sequence ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id WHERE p0_.is_active = 1 AND p0_.id >= 2 AND p1_.id IS NULL AND c2_.menu_type_id = 4 ORDER BY c2_.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sales_unit AS sales_unit_2,
  t0.opportunity_type AS opportunity_type_3,
  t0.category_id AS category_id_4
FROM
  category_sap t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sales_unit AS sales_unit_2, t0.opportunity_type AS opportunity_type_3, t0.category_id AS category_id_4 FROM category_sap t0 WHERE t0.category_id = 157;

SELECT
  t0.id AS id_1,
  t0.sales_unit AS sales_unit_2,
  t0.opportunity_type AS opportunity_type_3,
  t0.category_id AS category_id_4
FROM
  category_sap t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sales_unit AS sales_unit_2, t0.opportunity_type AS opportunity_type_3, t0.category_id AS category_id_4 FROM category_sap t0 WHERE t0.category_id = 65;

SELECT
  t0.id AS id_1,
  t0.sales_unit AS sales_unit_2,
  t0.opportunity_type AS opportunity_type_3,
  t0.category_id AS category_id_4
FROM
  category_sap t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sales_unit AS sales_unit_2, t0.opportunity_type AS opportunity_type_3, t0.category_id AS category_id_4 FROM category_sap t0 WHERE t0.category_id = 2;

SELECT
  t0.id AS id_1,
  t0.sales_unit AS sales_unit_2,
  t0.opportunity_type AS opportunity_type_3,
  t0.category_id AS category_id_4
FROM
  category_sap t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sales_unit AS sales_unit_2, t0.opportunity_type AS opportunity_type_3, t0.category_id AS category_id_4 FROM category_sap t0 WHERE t0.category_id = 51;

SELECT
  t0.id AS id_1,
  t0.sales_unit AS sales_unit_2,
  t0.opportunity_type AS opportunity_type_3,
  t0.category_id AS category_id_4
FROM
  category_sap t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sales_unit AS sales_unit_2, t0.opportunity_type AS opportunity_type_3, t0.category_id AS category_id_4 FROM category_sap t0 WHERE t0.category_id = 13;

SELECT
  t0.id AS id_1,
  t0.sales_unit AS sales_unit_2,
  t0.opportunity_type AS opportunity_type_3,
  t0.category_id AS category_id_4
FROM
  category_sap t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.sales_unit AS sales_unit_2, t0.opportunity_type AS opportunity_type_3, t0.category_id AS category_id_4 FROM category_sap t0 WHERE t0.category_id = 15;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template AS template_3,
  t0.slug_prefix AS slug_prefix_4,
  t0.controller_name AS controller_name_5
FROM
  category_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.slug_prefix AS slug_prefix_4, t0.controller_name AS controller_name_5 FROM category_type t0 WHERE t0.id = 1;