Symfony Profiler

SELECT
  a0_.`id` AS id_0,
  b1_.`amount` AS amount_1,
  b2_.`name` AS name_2,
  b2_.`status` AS status_3,
  b2_.`bank_transfer_requested` AS bank_transfer_requested_4
FROM
  `buy_order` b2_
  LEFT JOIN `buy_order_article` b1_ ON b2_.id = b1_.buy_order_id
  LEFT JOIN `article` a0_ ON b1_.article_id = a0_.id
WHERE
  b2_.`status` IN (1, 2, 3)
  AND a0_.`id` <> ''
  AND b2_.`token` = ?
  AND b2_.`status` <> 12
ORDER BY
  b1_.`amount` DESC

SELECT a0_.`id` AS id_0, b1_.`amount` AS amount_1, b2_.`name` AS name_2, b2_.`status` AS status_3, b2_.`bank_transfer_requested` AS bank_transfer_requested_4 FROM `buy_order` b2_ LEFT JOIN `buy_order_article` b1_ ON b2_.id = b1_.buy_order_id LEFT JOIN `article` a0_ ON b1_.article_id = a0_.id WHERE b2_.`status` IN (1, 2, 3) AND a0_.`id` <> '' AND b2_.`token` = 'a134701d0c4a2138641d25a597a5855e9a913e92302ecfb4aacee9bada1a894e' AND b2_.`status` <> 12 ORDER BY b1_.`amount` DESC;

SELECT
  lu.en AS slug
FROM
  publication p
  LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id
  LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id
  LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id
WHERE
  p.id = 2232
  AND lp.en = 1
  AND lst.en = 1;

SELECT
       			lu.en AS slug
            FROM
                publication p
            LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id
            LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id
            LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id
			WHERE p.id = 2232 AND lp.en = 1 AND lst.en = 1;
            ;

SELECT
  u0_.`id` AS id_0,
  u0_.`unid` AS unid_1,
  u0_.`corporate_unid` AS corporate_unid_2,
  u0_.`token` AS token_3,
  u0_.`is_active` AS is_active_4,
  u0_.`proved` AS proved_5,
  u0_.`alias` AS alias_6,
  u0_.`foreign_alias` AS foreign_alias_7,
  u0_.`lotus_name` AS lotus_name_8,
  u0_.`password` AS password_9,
  u0_.`expired` AS expired_10,
  u0_.`expires_at` AS expires_at_11,
  u0_.`credentials_expired` AS credentials_expired_12,
  u0_.`credentials_expire_at` AS credentials_expire_at_13,
  u0_.`last_ip` AS last_ip_14,
  u0_.`source` AS source_15,
  u0_.`social_network` AS social_network_16,
  u0_.`social_network_id` AS social_network_id_17,
  u0_.`google_id` AS google_id_18,
  u0_.`fb_id` AS fb_id_19,
  u0_.`vk_id` AS vk_id_20,
  u0_.`ig_id` AS ig_id_21,
  u0_.`test` AS test_22,
  u0_.`token_fixed` AS token_fixed_23,
  u0_.`bid` AS bid_24,
  u0_.`email` AS email_25,
  u0_.`salt` AS salt_26,
  u0_.`review_request_sent` AS review_request_sent_27,
  u0_.`username` AS username_28,
  u0_.`roles` AS roles_29,
  u0_.`enabled` AS enabled_30,
  u0_.`confirmation_token` AS confirmation_token_31,
  u0_.`last_login` AS last_login_32,
  u0_.`password_requested_at` AS password_requested_at_33,
  u0_.`security_field` AS security_field_34,
  u0_.`created_at` AS created_at_35,
  u0_.`is_legal_entity` AS is_legal_entity_36,
  u0_.`companyName` AS companyName_37,
  u0_.`vatNumber` AS vatNumber_38,
  u0_.`lang` AS lang_39
FROM
  `user` u0_
WHERE
  u0_.`token` = ?
LIMIT
  1

