Symfony Profiler

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.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.promo_price AS promo_price_5,
  t0.available AS available_6,
  t0.preorder AS preorder_7,
  t0.preorder_date AS preorder_date_8,
  t0.nb_items AS nb_items_9,
  t0.redirection AS redirection_10,
  t0.group_ref AS group_ref_11,
  t0.brand AS brand_12,
  t0.displayed AS displayed_13,
  t0.creation_date AS creation_date_14,
  t0.update_date AS update_date_15,
  t0.slug AS slug_16,
  t0.slug_en AS slug_en_17,
  t0.link AS link_18,
  t0.cmid AS cmid_19,
  t0.url AS url_20,
  t0.image AS image_21,
  t0.current_price AS current_price_22,
  t0.yesterday_price AS yesterday_price_23,
  t0.last_price_update AS last_price_update_24,
  t0.cardnexus_id AS cardnexus_id_25,
  t0.cardnexus_current_price AS cardnexus_current_price_26,
  t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_27,
  t0.cardnexus_last_price_update AS cardnexus_last_price_update_28,
  t0.lang AS lang_29,
  t0.release_date AS release_date_30,
  t0.category_id AS category_id_31,
  t0.serie_id AS serie_id_32,
  t0.website_id AS website_id_33
FROM
  product t0
WHERE
  t0.displayed = ?
  AND t0.slug = ?
  AND t0.website_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.promo_price AS promo_price_5, t0.available AS available_6, t0.preorder AS preorder_7, t0.preorder_date AS preorder_date_8, t0.nb_items AS nb_items_9, t0.redirection AS redirection_10, t0.group_ref AS group_ref_11, t0.brand AS brand_12, t0.displayed AS displayed_13, t0.creation_date AS creation_date_14, t0.update_date AS update_date_15, t0.slug AS slug_16, t0.slug_en AS slug_en_17, t0.link AS link_18, t0.cmid AS cmid_19, t0.url AS url_20, t0.image AS image_21, t0.current_price AS current_price_22, t0.yesterday_price AS yesterday_price_23, t0.last_price_update AS last_price_update_24, t0.cardnexus_id AS cardnexus_id_25, t0.cardnexus_current_price AS cardnexus_current_price_26, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_27, t0.cardnexus_last_price_update AS cardnexus_last_price_update_28, t0.lang AS lang_29, t0.release_date AS release_date_30, t0.category_id AS category_id_31, t0.serie_id AS serie_id_32, t0.website_id AS website_id_33 FROM product t0 WHERE t0.displayed = 1 AND t0.slug = 'ultimate-starter-box-vegeta-super-saiyan-4' AND t0.website_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.no_language AS no_language_3,
  t0.displayed AS displayed_4,
  t0.creation_date AS creation_date_5,
  t0.update_date AS update_date_6,
  t0.slug AS slug_7,
  t0.slug_en AS slug_en_8,
  t0.link AS link_9,
  t0.parent_id AS parent_id_10
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.no_language AS no_language_3, t0.displayed AS displayed_4, t0.creation_date AS creation_date_5, t0.update_date AS update_date_6, t0.slug AS slug_7, t0.slug_en AS slug_en_8, t0.link AS link_9, t0.parent_id AS parent_id_10 FROM product_category t0 WHERE t0.id = 6;

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;

SELECT
  COUNT(c0_.id) AS sclr_0,
  SUM(c0_.current_price) AS sclr_1,
  MAX(c0_.current_price) AS sclr_2,
  AVG(c0_.current_price) AS sclr_3
FROM
  card c0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      product_card p1_
    WHERE
      p1_.card_id = c0_.id
      AND p1_.product_id IN (?)
  )
  AND c0_.slug IS NOT NULL
  AND c0_.displayed = 1
ORDER BY
  c0_.current_price DESC,
  c0_.release_date DESC,
  c0_.number DESC,
  c0_.id DESC

SELECT COUNT(c0_.id) AS sclr_0, SUM(c0_.current_price) AS sclr_1, MAX(c0_.current_price) AS sclr_2, AVG(c0_.current_price) AS sclr_3 FROM card c0_ WHERE EXISTS (SELECT 1 FROM product_card p1_ WHERE p1_.card_id = c0_.id AND p1_.product_id IN (278)) AND c0_.slug IS NOT NULL AND c0_.displayed = 1 ORDER BY c0_.current_price DESC, c0_.release_date DESC, c0_.number DESC, c0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.main_product_id AS main_product_id_3,
  t0.content_product_id AS content_product_id_4
