Query Metrics
21
Database Queries
15
Different statements
396.31 ms
Query time
2
Invalid entities
159
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.65 ms (35.74%) |
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.lang = ? AND t0.displayed = ? AND t0.website_id = ? AND t0.media IN ('YOUTUBE') ORDER BY t0.publish_date DESC LIMIT 10
Parameters:
[ "FR" 1 1 ]
|
||||||||||||||||||||||||||||
|
95.33 ms (24.05%) |
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
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
69.59 ms (17.56%) |
1 |
SELECT t0.id AS id_1, t0.uniqid AS uniqid_2, t0.name AS name_3, t0.private AS private_4, t0.invalid AS invalid_5, t0.starter AS starter_6, t0.dev_team AS dev_team_7, t0.meta AS meta_8, t0.total_price AS total_price_9, t0.untap_click_count AS untap_click_count_10, t0.creation_date AS creation_date_11, t0.update_date AS update_date_12, t0.view_count AS view_count_13, t0.like_count AS like_count_14, t0.deleted AS deleted_15, t0.leader_id AS leader_id_16, t17.id AS id_18, t17.number AS number_19, t17.serial_number AS serial_number_20, t17.front_name AS front_name_21, t17.front_description AS front_description_22, t17.front_energy_cost AS front_energy_cost_23, t17.secondary_cost AS secondary_cost_24, t17.front_energy_cost_alias AS front_energy_cost_alias_25, t17.front_energy_color_cost AS front_energy_color_cost_26, t17.back_energy_color_cost AS back_energy_color_cost_27, t17.front_combo_cost AS front_combo_cost_28, t17.front_combo_power AS front_combo_power_29, t17.front_power AS front_power_30, t17.front_defense AS front_defense_31, t17.back_name AS back_name_32, t17.back_description AS back_description_33, t17.back_power AS back_power_34, t17.back_power2 AS back_power2_35, t17.back_defense AS back_defense_36, t17.back_defense2 AS back_defense2_37, t17.img_ready AS img_ready_38, t17.image_ready AS image_ready_39, t17.multicolor AS multicolor_40, t17.limited AS limited_41, t17.banned AS banned_42, t17.unlimited_in_deck AS unlimited_in_deck_43, t17.limitation_in_deck AS limitation_in_deck_44, t17.reprint AS reprint_45, t17.foil AS foil_46, t17.reprint_category AS reprint_category_47, t17.animated AS animated_48, t17.version_number AS version_number_49, t17.front_name_alias AS front_name_alias_50, t17.front_name_en AS front_name_en_51, t17.back_name_en AS back_name_en_52, t17.front_description_en AS front_description_en_53, t17.back_description_en AS back_description_en_54, t17.english_only AS english_only_55, t17.redirect_english_slug AS redirect_english_slug_56, t17.position_serie_list AS position_serie_list_57, t17.lore AS lore_58, t17.subname AS subname_59, t17.illustrator AS illustrator_60, t17.energyzable AS energyzable_61, t17.weakness AS weakness_62, t17.resistance AS resistance_63, t17.sub_description AS sub_description_64, t17.exclusive AS exclusive_65, t17.end_of_serie AS end_of_serie_66, t17.verso AS verso_67, t17.additional_data AS additional_data_68, t17.ocr_keywords_count AS ocr_keywords_count_69, t17.beta AS beta_70, t17.level AS level_71, t17.price_alert AS price_alert_72, t17.creation_date AS creation_date_73, t17.update_date AS update_date_74, t17.displayed AS displayed_75, t17.slug AS slug_76, t17.slug_en AS slug_en_77, t17.view_count AS view_count_78, t17.cmid AS cmid_79, t17.url AS url_80, t17.image AS image_81, t17.current_price AS current_price_82, t17.yesterday_price AS yesterday_price_83, t17.last_price_update AS last_price_update_84, t17.cardnexus_id AS cardnexus_id_85, t17.cardnexus_current_price AS cardnexus_current_price_86, t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87, t17.cardnexus_last_price_update AS cardnexus_last_price_update_88, t17.lang AS lang_89, t17.release_date AS release_date_90, t17.complete AS complete_91, t17.bandai_tcgid AS bandai_tcgid_92, t17.checked AS checked_93, t17.indexable AS indexable_94, t17.front_era_id AS front_era_id_95, t17.back_era_id AS back_era_id_96, t17.type_id AS type_id_97, t17.serie_id AS serie_id_98, t17.rarity_id AS rarity_id_99, t17.group_version_id AS group_version_id_100, t17.avatar_id AS avatar_id_101, t17.version_id AS version_id_102, t17.auto_play_id AS auto_play_id_103, t17.version_annotation_id AS version_annotation_id_104, t17.website_id AS website_id_105, t0.creator_id AS creator_id_106, t0.event_id AS event_id_107, t0.website_id AS website_id_108 FROM deck t0 INNER JOIN card t17 ON t0.leader_id = t17.id WHERE t0.private = ? AND t0.website_id = ? ORDER BY t0.creation_date DESC LIMIT 10
Parameters:
[ 0 1 ]
|
||||||||||||||||||||||||||||
|
54.49 ms (13.75%) |
1 |
SELECT t0.id AS id_1, t0.number AS number_2, t0.serial_number AS serial_number_3, t0.front_name AS front_name_4, t0.front_description AS front_description_5, t0.front_energy_cost AS front_energy_cost_6, t0.secondary_cost AS secondary_cost_7, t0.front_energy_cost_alias AS front_energy_cost_alias_8, t0.front_energy_color_cost AS front_energy_color_cost_9, t0.back_energy_color_cost AS back_energy_color_cost_10, t0.front_combo_cost AS front_combo_cost_11, t0.front_combo_power AS front_combo_power_12, t0.front_power AS front_power_13, t0.front_defense AS front_defense_14, t0.back_name AS back_name_15, t0.back_description AS back_description_16, t0.back_power AS back_power_17, t0.back_power2 AS back_power2_18, t0.back_defense AS back_defense_19, t0.back_defense2 AS back_defense2_20, t0.img_ready AS img_ready_21, t0.image_ready AS image_ready_22, t0.multicolor AS multicolor_23, t0.limited AS limited_24, t0.banned AS banned_25, t0.unlimited_in_deck AS unlimited_in_deck_26, t0.limitation_in_deck AS limitation_in_deck_27, t0.reprint AS reprint_28, t0.foil AS foil_29, t0.reprint_category AS reprint_category_30, t0.animated AS animated_31, t0.version_number AS version_number_32, t0.front_name_alias AS front_name_alias_33, t0.front_name_en AS front_name_en_34, t0.back_name_en AS back_name_en_35, t0.front_description_en AS front_description_en_36, t0.back_description_en AS back_description_en_37, t0.english_only AS english_only_38, t0.redirect_english_slug AS redirect_english_slug_39, t0.position_serie_list AS position_serie_list_40, t0.lore AS lore_41, t0.subname AS subname_42, t0.illustrator AS illustrator_43, t0.energyzable AS energyzable_44, t0.weakness AS weakness_45, t0.resistance AS resistance_46, t0.sub_description AS sub_description_47, t0.exclusive AS exclusive_48, t0.end_of_serie AS end_of_serie_49, t0.verso AS verso_50, t0.additional_data AS additional_data_51, t0.ocr_keywords_count AS ocr_keywords_count_52, t0.beta AS beta_53, t0.level AS level_54, t0.price_alert AS price_alert_55, t0.creation_date AS creation_date_56, t0.update_date AS update_date_57, t0.displayed AS displayed_58, t0.slug AS slug_59, t0.slug_en AS slug_en_60, t0.view_count AS view_count_61, t0.cmid AS cmid_62, t0.url AS url_63, t0.image AS image_64, t0.current_price AS current_price_65, t0.yesterday_price AS yesterday_price_66, t0.last_price_update AS last_price_update_67, t0.cardnexus_id AS cardnexus_id_68, t0.cardnexus_current_price AS cardnexus_current_price_69, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_70, t0.cardnexus_last_price_update AS cardnexus_last_price_update_71, t0.lang AS lang_72, t0.release_date AS release_date_73, t0.complete AS complete_74, t0.bandai_tcgid AS bandai_tcgid_75, t0.checked AS checked_76, t0.indexable AS indexable_77, t0.front_era_id AS front_era_id_78, t0.back_era_id AS back_era_id_79, t0.type_id AS type_id_80, t0.serie_id AS serie_id_81, t0.rarity_id AS rarity_id_82, t0.group_version_id AS group_version_id_83, t0.avatar_id AS avatar_id_84, t0.version_id AS version_id_85, t0.auto_play_id AS auto_play_id_86, t0.version_annotation_id AS version_annotation_id_87, t0.website_id AS website_id_88 FROM card t0 WHERE t0.lang = ? AND t0.displayed = ? AND t0.website_id = ? ORDER BY t0.release_date DESC LIMIT 20
Parameters:
[ "FR" 1 1 ]
|
||||||||||||||||||||||||||||
|
11.96 ms (3.02%) |
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.lang = ? AND t0.displayed = ? AND t0.website_id = ? ORDER BY t0.release_date DESC LIMIT 20
Parameters:
[ "FR" 1 1 ]
|
||||||||||||||||||||||||||||
|
10.88 ms (2.75%) |
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 s0_.slug IS NOT NULL AND EXISTS (SELECT 1 FROM shop_web_site s1_ WHERE s1_.shop_id = s0_.id AND s1_.web_site_id IN (?)) ORDER BY s0_.update_date DESC LIMIT 10
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
3.82 ms (0.96%) |
3 |
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 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')
Parameters:
[
1623
]
|
||||||||||||||||||||||||||||
|
2.05 ms (0.52%) |
1 |
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.total_price AS total_price_6, t0.list_ready AS list_ready_7, t0.timeline_excluded AS timeline_excluded_8, t0.creation_date AS creation_date_9, t0.update_date AS update_date_10, t0.displayed AS displayed_11, t0.slug AS slug_12, t0.slug_en AS slug_en_13, t0.lang AS lang_14, t0.release_date AS release_date_15, t0.cmid AS cmid_16, t0.url AS url_17, t0.image AS image_18, t0.current_price AS current_price_19, t0.yesterday_price AS yesterday_price_20, t0.last_price_update AS last_price_update_21, t0.cardnexus_id AS cardnexus_id_22, t0.cardnexus_current_price AS cardnexus_current_price_23, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_24, t0.cardnexus_last_price_update AS cardnexus_last_price_update_25, t0.type_id AS type_id_26, t0.website_id AS website_id_27 FROM serie t0 WHERE t0.lang = ? AND t0.displayed = ? AND t0.website_id = ? ORDER BY t0.release_date DESC LIMIT 20
Parameters:
[ "FR" 1 1 ]
|
||||||||||||||||||||||||||||
|
1.58 ms (0.40%) |
3 |
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')
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
1.54 ms (0.39%) |
3 |
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 = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||
|
0.93 ms (0.23%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.content AS content_4, t0.creation_date AS creation_date_5, t0.update_date AS update_date_6, t0.displayed AS displayed_7, t0.slug AS slug_8, t0.slug_en AS slug_en_9, t0.view_count AS view_count_10, t0.like_count AS like_count_11, t0.website_id AS website_id_12 FROM article t0 WHERE t0.displayed = ? AND t0.website_id = ? ORDER BY t0.creation_date DESC LIMIT 10
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||||
|
0.88 ms (0.22%) |
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
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.63 ms (0.16%) |
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 = ? LIMIT 1
Parameters:
[
"dbscards"
]
|
||||||||||||||||||||||||||||
|
0.55 ms (0.14%) |
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 = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.43 ms (0.11%) |
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 WHERE t0.id = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Card | 31 |
| App\Entity\Serie | 27 |
| App\Entity\Product\Product | 20 |
| App\Entity\Deck | 10 |
| App\Entity\Shop\Shop | 10 |
| App\Entity\Video\Video | 10 |
| App\Entity\Rarity | 8 |
| App\Entity\GroupVersion | 8 |
| App\Entity\Era | 6 |
| App\Entity\Serie\SerieType | 5 |
| App\Entity\Avatar\Avatar | 4 |
| App\Entity\CardType | 3 |
| App\Entity\User | 3 |
| App\Entity\Product\ProductCategory | 3 |
| App\Entity\Video\VideoSource | 3 |
| App\Entity\Language | 2 |
| App\Entity\Map\Country | 2 |
| App\Entity\WebSite | 1 |
| App\Entity\Settings\FormFilter | 1 |
| App\Entity\Deckbuilder\Deckbuilder | 1 |
| App\Entity\Deckbuilder\DeckArea | 1 |