SELECT u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`foreign_alias` AS foreign_alias_7, u0_.`lotus_name` AS lotus_name_8, u0_.`password` AS password_9, u0_.`expired` AS expired_10, u0_.`expires_at` AS expires_at_11, u0_.`credentials_expired` AS credentials_expired_12, u0_.`credentials_expire_at` AS credentials_expire_at_13, u0_.`last_ip` AS last_ip_14, u0_.`source` AS source_15, u0_.`social_network` AS social_network_16, u0_.`social_network_id` AS social_network_id_17, u0_.`google_id` AS google_id_18, u0_.`fb_id` AS fb_id_19, u0_.`vk_id` AS vk_id_20, u0_.`ig_id` AS ig_id_21, u0_.`test` AS test_22, u0_.`token_fixed` AS token_fixed_23, u0_.`bid` AS bid_24, u0_.`email` AS email_25, u0_.`salt` AS salt_26, u0_.`review_request_sent` AS review_request_sent_27, u0_.`username` AS username_28, u0_.`roles` AS roles_29, u0_.`enabled` AS enabled_30, u0_.`confirmation_token` AS confirmation_token_31, u0_.`last_login` AS last_login_32, u0_.`password_requested_at` AS password_requested_at_33, u0_.`security_field` AS security_field_34, u0_.`created_at` AS created_at_35, u0_.`is_legal_entity` AS is_legal_entity_36, u0_.`companyName` AS companyName_37, u0_.`vatNumber` AS vatNumber_38, u0_.`lang` AS lang_39 FROM `user` u0_ WHERE u0_.`token` = 'a134701d0c4a2138641d25a597a5855e9a913e92302ecfb4aacee9bada1a894e' LIMIT 1;

SELECT
  COUNT(b0_.`code`) AS sclr_0
FROM
  `buy_order` b1_
  LEFT JOIN `buy_order_article` b0_ ON b1_.id = b0_.buy_order_id
WHERE
  b1_.`token` = ?
  AND b1_.`status` <> 12

SELECT COUNT(b0_.`code`) AS sclr_0 FROM `buy_order` b1_ LEFT JOIN `buy_order_article` b0_ ON b1_.id = b0_.buy_order_id WHERE b1_.`token` = 'a134701d0c4a2138641d25a597a5855e9a913e92302ecfb4aacee9bada1a894e' AND b1_.`status` <> 12;

SELECT
  b0_.`id` AS id_0
FROM
  `buy_order` b0_
WHERE
  b0_.`token` = ?
  AND b0_.`status` <> 12

SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = 'a134701d0c4a2138641d25a597a5855e9a913e92302ecfb4aacee9bada1a894e' AND b0_.`status` <> 12;

SELECT
  COUNT(v0_.`id`) AS sclr_0
FROM
  `visit` v0_
WHERE
  v0_.`token` = ?
  AND v0_.`url` <> '/.*catalog.*/'

SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = 'a134701d0c4a2138641d25a597a5855e9a913e92302ecfb4aacee9bada1a894e' AND v0_.`url` <> '/.*catalog.*/';

SELECT
  COUNT(i0_.`id`) AS sclr_0
FROM
  `idea` i1_
  INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id
  INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id
WHERE
  i1_.`token` = ?

SELECT COUNT(i0_.`id`) AS sclr_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = 'a134701d0c4a2138641d25a597a5855e9a913e92302ecfb4aacee9bada1a894e';

SELECT
  b0_.`id` AS id_0,
  b0_.`name` AS name_1,
  b0_.`descr` AS descr_2,
  b0_.`val` AS val_3
FROM
  `BoolDBSetting` b0_
WHERE
  b0_.`name` = ?

SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = 'RTWidget';

SELECT
  t0.`id` AS id_1,
  t0.`token` AS token_2,
  t0.`current_welcome_cons` AS current_welcome_cons_3,
  t0.`current_country` AS current_country_4,
  t0.`current_country_by_ip` AS current_country_by_ip_5,
  t0.`current_locale` AS current_locale_6,
  t0.`is_interview` AS is_interview_7,
  t0.`job_seeker_unid` AS job_seeker_unid_8,
  t0.interview_id AS interview_id_9
FROM
  `chat_b` t0
WHERE
  t0.`token` = ?
LIMIT
  1

SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`current_welcome_cons` AS current_welcome_cons_3, t0.`current_country` AS current_country_4, t0.`current_country_by_ip` AS current_country_by_ip_5, t0.`current_locale` AS current_locale_6, t0.`is_interview` AS is_interview_7, t0.`job_seeker_unid` AS job_seeker_unid_8, t0.interview_id AS interview_id_9 FROM `chat_b` t0 WHERE t0.`token` = 'a134701d0c4a2138641d25a597a5855e9a913e92302ecfb4aacee9bada1a894e' LIMIT 1;

SELECT
  b0_.`id` AS id_0,
  b0_.`name` AS name_1,
  b0_.`descr` AS descr_2,
  b0_.`val` AS val_3
FROM
  `BoolDBSetting` b0_
WHERE
  b0_.`name` = ?

SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = 'RTWidget';

SELECT
  f0_.`id` AS id_0
FROM
  `geo_country` g1_
  LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id
  LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id
WHERE
  g1_.`code` = ?

SELECT f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = 'us';