FROM
  product_content t0
WHERE
  t0.main_product_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.main_product_id AS main_product_id_3, t0.content_product_id AS content_product_id_4 FROM product_content t0 WHERE t0.main_product_id = 278;

SELECT
  c0_.id AS id_0,
  c0_.number AS number_1,
  c0_.serial_number AS serial_number_2,
  c0_.front_name AS front_name_3,
  c0_.front_description AS front_description_4,
  c0_.front_energy_cost AS front_energy_cost_5,
  c0_.secondary_cost AS secondary_cost_6,
  c0_.front_energy_cost_alias AS front_energy_cost_alias_7,
  c0_.front_energy_color_cost AS front_energy_color_cost_8,
  c0_.back_energy_color_cost AS back_energy_color_cost_9,
  c0_.front_combo_cost AS front_combo_cost_10,
  c0_.front_combo_power AS front_combo_power_11,
  c0_.front_power AS front_power_12,
  c0_.front_defense AS front_defense_13,
  c0_.back_name AS back_name_14,
  c0_.back_description AS back_description_15,
  c0_.back_power AS back_power_16,
  c0_.back_power2 AS back_power2_17,
  c0_.back_defense AS back_defense_18,
  c0_.back_defense2 AS back_defense2_19,
  c0_.img_ready AS img_ready_20,
  c0_.image_ready AS image_ready_21,
  c0_.multicolor AS multicolor_22,
  c0_.limited AS limited_23,
  c0_.banned AS banned_24,
  c0_.unlimited_in_deck AS unlimited_in_deck_25,
  c0_.limitation_in_deck AS limitation_in_deck_26,
  c0_.reprint AS reprint_27,
  c0_.foil AS foil_28,
  c0_.reprint_category AS reprint_category_29,
  c0_.animated AS animated_30,
  c0_.version_number AS version_number_31,
  c0_.front_name_alias AS front_name_alias_32,
  c0_.front_name_en AS front_name_en_33,
  c0_.back_name_en AS back_name_en_34,
  c0_.front_description_en AS front_description_en_35,
  c0_.back_description_en AS back_description_en_36,
  c0_.english_only AS english_only_37,
  c0_.redirect_english_slug AS redirect_english_slug_38,
  c0_.position_serie_list AS position_serie_list_39,
  c0_.lore AS lore_40,
  c0_.subname AS subname_41,
  c0_.illustrator AS illustrator_42,
  c0_.energyzable AS energyzable_43,
  c0_.weakness AS weakness_44,
  c0_.resistance AS resistance_45,
  c0_.sub_description AS sub_description_46,
  c0_.exclusive AS exclusive_47,
  c0_.end_of_serie AS end_of_serie_48,
  c0_.verso AS verso_49,
  c0_.additional_data AS additional_data_50,
  c0_.ocr_keywords_count AS ocr_keywords_count_51,
  c0_.beta AS beta_52,
  c0_.level AS level_53,
  c0_.price_alert AS price_alert_54,
  c0_.creation_date AS creation_date_55,
  c0_.update_date AS update_date_56,
  c0_.displayed AS displayed_57,
  c0_.slug AS slug_58,
  c0_.slug_en AS slug_en_59,
  c0_.view_count AS view_count_60,
  c0_.cmid AS cmid_61,
  c0_.url AS url_62,
  c0_.image AS image_63,
  c0_.current_price AS current_price_64,
  c0_.yesterday_price AS yesterday_price_65,
  c0_.last_price_update AS last_price_update_66,
  c0_.cardnexus_id AS cardnexus_id_67,
  c0_.cardnexus_current_price AS cardnexus_current_price_68,
  c0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_69,
  c0_.cardnexus_last_price_update AS cardnexus_last_price_update_70,
  c0_.lang AS lang_71,
  c0_.release_date AS release_date_72,
  c0_.complete AS complete_73,
  c0_.bandai_tcgid AS bandai_tcgid_74,
  c0_.checked AS checked_75,
  c0_.indexable AS indexable_76,
  c0_.front_era_id AS front_era_id_77,
  c0_.back_era_id AS back_era_id_78,
  c0_.type_id AS type_id_79,
  c0_.serie_id AS serie_id_80,
  c0_.rarity_id AS rarity_id_81,
  c0_.group_version_id AS group_version_id_82,
  c0_.avatar_id AS avatar_id_83,
  c0_.version_id AS version_id_84,
  c0_.auto_play_id AS auto_play_id_85,
  c0_.version_annotation_id AS version_annotation_id_86,
  c0_.website_id AS website_id_87
