Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name AS name_2,
  c0_.name_vo AS name_vo_3,
  c0_.french AS french_4,
  c0_.view_box AS view_box_5,
  c0_.department_label AS department_label_6,
  c0_.displayed AS displayed_7
FROM
  country c0_
  INNER JOIN shop s1_ ON c0_.id = s1_.country_id
  INNER JOIN shop_tournament s2_ ON s1_.id = s2_.shop_id
WHERE
  s2_.slug IS NOT NULL
  AND s2_.event_type_id IS NOT NULL
  AND s1_.slug IS NOT NULL
ORDER BY
  c0_.french DESC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.name_vo AS name_vo_3, c0_.french AS french_4, c0_.view_box AS view_box_5, c0_.department_label AS department_label_6, c0_.displayed AS displayed_7 FROM country c0_ INNER JOIN shop s1_ ON c0_.id = s1_.country_id INNER JOIN shop_tournament s2_ ON s1_.id = s2_.shop_id WHERE s2_.slug IS NOT NULL AND s2_.event_type_id IS NOT NULL AND s1_.slug IS NOT NULL ORDER BY c0_.french DESC, c0_.name ASC;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  card c0_
  INNER JOIN serie s1_ ON c0_.serie_id = s1_.id
WHERE
  c0_.displayed = 1
  AND c0_.slug IS NOT NULL
  AND c0_.current_price IS NOT NULL
  AND c0_.cardnexus_current_price IS NOT NULL
  AND c0_.website_id = ?
  AND c0_.cardnexus_current_price < c0_.current_price

SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id WHERE c0_.displayed = 1 AND c0_.slug IS NOT NULL AND c0_.current_price IS NOT NULL AND c0_.cardnexus_current_price IS NOT NULL AND c0_.website_id = 1 AND c0_.cardnexus_current_price < c0_.current_price;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.pseudo AS pseudo_3,
  t0.play_id AS play_id_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.reset_password_link AS reset_password_link_7,
  t0.last_login_date AS last_login_date_8,
  t0.facebook_id AS facebook_id_9,
  t0.facebook_access_token AS facebook_access_token_10,
  t0.google_id AS google_id_11,
  t0.discord_id AS discord_id_12,
  t0.seller_name AS seller_name_13,
  t0.achievements_points AS achievements_points_14,
  t0.nb_logins AS nb_logins_15,
  t0.nb_logins_in_arow AS nb_logins_in_arow_16,
  t0.max_logins_in_arow AS max_logins_in_arow_17,
  t0.capsule_count AS capsule_count_18,
  t0.api_id AS api_id_19,
  t0.credits AS credits_20,
  t0.cardnexus_mail AS cardnexus_mail_21,
  t0.creation_date AS creation_date_22,
  t0.update_date AS update_date_23,
  t0.avatar_id AS avatar_id_24,
  t0.data_player_id AS data_player_id_25,
  t0.country_id AS country_id_26,
  t0.department_id AS department_id_27,
  t0.website_id AS website_id_28,
  t0.category,
  t0.youtube_channel AS youtube_channel_29
FROM
  user t0
  INNER JOIN shop_user ON t0.id = shop_user.user_id
WHERE
  shop_user.shop_id = ?
  AND t0.category IN ('USER', 'VIDEOGRAPHER')

SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 INNER JOIN shop_user ON t0.id = shop_user.user_id WHERE shop_user.shop_id = 50 AND t0.category IN ('USER', 'VIDEOGRAPHER');

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  shop s0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      shop_web_site s1_
    WHERE
      s1_.shop_id = s0_.id
      AND s1_.web_site_id IN (?)
  )

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM shop s0_ WHERE EXISTS (SELECT 1 FROM shop_web_site s1_ WHERE s1_.shop_id = s0_.id AND s1_.web_site_id IN (1));

SELECT
  s0_.id AS id_0,
  s0_.official_id AS official_id_1,
  s0_.name AS name_2,
  s0_.business_hours AS business_hours_3,
  s0_.regular_holiday AS regular_holiday_4,
  s0_.shop_website AS shop_website_5,
  s0_.phone_number AS phone_number_6,
  s0_.email AS email_7,
  s0_.email2 AS email2_8,
  s0_.img_ready AS img_ready_9,
  s0_.slug AS slug_10,
  s0_.slug_en AS slug_en_11,
  s0_.bandai_tcgid AS bandai_tcgid_12,
  s0_.address AS address_13,
  s0_.zip_code AS zip_code_14,
  s0_.pref_code AS pref_code_15,
  s0_.country_code AS country_code_16,
  s0_.city AS city_17,
  s0_.latitude AS latitude_18,
  s0_.longitude AS longitude_19,
  s0_.social_network AS social_network_20,
  s0_.facebook AS facebook_21,
  s0_.instagram AS instagram_22,
  s0_.discord AS discord_23,
  s0_.like_count AS like_count_24,
  s0_.creation_date AS creation_date_25,
  s0_.update_date AS update_date_26,
  s0_.country_id AS country_id_27,
  s0_.website_id AS website_id_28