SELECT
  c0_.`id` AS id_0,
  c0_.`url` AS url_1,
  c0_.`code` AS code_2,
  c0_.`name` AS name_3,
  c0_.`alternate_name` AS alternate_name_4,
  c0_.`name_full` AS name_full_5,
  f1_.`id` AS id_6,
  f1_.`url` AS url_7,
  f1_.`unid` AS unid_8,
  f2_.`id` AS id_9,
  f1_.`url` AS url_10,
  f1_.`name` AS name_11,
  (
    SELECT
      COUNT(p3_.`star`) AS sclr_13
    FROM
      `product_reviews_cache` p3_
    WHERE
      p3_.`sku` = c0_.`code`
  ) AS sclr_12,
  (
    SELECT
      SUM(p4_.`star`) AS sclr_15
    FROM
      `product_reviews_cache` p4_
    WHERE
      p4_.`sku` = c0_.`code`
  ) AS sclr_14
FROM
  `collection` c0_
  INNER JOIN `factory` f1_ ON c0_.factory = f1_.id
  INNER JOIN `filters` f2_ ON f1_.filter = f2_.id
  INNER JOIN `list_country` l5_ ON f1_.country = l5_.id
  LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id
  LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id
WHERE
  f1_.filter IS NOT NULL
  AND c0_.factory <> ''
  AND f1_.`status` = ?
  AND f1_.`id` NOT IN (?)
  AND (
    c0_.`test_access` IS NULL
    OR c0_.`test_access` = 0
  )
  AND (
    f1_.`test_access` IS NULL
    OR f1_.`test_access` = 0
  )
  AND c0_.`status` = ?
  AND c0_.`status` = ?
  AND f1_.`status` = ?
ORDER BY
  c0_.`id` ASC

SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = 1 AND f1_.`id` NOT IN (14) AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = 1 AND c0_.`status` = 1 AND f1_.`status` = 1 ORDER BY c0_.`id` ASC;

SELECT
  COUNT(f0_.`id`) AS sclr_0
FROM
  `filters` f0_
  LEFT JOIN `factory` f1_ ON f0_.brand = f1_.id
  LEFT JOIN `filter_params` f2_ ON f0_.param_id = f2_.id
WHERE
  f0_.brand IS NOT NULL
  AND f0_.`id` <> 10639
  AND f1_.`status` = ?
  AND f2_.`is_enable` = 1
  AND f2_.`count` >= 0
  AND f1_.`unid` IS NOT NULL
  AND f1_.`test_access` IS NULL
ORDER BY
  f0_.`name` ASC

SELECT COUNT(f0_.`id`) AS sclr_0 FROM `filters` f0_ LEFT JOIN `factory` f1_ ON f0_.brand = f1_.id LEFT JOIN `filter_params` f2_ ON f0_.param_id = f2_.id WHERE f0_.brand IS NOT NULL AND f0_.`id` <> 10639 AND f1_.`status` = 1 AND f2_.`is_enable` = 1 AND f2_.`count` >= 0 AND f1_.`unid` IS NOT NULL AND f1_.`test_access` IS NULL ORDER BY f0_.`name` ASC;

SELECT
  lu.en AS slug
FROM
  publication p
  LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id
  LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id
  LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id
WHERE
  p.id = 2232
  AND lp.en = 1
  AND lst.en = 1;

SELECT
       			lu.en AS slug
            FROM
                publication p
            LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id
            LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id
            LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id
			WHERE p.id = 2232 AND lp.en = 1 AND lst.en = 1;
            ;

SELECT
  f0_.`id` AS id_0,
  f0_.`old_command` AS old_command_1,
  f0_.`old_id` AS old_id_2,
  f0_.`left_menu` AS left_menu_3,
  f1_.`id` AS id_4,
  f0_.`important` AS important_5,
  l2_.`en` AS en_6,
  f3_.`name_menu_en` AS name_menu_en_7,
  f4_.`alt_name` AS alt_name_8,
  f5_.`count` AS count_9,
  f0_.`id` AS id_10,
  f0_.`name` AS name_11,
  f0_.`alt_name` AS alt_name_12,
  f0_.`left_menu` AS left_menu_13,
  f0_.`sort` AS sort_14,
  f0_.`important` AS important_15,
  f0_.`old_command` AS old_command_16,
  f0_.`old_id` AS old_id_17,
  f0_.`sub_key` AS sub_key_18,
  f0_.`parent_key` AS parent_key_19,
  f0_.`rank` AS rank_20,
  f0_.`icon` AS icon_21,
  f0_.`icon_url` AS icon_url_22,
  f0_.`logo` AS logo_23,
  f0_.`logo_url` AS logo_url_24,
  f0_.`created_at` AS created_at_25,
  f0_.`updated_at` AS updated_at_26,
  f6_.`id` AS id_27,
  f6_.`name` AS name_28,
  f6_.`alt_name` AS alt_name_29,
  f6_.`left_menu` AS left_menu_30,
  f6_.`sort` AS sort_31,
  f6_.`important` AS important_32,
  f6_.`old_command` AS old_command_33,
  f6_.`old_id` AS old_id_34,
  f6_.`sub_key` AS sub_key_35,
  f6_.`parent_key` AS parent_key_36,
  f6_.`rank` AS rank_37,
  f6_.`icon` AS icon_38,
  f6_.`icon_url` AS icon_url_39,
  f6_.`logo` AS logo_40,
  f6_.`logo_url` AS logo_url_41,
  f6_.`created_at` AS created_at_42,
  f6_.`updated_at` AS updated_at_43