FROM
  card c0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      product_card p1_
    WHERE
      p1_.card_id = c0_.id
      AND p1_.product_id IN (?)
  )
  AND c0_.slug IS NOT NULL
  AND c0_.displayed = 1
ORDER BY
  c0_.current_price DESC,
  c0_.release_date DESC,
  c0_.number DESC,
  c0_.id DESC
LIMIT
  15

SELECT c0_.id AS id_0, c0_.number AS number_1, c0_.serial_number AS serial_number_2, c0_.front_name AS front_name_3, c0_.front_description AS front_description_4, c0_.front_energy_cost AS front_energy_cost_5, c0_.secondary_cost AS secondary_cost_6, c0_.front_energy_cost_alias AS front_energy_cost_alias_7, c0_.front_energy_color_cost AS front_energy_color_cost_8, c0_.back_energy_color_cost AS back_energy_color_cost_9, c0_.front_combo_cost AS front_combo_cost_10, c0_.front_combo_power AS front_combo_power_11, c0_.front_power AS front_power_12, c0_.front_defense AS front_defense_13, c0_.back_name AS back_name_14, c0_.back_description AS back_description_15, c0_.back_power AS back_power_16, c0_.back_power2 AS back_power2_17, c0_.back_defense AS back_defense_18, c0_.back_defense2 AS back_defense2_19, c0_.img_ready AS img_ready_20, c0_.image_ready AS image_ready_21, c0_.multicolor AS multicolor_22, c0_.limited AS limited_23, c0_.banned AS banned_24, c0_.unlimited_in_deck AS unlimited_in_deck_25, c0_.limitation_in_deck AS limitation_in_deck_26, c0_.reprint AS reprint_27, c0_.foil AS foil_28, c0_.reprint_category AS reprint_category_29, c0_.animated AS animated_30, c0_.version_number AS version_number_31, c0_.front_name_alias AS front_name_alias_32, c0_.front_name_en AS front_name_en_33, c0_.back_name_en AS back_name_en_34, c0_.front_description_en AS front_description_en_35, c0_.back_description_en AS back_description_en_36, c0_.english_only AS english_only_37, c0_.redirect_english_slug AS redirect_english_slug_38, c0_.position_serie_list AS position_serie_list_39, c0_.lore AS lore_40, c0_.subname AS subname_41, c0_.illustrator AS illustrator_42, c0_.energyzable AS energyzable_43, c0_.weakness AS weakness_44, c0_.resistance AS resistance_45, c0_.sub_description AS sub_description_46, c0_.exclusive AS exclusive_47, c0_.end_of_serie AS end_of_serie_48, c0_.verso AS verso_49, c0_.additional_data AS additional_data_50, c0_.ocr_keywords_count AS ocr_keywords_count_51, c0_.beta AS beta_52, c0_.level AS level_53, c0_.price_alert AS price_alert_54, c0_.creation_date AS creation_date_55, c0_.update_date AS update_date_56, c0_.displayed AS displayed_57, c0_.slug AS slug_58, c0_.slug_en AS slug_en_59, c0_.view_count AS view_count_60, c0_.cmid AS cmid_61, c0_.url AS url_62, c0_.image AS image_63, c0_.current_price AS current_price_64, c0_.yesterday_price AS yesterday_price_65, c0_.last_price_update AS last_price_update_66, c0_.cardnexus_id AS cardnexus_id_67, c0_.cardnexus_current_price AS cardnexus_current_price_68, c0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_69, c0_.cardnexus_last_price_update AS cardnexus_last_price_update_70, c0_.lang AS lang_71, c0_.release_date AS release_date_72, c0_.complete AS complete_73, c0_.bandai_tcgid AS bandai_tcgid_74, c0_.checked AS checked_75, c0_.indexable AS indexable_76, c0_.front_era_id AS front_era_id_77, c0_.back_era_id AS back_era_id_78, c0_.type_id AS type_id_79, c0_.serie_id AS serie_id_80, c0_.rarity_id AS rarity_id_81, c0_.group_version_id AS group_version_id_82, c0_.avatar_id AS avatar_id_83, c0_.version_id AS version_id_84, c0_.auto_play_id AS auto_play_id_85, c0_.version_annotation_id AS version_annotation_id_86, c0_.website_id AS website_id_87 FROM card c0_ WHERE EXISTS (SELECT 1 FROM product_card p1_ WHERE p1_.card_id = c0_.id AND p1_.product_id IN (278)) AND c0_.slug IS NOT NULL AND c0_.displayed = 1 ORDER BY c0_.current_price DESC, c0_.release_date DESC, c0_.number DESC, c0_.id DESC LIMIT 15;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.price AS price_3,
  p0_.promo_price AS promo_price_4,
  p0_.available AS available_5,
  p0_.preorder AS preorder_6,
  p0_.preorder_date AS preorder_date_7,
  p0_.nb_items AS nb_items_8,
  p0_.redirection AS redirection_9,
  p0_.group_ref AS group_ref_10,
  p0_.brand AS brand_11,
  p0_.displayed AS displayed_12,
  p0_.creation_date AS creation_date_13,
  p0_.update_date AS update_date_14,
  p0_.slug AS slug_15,
  p0_.slug_en AS slug_en_16,
  p0_.link AS link_17,
  p0_.cmid AS cmid_18,
  p0_.url AS url_19,
  p0_.image AS image_20,
  p0_.current_price AS current_price_21,
  p0_.yesterday_price AS yesterday_price_22,
  p0_.last_price_update AS last_price_update_23,
  p0_.cardnexus_id AS cardnexus_id_24,
  p0_.cardnexus_current_price AS cardnexus_current_price_25,
  p0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_26,
  p0_.cardnexus_last_price_update AS cardnexus_last_price_update_27,
  p0_.lang AS lang_28,
  p0_.release_date AS release_date_29,
  p0_.category_id AS category_id_30,
  p0_.serie_id AS serie_id_31,
  p0_.website_id AS website_id_32
