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.identifier AS identifier_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.publish_date AS publish_date_6,
  t0.creation_date AS creation_date_7,
  t0.update_date AS update_date_8,
  t0.slug AS slug_9,
  t0.slug_en AS slug_en_10,
  t0.displayed AS displayed_11,
  t0.view_count AS view_count_12,
  t0.like_count AS like_count_13,
  t0.lang AS lang_14,
  t0.mark AS mark_15,
  t0.videographer_id AS videographer_id_16,
  t0.source_id AS source_id_17,
  t0.website_id AS website_id_18,
  t0.media
FROM
  video t0
WHERE
  t0.website_id = ?
  AND t0.slug = ?
  AND t0.media IN ('YOUTUBE')
LIMIT
  1

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.publish_date AS publish_date_6, t0.creation_date AS creation_date_7, t0.update_date AS update_date_8, t0.slug AS slug_9, t0.slug_en AS slug_en_10, t0.displayed AS displayed_11, t0.view_count AS view_count_12, t0.like_count AS like_count_13, t0.lang AS lang_14, t0.mark AS mark_15, t0.videographer_id AS videographer_id_16, t0.source_id AS source_id_17, t0.website_id AS website_id_18, t0.media FROM video t0 WHERE t0.website_id = 1 AND t0.slug = '6gsfNHvd0iA' AND t0.media IN ('YOUTUBE') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.name AS name_3,
  t0.lang AS lang_4,
  t0.displayed AS displayed_5,
  t0.website_id AS website_id_6,
  t0.source
FROM
  video_source t0
WHERE
  t0.id = ?
  AND t0.source IN ('YTB_PLAYLIST')

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.lang AS lang_4, t0.displayed AS displayed_5, t0.website_id AS website_id_6, t0.source FROM video_source t0 WHERE t0.id = 1 AND t0.source IN ('YTB_PLAYLIST');

SELECT
  d0_.id AS id_0,
  d0_.uniqid AS uniqid_1,
  d0_.name AS name_2,
  d0_.private AS private_3,
  d0_.invalid AS invalid_4,
  d0_.starter AS starter_5,
  d0_.dev_team AS dev_team_6,
  d0_.meta AS meta_7,
  d0_.total_price AS total_price_8,
  d0_.untap_click_count AS untap_click_count_9,
  d0_.creation_date AS creation_date_10,
  d0_.update_date AS update_date_11,
  d0_.view_count AS view_count_12,
  d0_.like_count AS like_count_13,
  d0_.deleted AS deleted_14,
  d0_.leader_id AS leader_id_15,
  d0_.creator_id AS creator_id_16,
  d0_.event_id AS event_id_17,
  d0_.website_id AS website_id_18
FROM
  deck d0_
WHERE
  d0_.invalid = 0
  AND d0_.deleted = 0
  AND EXISTS (
    SELECT
      1
    FROM
      video_deck v1_
    WHERE
      v1_.deck_id = d0_.id
      AND v1_.video_id IN (?)
  )

SELECT d0_.id AS id_0, d0_.uniqid AS uniqid_1, d0_.name AS name_2, d0_.private AS private_3, d0_.invalid AS invalid_4, d0_.starter AS starter_5, d0_.dev_team AS dev_team_6, d0_.meta AS meta_7, d0_.total_price AS total_price_8, d0_.untap_click_count AS untap_click_count_9, d0_.creation_date AS creation_date_10, d0_.update_date AS update_date_11, d0_.view_count AS view_count_12, d0_.like_count AS like_count_13, d0_.deleted AS deleted_14, d0_.leader_id AS leader_id_15, d0_.creator_id AS creator_id_16, d0_.event_id AS event_id_17, d0_.website_id AS website_id_18 FROM deck d0_ WHERE d0_.invalid = 0 AND d0_.deleted = 0 AND EXISTS (SELECT 1 FROM video_deck v1_ WHERE v1_.deck_id = d0_.id AND v1_.video_id IN (9869));

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_.displayed = 1
  AND EXISTS (
    SELECT
      1
    FROM
      video_product v1_
    WHERE
      v1_.product_id = p0_.id
      AND v1_.video_id IN (?)
  )

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_.displayed = 1 AND EXISTS (SELECT 1 FROM video_product v1_ WHERE v1_.product_id = p0_.id AND v1_.video_id IN (9869));

SELECT
  COUNT(v0_.ip) AS sclr_0
FROM
  video_view v0_
WHERE
  v0_.video_id = ?
  AND DATE(v0_.view_date) = ?
  AND v0_.ip = ?

SELECT COUNT(v0_.ip) AS sclr_0 FROM video_view v0_ WHERE v0_.video_id = 9869 AND DATE(v0_.view_date) = '2026-11-10' AND v0_.ip = '216.73.216.191';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO video_view (view_date, ip, video_id, user_id)
VALUES
  (?, ?, ?, ?)