FROM
  `filters` f0_
  LEFT JOIN `locale_url` l2_ ON f0_.id = l2_.filter_id
  LEFT JOIN `filter_pages` f3_ ON f0_.page_id = f3_.id
  LEFT JOIN `filter_params` f5_ ON f0_.param_id = f5_.id
  LEFT JOIN `filter_groups` f4_ ON f0_.group_id = f4_.id
  LEFT JOIN `filters` f6_ ON f0_.country_id = f6_.id
  LEFT JOIN `filters` f1_ ON f0_.parent_id = f1_.id
WHERE
  f5_.`is_enable` = 1
  AND (
    f5_.`show_menu` = 1
    OR f5_.`show_menu_advanced` = 1
  )
  AND l2_.`en` IS NOT NULL
  AND f5_.`count` > 0
  AND f4_.`alt_name` IN (?)
ORDER BY
  f0_.`sort` ASC,
  f0_.`name` ASC

SELECT f0_.`id` AS id_0, f0_.`old_command` AS old_command_1, f0_.`old_id` AS old_id_2, f0_.`left_menu` AS left_menu_3, f1_.`id` AS id_4, f0_.`important` AS important_5, l2_.`en` AS en_6, f3_.`name_menu_en` AS name_menu_en_7, f4_.`alt_name` AS alt_name_8, f5_.`count` AS count_9, f0_.`id` AS id_10, f0_.`name` AS name_11, f0_.`alt_name` AS alt_name_12, f0_.`left_menu` AS left_menu_13, f0_.`sort` AS sort_14, f0_.`important` AS important_15, f0_.`old_command` AS old_command_16, f0_.`old_id` AS old_id_17, f0_.`sub_key` AS sub_key_18, f0_.`parent_key` AS parent_key_19, f0_.`rank` AS rank_20, f0_.`icon` AS icon_21, f0_.`icon_url` AS icon_url_22, f0_.`logo` AS logo_23, f0_.`logo_url` AS logo_url_24, f0_.`created_at` AS created_at_25, f0_.`updated_at` AS updated_at_26, f6_.`id` AS id_27, f6_.`name` AS name_28, f6_.`alt_name` AS alt_name_29, f6_.`left_menu` AS left_menu_30, f6_.`sort` AS sort_31, f6_.`important` AS important_32, f6_.`old_command` AS old_command_33, f6_.`old_id` AS old_id_34, f6_.`sub_key` AS sub_key_35, f6_.`parent_key` AS parent_key_36, f6_.`rank` AS rank_37, f6_.`icon` AS icon_38, f6_.`icon_url` AS icon_url_39, f6_.`logo` AS logo_40, f6_.`logo_url` AS logo_url_41, f6_.`created_at` AS created_at_42, f6_.`updated_at` AS updated_at_43 FROM `filters` f0_ LEFT JOIN `locale_url` l2_ ON f0_.id = l2_.filter_id LEFT JOIN `filter_pages` f3_ ON f0_.page_id = f3_.id LEFT JOIN `filter_params` f5_ ON f0_.param_id = f5_.id LEFT JOIN `filter_groups` f4_ ON f0_.group_id = f4_.id LEFT JOIN `filters` f6_ ON f0_.country_id = f6_.id LEFT JOIN `filters` f1_ ON f0_.parent_id = f1_.id WHERE f5_.`is_enable` = 1 AND (f5_.`show_menu` = 1 OR f5_.`show_menu_advanced` = 1) AND l2_.`en` IS NOT NULL AND f5_.`count` > 0 AND f4_.`alt_name` IN ('effect', 'style', 'samples', 'price', 'color', 'using', 'brand') ORDER BY f0_.`sort` ASC, f0_.`name` ASC;

SELECT
  b0_.`id` AS id_0,
  b0_.`name` AS name_1,
  b0_.`descr` AS descr_2,
  b0_.`val` AS val_3
FROM
  `BoolDBSetting` b0_
WHERE
  b0_.`name` = ?

SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = 'RTWidget';