FROM
  product p0_
WHERE
  p0_.group_ref = ?
  AND p0_.website_id = ?
  AND p0_.displayed = 1
  AND p0_.redirection IS NULL
  AND p0_.id <> ?
ORDER BY
  p0_.available DESC,
  p0_.release_date DESC,
  p0_.price ASC,
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.promo_price AS promo_price_4, p0_.available AS available_5, p0_.preorder AS preorder_6, p0_.preorder_date AS preorder_date_7, p0_.nb_items AS nb_items_8, p0_.redirection AS redirection_9, p0_.group_ref AS group_ref_10, p0_.brand AS brand_11, p0_.displayed AS displayed_12, p0_.creation_date AS creation_date_13, p0_.update_date AS update_date_14, p0_.slug AS slug_15, p0_.slug_en AS slug_en_16, p0_.link AS link_17, p0_.cmid AS cmid_18, p0_.url AS url_19, p0_.image AS image_20, p0_.current_price AS current_price_21, p0_.yesterday_price AS yesterday_price_22, p0_.last_price_update AS last_price_update_23, p0_.cardnexus_id AS cardnexus_id_24, p0_.cardnexus_current_price AS cardnexus_current_price_25, p0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_26, p0_.cardnexus_last_price_update AS cardnexus_last_price_update_27, p0_.lang AS lang_28, p0_.release_date AS release_date_29, p0_.category_id AS category_id_30, p0_.serie_id AS serie_id_31, p0_.website_id AS website_id_32 FROM product p0_ WHERE p0_.group_ref = NULL AND p0_.website_id = 1 AND p0_.displayed = 1 AND p0_.redirection IS NULL AND p0_.id <> 278 ORDER BY p0_.available DESC, p0_.release_date DESC, p0_.price ASC, p0_.id DESC;