FROM
  shop s0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      shop_web_site s1_
    WHERE
      s1_.shop_id = s0_.id
      AND s1_.web_site_id IN (?)
  )
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.official_id AS official_id_1, s0_.name AS name_2, s0_.business_hours AS business_hours_3, s0_.regular_holiday AS regular_holiday_4, s0_.shop_website AS shop_website_5, s0_.phone_number AS phone_number_6, s0_.email AS email_7, s0_.email2 AS email2_8, s0_.img_ready AS img_ready_9, s0_.slug AS slug_10, s0_.slug_en AS slug_en_11, s0_.bandai_tcgid AS bandai_tcgid_12, s0_.address AS address_13, s0_.zip_code AS zip_code_14, s0_.pref_code AS pref_code_15, s0_.country_code AS country_code_16, s0_.city AS city_17, s0_.latitude AS latitude_18, s0_.longitude AS longitude_19, s0_.social_network AS social_network_20, s0_.facebook AS facebook_21, s0_.instagram AS instagram_22, s0_.discord AS discord_23, s0_.like_count AS like_count_24, s0_.creation_date AS creation_date_25, s0_.update_date AS update_date_26, s0_.country_id AS country_id_27, s0_.website_id AS website_id_28 FROM shop s0_ WHERE EXISTS (SELECT 1 FROM shop_web_site s1_ WHERE s1_.shop_id = s0_.id AND s1_.web_site_id IN (1)) AND s0_.id IN (50, 20, 25, 1733, 38, 1434, 42, 1056, 115, 95, 2321, 1450, 1496, 227, 9, 15, 218, 536, 1, 36, 1945, 1441, 2, 2061, 51, 14, 129, 89, 97, 148) ORDER BY s0_.name ASC;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.name AS name_1
FROM
  shop s0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      shop_web_site s1_
    WHERE
      s1_.shop_id = s0_.id
      AND s1_.web_site_id IN (?)
  )
ORDER BY
  s0_.name ASC
LIMIT
  30

SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1 FROM shop s0_ WHERE EXISTS (SELECT 1 FROM shop_web_site s1_ WHERE s1_.shop_id = s0_.id AND s1_.web_site_id IN (1)) ORDER BY s0_.name ASC LIMIT 30;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.extended_name AS extended_name_4,
  t0.domain AS domain_5,
  t0.item_image_prefix AS item_image_prefix_6,
  t0.image_prefix AS image_prefix_7,
  t0.image_enprefix AS image_enprefix_8,
  t0.facebook AS facebook_9,
  t0.discord AS discord_10,
  t0.instagram AS instagram_11,
  t0.decks AS decks_12,
  t0.wishlists AS wishlists_13,
  t0.achievements AS achievements_14,
  t0.blog AS blog_15,
  t0.shops AS shops_16,
  t0.ranking AS ranking_17,
  t0.rules AS rules_18,
  t0.videos AS videos_19,
  t0.eras AS eras_20,
  t0.characters AS characters_21,
  t0.grading AS grading_22,
  t0.year AS year_23,
  t0.game AS game_24,
  t0.game_condensed AS game_condensed_25,
  t0.static_folder AS static_folder_26,
  t0.untap_ccg_type AS untap_ccg_type_27,
  t0.rarity_iconable AS rarity_iconable_28,
  t0.description AS description_29,
  t0.cardmarket_game_id AS cardmarket_game_id_30,
  t0.cardnexus_game_key AS cardnexus_game_key_31,
  t0.displayed AS displayed_32,
  t0.sort_order AS sort_order_33,
  t0.default_language_id AS default_language_id_34,
  t0.form_filters_id AS form_filters_id_35
FROM
  web_site t0
WHERE
  t0.reference = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.extended_name AS extended_name_4, t0.domain AS domain_5, t0.item_image_prefix AS item_image_prefix_6, t0.image_prefix AS image_prefix_7, t0.image_enprefix AS image_enprefix_8, t0.facebook AS facebook_9, t0.discord AS discord_10, t0.instagram AS instagram_11, t0.decks AS decks_12, t0.wishlists AS wishlists_13, t0.achievements AS achievements_14, t0.blog AS blog_15, t0.shops AS shops_16, t0.ranking AS ranking_17, t0.rules AS rules_18, t0.videos AS videos_19, t0.eras AS eras_20, t0.characters AS characters_21, t0.grading AS grading_22, t0.year AS year_23, t0.game AS game_24, t0.game_condensed AS game_condensed_25, t0.static_folder AS static_folder_26, t0.untap_ccg_type AS untap_ccg_type_27, t0.rarity_iconable AS rarity_iconable_28, t0.description AS description_29, t0.cardmarket_game_id AS cardmarket_game_id_30, t0.cardnexus_game_key AS cardnexus_game_key_31, t0.displayed AS displayed_32, t0.sort_order AS sort_order_33, t0.default_language_id AS default_language_id_34, t0.form_filters_id AS form_filters_id_35 FROM web_site t0 WHERE t0.reference = 'dbscards' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.sort_order AS sort_order_4
FROM
  language t0
  INNER JOIN web_site_language ON t0.id = web_site_language.language_id
WHERE
  web_site_language.web_site_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.sort_order AS sort_order_4 FROM language t0 INNER JOIN web_site_language ON t0.id = web_site_language.language_id WHERE web_site_language.web_site_id = 1 ORDER BY t0.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.max_same_cards AS max_same_cards_2,
  t0.leader AS leader_3,
  t0.start_hand_length AS start_hand_length_4,
  t0.leader_first AS leader_first_5,
  t0.mulligan AS mulligan_6,
  t0.nb_max_cards AS nb_max_cards_7,
  t0.default_deck_area_id AS default_deck_area_id_8,
  t0.website_id AS website_id_9
FROM
  deckbuilder t0
WHERE
  t0.website_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.max_same_cards AS max_same_cards_2, t0.leader AS leader_3, t0.start_hand_length AS start_hand_length_4, t0.leader_first AS leader_first_5, t0.mulligan AS mulligan_6, t0.nb_max_cards AS nb_max_cards_7, t0.default_deck_area_id AS default_deck_area_id_8, t0.website_id AS website_id_9 FROM deckbuilder t0 WHERE t0.website_id = 1 LIMIT 1;