INSERT INTO video_view (view_date, ip, video_id, user_id) VALUES ('2026-11-10 15:09:44', '216.73.216.191', 9869, NULL);

UPDATE
  video
SET
  view_count = ?,
  update_date = ?
WHERE
  id = ?

UPDATE video SET view_count = 535, update_date = '2026-11-10 15:09:44' WHERE id = 9869;

"COMMIT"

"COMMIT";

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_
  INNER JOIN video_source v1_ ON v0_.source_id = v1_.id
  AND v1_.source IN ('YTB_PLAYLIST')
WHERE
  (
    v1_.name = ?
    AND v0_.id <> ?
    AND v0_.displayed = 1
    AND v0_.website_id = ?
  )
  AND v0_.media IN ('YOUTUBE')
ORDER BY
  v0_.publish_date DESC
LIMIT
  5

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_ INNER JOIN video_source v1_ ON v0_.source_id = v1_.id AND v1_.source IN ('YTB_PLAYLIST') WHERE (v1_.name = 'Benji McFly' AND v0_.id <> 9869 AND v0_.displayed = 1 AND v0_.website_id = 1) AND v0_.media IN ('YOUTUBE') ORDER BY v0_.publish_date DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.name_en AS name_en_4,
  t0.description AS description_5,
  t0.website_id AS website_id_6
FROM
  video_tag t0
  INNER JOIN video_tag_video ON t0.id = video_tag_video.video_tag_id
WHERE
  video_tag_video.video_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.description AS description_5, t0.website_id AS website_id_6 FROM video_tag t0 INNER JOIN video_tag_video ON t0.id = video_tag_video.video_tag_id WHERE video_tag_video.video_id = 9869 ORDER BY t0.name ASC;

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_.id <> ?
    AND v0_.displayed = 1
    AND v0_.website_id = ?
  )
  AND v0_.media IN ('YOUTUBE')
ORDER BY
  v0_.publish_date DESC
LIMIT
  10

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_.id <> 9869 AND v0_.displayed = 1 AND v0_.website_id = 1) AND v0_.media IN ('YOUTUBE') ORDER BY v0_.publish_date DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.name AS name_3,
  t0.lang AS lang_4,
  t0.displayed AS displayed_5,
  t0.website_id AS website_id_6,
  t0.source
FROM
  video_source t0
WHERE
  t0.id = ?
  AND t0.source IN ('YTB_PLAYLIST')

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.lang AS lang_4, t0.displayed AS displayed_5, t0.website_id AS website_id_6, t0.source FROM video_source t0 WHERE t0.id = 18 AND t0.source IN ('YTB_PLAYLIST');

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
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.identifier AS identifier_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.publish_date AS publish_date_6,
  t0.creation_date AS creation_date_7,
  t0.update_date AS update_date_8,
  t0.slug AS slug_9,
  t0.slug_en AS slug_en_10,
  t0.displayed AS displayed_11,
  t0.view_count AS view_count_12,
  t0.like_count AS like_count_13,
  t0.lang AS lang_14,
  t0.mark AS mark_15,
  t0.videographer_id AS videographer_id_16,
  t0.source_id AS source_id_17,
  t0.website_id AS website_id_18,
  t0.media
FROM
  video t0
WHERE
  t0.slug = ?
  AND t0.website_id = ?
  AND t0.media IN ('YOUTUBE')
LIMIT
  1

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.publish_date AS publish_date_6, t0.creation_date AS creation_date_7, t0.update_date AS update_date_8, t0.slug AS slug_9, t0.slug_en AS slug_en_10, t0.displayed AS displayed_11, t0.view_count AS view_count_12, t0.like_count AS like_count_13, t0.lang AS lang_14, t0.mark AS mark_15, t0.videographer_id AS videographer_id_16, t0.source_id AS source_id_17, t0.website_id AS website_id_18, t0.media FROM video t0 WHERE t0.slug = '6gsfNHvd0iA' AND t0.website_id = 1 AND t0.media IN ('YOUTUBE') LIMIT 1;

SELECT
  t0.mark AS mark_1,
  t0.review AS review_2,
  t0.creation_date AS creation_date_3,
  t0.update_date AS update_date_4,
  t0.video_id AS video_id_5,
  t0.reviewer_id AS reviewer_id_6
FROM
  video_review t0
WHERE
  t0.video_id = ?
ORDER BY
  t0.creation_date DESC

SELECT t0.mark AS mark_1, t0.review AS review_2, t0.creation_date AS creation_date_3, t0.update_date AS update_date_4, t0.video_id AS video_id_5, t0.reviewer_id AS reviewer_id_6 FROM video_review t0 WHERE t0.video_id = 9869 ORDER BY t0.creation_date DESC;