SELECT
  v0_.id AS id_0,
  v0_.identifier AS identifier_1,
  v0_.name AS name_2,
  v0_.description AS description_3,
  v0_.short_description AS short_description_4,
  v0_.publish_date AS publish_date_5,
  v0_.creation_date AS creation_date_6,
  v0_.update_date AS update_date_7,
  v0_.slug AS slug_8,
  v0_.slug_en AS slug_en_9,
  v0_.displayed AS displayed_10,
  v0_.view_count AS view_count_11,
  v0_.like_count AS like_count_12,
  v0_.lang AS lang_13,
  v0_.mark AS mark_14,
  v0_.media AS media_15,
  v0_.videographer_id AS videographer_id_16,
  v0_.source_id AS source_id_17,
  v0_.website_id AS website_id_18
FROM
  video v0_
WHERE
  (
    v0_.displayed = 1
    AND EXISTS (
      SELECT
        1
      FROM
        video_product v1_
      WHERE
        v1_.video_id = v0_.id
        AND v1_.product_id IN (?)
    )
    AND v0_.website_id = ?
  )
  AND v0_.media IN ('YOUTUBE')
ORDER BY
  v0_.creation_date DESC

SELECT v0_.id AS id_0, v0_.identifier AS identifier_1, v0_.name AS name_2, v0_.description AS description_3, v0_.short_description AS short_description_4, v0_.publish_date AS publish_date_5, v0_.creation_date AS creation_date_6, v0_.update_date AS update_date_7, v0_.slug AS slug_8, v0_.slug_en AS slug_en_9, v0_.displayed AS displayed_10, v0_.view_count AS view_count_11, v0_.like_count AS like_count_12, v0_.lang AS lang_13, v0_.mark AS mark_14, v0_.media AS media_15, v0_.videographer_id AS videographer_id_16, v0_.source_id AS source_id_17, v0_.website_id AS website_id_18 FROM video v0_ WHERE (v0_.displayed = 1 AND EXISTS (SELECT 1 FROM video_product v1_ WHERE v1_.video_id = v0_.id AND v1_.product_id IN (278)) AND v0_.website_id = 1) AND v0_.media IN ('YOUTUBE') ORDER BY v0_.creation_date DESC;

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.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.name AS name_2,
  t0.no_language AS no_language_3,
  t0.displayed AS displayed_4,
  t0.creation_date AS creation_date_5,
  t0.update_date AS update_date_6,
  t0.slug AS slug_7,
  t0.slug_en AS slug_en_8,
  t0.link AS link_9,
  t0.parent_id AS parent_id_10
FROM
  product_category t0
WHERE
  t0.displayed = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.no_language AS no_language_3, t0.displayed AS displayed_4, t0.creation_date AS creation_date_5, t0.update_date AS update_date_6, t0.slug AS slug_7, t0.slug_en AS slug_en_8, t0.link AS link_9, t0.parent_id AS parent_id_10 FROM product_category t0 WHERE t0.displayed = 1 AND t0.slug = 'ultimate-starter-box-vegeta-super-saiyan-4' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.promo_price AS promo_price_5,
  t0.available AS available_6,
  t0.preorder AS preorder_7,
  t0.preorder_date AS preorder_date_8,
  t0.nb_items AS nb_items_9,
  t0.redirection AS redirection_10,
  t0.group_ref AS group_ref_11,
  t0.brand AS brand_12,
  t0.displayed AS displayed_13,
  t0.creation_date AS creation_date_14,
  t0.update_date AS update_date_15,
  t0.slug AS slug_16,
  t0.slug_en AS slug_en_17,
  t0.link AS link_18,
  t0.cmid AS cmid_19,
  t0.url AS url_20,
  t0.image AS image_21,
  t0.current_price AS current_price_22,
  t0.yesterday_price AS yesterday_price_23,
  t0.last_price_update AS last_price_update_24,
  t0.cardnexus_id AS cardnexus_id_25,
  t0.cardnexus_current_price AS cardnexus_current_price_26,
  t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_27,
  t0.cardnexus_last_price_update AS cardnexus_last_price_update_28,
  t0.lang AS lang_29,
  t0.release_date AS release_date_30,
  t0.category_id AS category_id_31,
  t0.serie_id AS serie_id_32,
  t0.website_id AS website_id_33
FROM
  product t0
WHERE
  t0.displayed = ?
  AND t0.slug = ?
  AND t0.website_id = ?
LIMIT
  1