Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.symbol AS symbol_2,
  c0_.rounding AS rounding_3,
  c0_.is_default AS is_default_4,
  c0_.default_locale AS default_locale_5,
  c0_.is_symbol_left AS is_symbol_left_6,
  c0_.is_deleted AS is_deleted_7
FROM
  currency c0_
WHERE
  c0_.default_locale = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = 'en' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.rounding AS rounding_4,
  t0.is_default AS is_default_5,
  t0.default_locale AS default_locale_6,
  t0.is_symbol_left AS is_symbol_left_7,
  t0.is_deleted AS is_deleted_8
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.rounding AS rounding_4, t0.is_default AS is_default_5, t0.default_locale AS default_locale_6, t0.is_symbol_left AS is_symbol_left_7, t0.is_deleted AS is_deleted_8 FROM currency t0 WHERE t0.is_default = 1 LIMIT 1;

SELECT
  s0_.value AS value_0
FROM
  settings s0_
WHERE
  s0_.name = ?
ORDER BY
  s0_.name ASC
LIMIT
  1

SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = 'after_registration_discount' ORDER BY s0_.name ASC 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
FROM
  p_category t0
WHERE
  t0.id = ?
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 FROM p_category t0 WHERE t0.id = '3765' LIMIT 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3765' AND e0_.locale = 'en' AND e0_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.menu_name AS menu_name_3,
  t0.description AS description_4,
  t0.title AS title_5,
  t0.slug AS slug_6,
  t0.is_active AS is_active_7,
  t0.is_visible AS is_visible_8,
  t0.sequence AS sequence_9,
  t0.javascript AS javascript_10,
  t0.text_general AS text_general_11,
  t0.state AS state_12,
  t0.external_id AS external_id_13,
  t0.is_indexable AS is_indexable_14,
  t0.meta_description AS meta_description_15,
  t0.has_variant_picture AS has_variant_picture_16,
  t0.sold_amount AS sold_amount_17,
  t0.producer_id AS producer_id_18,
  t0.upload_id AS upload_id_19,
  t0.product_type_id AS product_type_id_20,
  t0.product_view_type_id AS product_view_type_id_21
FROM
  product t0
WHERE
  t0.id IS NULL
  AND (
    (t0.is_active = true)
  )
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.title AS title_5, t0.slug AS slug_6, t0.is_active AS is_active_7, t0.is_visible AS is_visible_8, t0.sequence AS sequence_9, t0.javascript AS javascript_10, t0.text_general AS text_general_11, t0.state AS state_12, t0.external_id AS external_id_13, t0.is_indexable AS is_indexable_14, t0.meta_description AS meta_description_15, t0.has_variant_picture AS has_variant_picture_16, t0.sold_amount AS sold_amount_17, t0.producer_id AS producer_id_18, t0.upload_id AS upload_id_19, t0.product_type_id AS product_type_id_20, t0.product_view_type_id AS product_view_type_id_21 FROM product t0 WHERE t0.id IS NULL AND ((t0.is_active = true)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.is_main_category AS is_main_category_4,
  t0.category_super_id AS category_super_id_5,
  t0.category_sub_id AS category_sub_id_6
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = 3765 ORDER BY t0.sequence ASC;

SELECT
  p0_.id AS id_0,
  p0_.sequence AS sequence_1,
  p0_.is_menu_item AS is_menu_item_2,
  p0_.is_main_category AS is_main_category_3,
  p0_.category_super_id AS category_super_id_4,
  p0_.category_sub_id AS category_sub_id_5
FROM
  p_category_category p0_
WHERE
  p0_.is_main_category = 1
  AND p0_.category_sub_id = ?

SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = 3765;

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
FROM
  p_category t0
WHERE
  t0.id = ?

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 FROM p_category t0 WHERE t0.id = 3825;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3825' AND e0_.locale = 'en' AND e0_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category';

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.is_main_category AS is_main_category_4,
  t0.category_super_id AS category_super_id_5,
  t0.category_sub_id AS category_sub_id_6
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = 3825 ORDER BY t0.sequence ASC;

SELECT
  p0_.id AS id_0,
  p0_.sequence AS sequence_1,
  p0_.is_menu_item AS is_menu_item_2,
  p0_.is_main_category AS is_main_category_3,
  p0_.category_super_id AS category_super_id_4,
  p0_.category_sub_id AS category_sub_id_5
FROM
  p_category_category p0_
WHERE
  p0_.is_main_category = 1
  AND p0_.category_sub_id = ?

SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = 3825;

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
FROM
  p_category t0
WHERE
  t0.id = ?

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 FROM p_category t0 WHERE t0.id = 3824;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3824' AND e0_.locale = 'en' AND e0_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category';

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.is_main_category AS is_main_category_4,
  t0.category_super_id AS category_super_id_5,
  t0.category_sub_id AS category_sub_id_6
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = 3824 ORDER BY t0.sequence ASC;

SELECT
  p0_.id AS id_0,
  p0_.sequence AS sequence_1,
  p0_.is_menu_item AS is_menu_item_2,
  p0_.is_main_category AS is_main_category_3,
  p0_.category_super_id AS category_super_id_4,
  p0_.category_sub_id AS category_sub_id_5
FROM
  p_category_category p0_
WHERE
  p0_.is_main_category = 1
  AND p0_.category_sub_id = ?

SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.is_main_category AS is_main_category_3, p0_.category_super_id AS category_super_id_4, p0_.category_sub_id AS category_sub_id_5 FROM p_category_category p0_ WHERE p0_.is_main_category = 1 AND p0_.category_sub_id = 3824;

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
FROM
  p_category t0
WHERE
  t0.id = ?

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 FROM p_category t0 WHERE t0.id = 3689;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3689' AND e0_.locale = 'en' AND e0_.object_class = 'Greendot\\EshopBundle\\Entity\\Project\\Category';

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.is_main_category AS is_main_category_4,
  t0.category_super_id AS category_super_id_5,
  t0.category_sub_id AS category_sub_id_6
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.is_main_category AS is_main_category_4, t0.category_super_id AS category_super_id_5, t0.category_sub_id AS category_sub_id_6 FROM p_category_category t0 WHERE t0.category_sub_id = 3689 ORDER BY t0.sequence ASC;