Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.add_images AS add_images_5,
  t0.sort AS sort_6,
  t0.use_publications AS use_publications_7,
  t0.intro AS intro_8,
  t0.description AS description_9,
  t0.use_intro AS use_intro_10,
  t0.use_intro_files AS use_intro_files_11,
  t0.use_description AS use_description_12,
  t0.use_description_files AS use_description_files_13,
  t0.columns_count_in_list AS columns_count_in_list_14,
  t0.is_page AS is_page_15
FROM
  publication_group t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.add_images AS add_images_5, t0.sort AS sort_6, t0.use_publications AS use_publications_7, t0.intro AS intro_8, t0.description AS description_9, t0.use_intro AS use_intro_10, t0.use_intro_files AS use_intro_files_11, t0.use_description AS use_description_12, t0.use_description_files AS use_description_files_13, t0.columns_count_in_list AS columns_count_in_list_14, t0.is_page AS is_page_15 FROM publication_group t0 WHERE t0.slug = 'news' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.created_at AS created_at_5,
  t0.intro AS intro_6,
  t0.description AS description_7,
  t0.publication_group_id AS publication_group_id_8
FROM
  publication t0
WHERE
  (
    (
      t0.publication_group_id = ?
      AND t0.slug = ?
    )
    AND t0.is_published = ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.created_at AS created_at_5, t0.intro AS intro_6, t0.description AS description_7, t0.publication_group_id AS publication_group_id_8 FROM publication t0 WHERE ((t0.publication_group_id = 2 AND t0.slug = '2020-12-29') AND t0.is_published = 1);

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.h1 AS h1_5
FROM
  page_tag t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.description AS description_4, t0.h1 AS h1_5 FROM page_tag t0 WHERE t0.url = '/news/2020-12-29' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_default AS is_default_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.price AS price_6,
  t0.is_address AS is_address_7,
  t0.is_time AS is_time_8,
  t0.description AS description_9,
  t0.comment AS comment_10,
  t0.code AS code_11,
  t0.price_comment AS price_comment_12,
  t0.use_auto_payment AS use_auto_payment_13,
  t0.default_city AS default_city_14,
  t0.price_min AS price_min_15,
  t0.shop_id AS shop_id_16
FROM
  delivery t0
WHERE
  t0.is_published = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.price AS price_6, t0.is_address AS is_address_7, t0.is_time AS is_time_8, t0.description AS description_9, t0.comment AS comment_10, t0.code AS code_11, t0.price_comment AS price_comment_12, t0.use_auto_payment AS use_auto_payment_13, t0.default_city AS default_city_14, t0.price_min AS price_min_15, t0.shop_id AS shop_id_16 FROM delivery t0 WHERE t0.is_published = 1 ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.is_published AS is_published_4,
  t0.sort AS sort_5,
  t0.map_latitude AS map_latitude_6,
  t0.map_longitude AS map_longitude_7,
  t0.slug_short AS slug_short_8,
  t0.is_default AS is_default_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.html_map AS html_map_12,
  t0.html_link AS html_link_13,
  t0.is_storage AS is_storage_14,
  t0.heading AS heading_15,
  t0.working_hours AS working_hours_16,
  t0.address AS address_17,
  t0.is_availability AS is_availability_18,
  t0.is_corporate AS is_corporate_19,
  t0.address_short AS address_short_20,
  t0.is_main AS is_main_21,
  t0.code AS code_22,
  t0.shop_id AS shop_id_23,
  t0.region_shop_id AS region_shop_id_24
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_published AS is_published_4, t0.sort AS sort_5, t0.map_latitude AS map_latitude_6, t0.map_longitude AS map_longitude_7, t0.slug_short AS slug_short_8, t0.is_default AS is_default_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.html_map AS html_map_12, t0.html_link AS html_link_13, t0.is_storage AS is_storage_14, t0.heading AS heading_15, t0.working_hours AS working_hours_16, t0.address AS address_17, t0.is_availability AS is_availability_18, t0.is_corporate AS is_corporate_19, t0.address_short AS address_short_20, t0.is_main AS is_main_21, t0.code AS code_22, t0.shop_id AS shop_id_23, t0.region_shop_id AS region_shop_id_24 FROM shop t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.created_at AS created_at_3,
  t0.product_id AS product_id_4,
  t0.user_id AS user_id_5
FROM
  wish_product t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.product_id AS product_id_4, t0.user_id AS user_id_5 FROM wish_product t0 WHERE t0.session_id = 'bea9ebb6-4997-4462-9b15-500c25a42814' ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.count AS count_3,
  t0.created_at AS created_at_4,
  t0.price AS price_5,
  t0.product_id AS product_id_6,
  t0.user_id AS user_id_7
FROM
  cart_product t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.count AS count_3, t0.created_at AS created_at_4, t0.price AS price_5, t0.product_id AS product_id_6, t0.user_id AS user_id_7 FROM cart_product t0 WHERE t0.session_id = 'bea9ebb6-4997-4462-9b15-500c25a42814' ORDER BY t0.created_at ASC;

SELECT
  COUNT(*)
FROM
  user_notification t0
WHERE
  t0.user_id IS NULL
  AND t0.is_read = ?

SELECT COUNT(*) FROM user_notification t0 WHERE t0.user_id IS NULL AND t0.is_read = 0;

SELECT
  COUNT(*)
FROM
  `order` t0
WHERE
  t0.user_id IS NULL

SELECT COUNT(*) FROM `order` t0 WHERE t0.user_id IS NULL;

SELECT
  COUNT(*)
FROM
  feedback t0
WHERE
  t0.user_id IS NULL
  AND t0.closed_at IS NULL

SELECT COUNT(*) FROM feedback t0 WHERE t0.user_id IS NULL AND t0.closed_at IS NULL;