Symfony Profiler

Query Metrics

339 Database Queries

37 Different statements

93.26 ms Query time

2 Invalid entities

522 Managed entities

Grouped Statements

Time▼	Count	Info
28.16 ms (30.20%)	1	SELECT COUNT() AS dctrn_count FROM (SELECT (CASE WHEN s0_.latest_release_date IS NULL THEN 1 ELSE 0 END) AS sclr_0, (CASE WHEN s0_.product_type_id = 1 THEN CASE WHEN s1_.discount_percent IS NOT NULL AND s2_.start_date < '2026-02-25 02:43:05' AND s2_.end_date > '2026-02-25 02:43:05' THEN s1_.discount_percent ELSE 0 END ELSE CASE WHEN s3_.discount_percent IS NOT NULL THEN s3_.discount_percent ELSE 0 END END) AS sclr_1, s0_.id AS id_2, s0_.name AS name_3, s0_.introduction AS introduction_4, s0_.old_game_id AS old_game_id_5, s0_.slug AS slug_6, s0_.earliest_release_date AS earliest_release_date_7, s0_.latest_release_date AS latest_release_date_8, s0_.smallest_price AS smallest_price_9, s0_.old_game_url AS old_game_url_10, s0_.is_release_date_visible AS is_release_date_visible_11, s0_.google_conversion_code AS google_conversion_code_12, s4_.id AS id_13, s4_.portrait_image_name AS portrait_image_name_14, s4_.landscape_image_name AS landscape_image_name_15, s4_.logo_image_name AS logo_image_name_16, s4_.icon_image_name AS icon_image_name_17, s4_.landscape_image_name_external AS landscape_image_name_external_18 FROM slith_product s0_ INNER JOIN slith_productart s4_ ON s0_.id = s4_.product_id INNER JOIN slith_product_website s6_ ON s0_.id = s6_.slith_product_id INNER JOIN slith_website s5_ ON s5_.id = s6_.slith_website_id LEFT JOIN slith_product_platform s8_ ON s0_.id = s8_.slith_product_id LEFT JOIN slith_platform s7_ ON s7_.id = s8_.slith_platform_id LEFT JOIN slith_product_genre s10_ ON s0_.id = s10_.slith_product_id LEFT JOIN slith_genre s9_ ON s9_.id = s10_.slith_genre_id LEFT JOIN slith_product_timeline s12_ ON s0_.id = s12_.slith_product_id LEFT JOIN slith_timeline s11_ ON s11_.id = s12_.slith_timeline_id LEFT JOIN slith_product_playstyle s14_ ON s0_.id = s14_.slith_product_id LEFT JOIN slith_playstyle s13_ ON s13_.id = s14_.slith_playstyle_id LEFT JOIN slith_product_developer s16_ ON s0_.id = s16_.slith_product_id LEFT JOIN slith_developer s15_ ON s15_.id = s16_.slith_developer_id LEFT JOIN slith_productbundle s3_ ON s0_.id = s3_.product_id LEFT JOIN slith_gamecontract s17_ ON s0_.id = s17_.product_id LEFT JOIN slith_discountcontract s1_ ON s17_.id = s1_.game_contract_id LEFT JOIN slith_discount s2_ ON s1_.discount_id = s2_.id LEFT JOIN slith_productgame s18_ ON s0_.id = s18_.product_id WHERE s5_.slug = ? AND s0_.status_id IN (?) AND ((s0_.smallest_price IS NOT NULL AND s0_.smallest_price <= ?)) AND (s18_.life_cycle_id NOT IN (?, ?) OR s18_.life_cycle_id IS NULL) GROUP BY s0_.id, s0_.name, s0_.introduction, s0_.old_game_id, s0_.slug, s0_.earliest_release_date, s0_.latest_release_date, s0_.smallest_price, s0_.old_game_url, s0_.is_release_date_visible, s0_.google_conversion_code, s0_.status_id, s0_.family_id, s0_.product_type_id, s0_.otrsqueue_id, s0_.product_game_serial_pool_id, s4_.id, s4_.portrait_image_name, s4_.landscape_image_name, s4_.logo_image_name, s4_.icon_image_name, s4_.landscape_image_name_external, s4_.product_id, sclr_0 ORDER BY sclr_0 DESC, s0_.latest_release_date DESC) dctrn_table Parameters: [`"slitherine" 2 20 2 4`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT ( CASE WHEN s0_.latest_release_date IS NULL THEN 1 ELSE 0 END ) AS sclr_0, ( CASE WHEN s0_.product_type_id = 1 THEN CASE WHEN s1_.discount_percent IS NOT NULL AND s2_.start_date < '2026-02-25 02:43:05' AND s2_.end_date > '2026-02-25 02:43:05' THEN s1_.discount_percent ELSE 0 END ELSE CASE WHEN s3_.discount_percent IS NOT NULL THEN s3_.discount_percent ELSE 0 END END ) AS sclr_1, s0_.id AS id_2, s0_.name AS name_3, s0_.introduction AS introduction_4, s0_.old_game_id AS old_game_id_5, s0_.slug AS slug_6, s0_.earliest_release_date AS earliest_release_date_7, s0_.latest_release_date AS latest_release_date_8, s0_.smallest_price AS smallest_price_9, s0_.old_game_url AS old_game_url_10, s0_.is_release_date_visible AS is_release_date_visible_11, s0_.google_conversion_code AS google_conversion_code_12, s4_.id AS id_13, s4_.portrait_image_name AS portrait_image_name_14, s4_.landscape_image_name AS landscape_image_name_15, s4_.logo_image_name AS logo_image_name_16, s4_.icon_image_name AS icon_image_name_17, s4_.landscape_image_name_external AS landscape_image_name_external_18 FROM slith_product s0_ INNER JOIN slith_productart s4_ ON s0_.id = s4_.product_id INNER JOIN slith_product_website s6_ ON s0_.id = s6_.slith_product_id INNER JOIN slith_website s5_ ON s5_.id = s6_.slith_website_id LEFT JOIN slith_product_platform s8_ ON s0_.id = s8_.slith_product_id LEFT JOIN slith_platform s7_ ON s7_.id = s8_.slith_platform_id LEFT JOIN slith_product_genre s10_ ON s0_.id = s10_.slith_product_id LEFT JOIN slith_genre s9_ ON s9_.id = s10_.slith_genre_id LEFT JOIN slith_product_timeline s12_ ON s0_.id = s12_.slith_product_id LEFT JOIN slith_timeline s11_ ON s11_.id = s12_.slith_timeline_id LEFT JOIN slith_product_playstyle s14_ ON s0_.id = s14_.slith_product_id LEFT JOIN slith_playstyle s13_ ON s13_.id = s14_.slith_playstyle_id LEFT JOIN slith_product_developer s16_ ON s0_.id = s16_.slith_product_id LEFT JOIN slith_developer s15_ ON s15_.id = s16_.slith_developer_id LEFT JOIN slith_productbundle s3_ ON s0_.id = s3_.product_id LEFT JOIN slith_gamecontract s17_ ON s0_.id = s17_.product_id LEFT JOIN slith_discountcontract s1_ ON s17_.id = s1_.game_contract_id LEFT JOIN slith_discount s2_ ON s1_.discount_id = s2_.id LEFT JOIN slith_productgame s18_ ON s0_.id = s18_.product_id WHERE s5_.slug = ? AND s0_.status_id IN (?) AND ( ( s0_.smallest_price IS NOT NULL AND s0_.smallest_price <= ? ) ) AND ( s18_.life_cycle_id NOT IN (?, ?) OR s18_.life_cycle_id IS NULL ) GROUP BY s0_.id, s0_.name, s0_.introduction, s0_.old_game_id, s0_.slug, s0_.earliest_release_date, s0_.latest_release_date, s0_.smallest_price, s0_.old_game_url, s0_.is_release_date_visible, s0_.google_conversion_code, s0_.status_id, s0_.family_id, s0_.product_type_id, s0_.otrsqueue_id, s0_.product_game_serial_pool_id, s4_.id, s4_.portrait_image_name, s4_.landscape_image_name, s4_.logo_image_name, s4_.icon_image_name, s4_.landscape_image_name_external, s4_.product_id, sclr_0 ORDER BY sclr_0 DESC, s0_.latest_release_date DESC ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT (CASE WHEN s0_.latest_release_date IS NULL THEN 1 ELSE 0 END) AS sclr_0, (CASE WHEN s0_.product_type_id = 1 THEN CASE WHEN s1_.discount_percent IS NOT NULL AND s2_.start_date < '2026-02-25 02'slitherine'2' AND s2_.end_date > '2026-02-25 02202' THEN s1_.discount_percent ELSE 0 END ELSE CASE WHEN s3_.discount_percent IS NOT NULL THEN s3_.discount_percent ELSE 0 END END) AS sclr_1, s0_.id AS id_2, s0_.name AS name_3, s0_.introduction AS introduction_4, s0_.old_game_id AS old_game_id_5, s0_.slug AS slug_6, s0_.earliest_release_date AS earliest_release_date_7, s0_.latest_release_date AS latest_release_date_8, s0_.smallest_price AS smallest_price_9, s0_.old_game_url AS old_game_url_10, s0_.is_release_date_visible AS is_release_date_visible_11, s0_.google_conversion_code AS google_conversion_code_12, s4_.id AS id_13, s4_.portrait_image_name AS portrait_image_name_14, s4_.landscape_image_name AS landscape_image_name_15, s4_.logo_image_name AS logo_image_name_16, s4_.icon_image_name AS icon_image_name_17, s4_.landscape_image_name_external AS landscape_image_name_external_18 FROM slith_product s0_ INNER JOIN slith_productart s4_ ON s0_.id = s4_.product_id INNER JOIN slith_product_website s6_ ON s0_.id = s6_.slith_product_id INNER JOIN slith_website s5_ ON s5_.id = s6_.slith_website_id LEFT JOIN slith_product_platform s8_ ON s0_.id = s8_.slith_product_id LEFT JOIN slith_platform s7_ ON s7_.id = s8_.slith_platform_id LEFT JOIN slith_product_genre s10_ ON s0_.id = s10_.slith_product_id LEFT JOIN slith_genre s9_ ON s9_.id = s10_.slith_genre_id LEFT JOIN slith_product_timeline s12_ ON s0_.id = s12_.slith_product_id LEFT JOIN slith_timeline s11_ ON s11_.id = s12_.slith_timeline_id LEFT JOIN slith_product_playstyle s14_ ON s0_.id = s14_.slith_product_id LEFT JOIN slith_playstyle s13_ ON s13_.id = s14_.slith_playstyle_id LEFT JOIN slith_product_developer s16_ ON s0_.id = s16_.slith_product_id LEFT JOIN slith_developer s15_ ON s15_.id = s16_.slith_developer_id LEFT JOIN slith_productbundle s3_ ON s0_.id = s3_.product_id LEFT JOIN slith_gamecontract s17_ ON s0_.id = s17_.product_id LEFT JOIN slith_discountcontract s1_ ON s17_.id = s1_.game_contract_id LEFT JOIN slith_discount s2_ ON s1_.discount_id = s2_.id LEFT JOIN slith_productgame s18_ ON s0_.id = s18_.product_id WHERE s5_.slug = 4 AND s0_.status_id IN (?) AND ((s0_.smallest_price IS NOT NULL AND s0_.smallest_price <= ?)) AND (s18_.life_cycle_id NOT IN (?, ?) OR s18_.life_cycle_id IS NULL) GROUP BY s0_.id, s0_.name, s0_.introduction, s0_.old_game_id, s0_.slug, s0_.earliest_release_date, s0_.latest_release_date, s0_.smallest_price, s0_.old_game_url, s0_.is_release_date_visible, s0_.google_conversion_code, s0_.status_id, s0_.family_id, s0_.product_type_id, s0_.otrsqueue_id, s0_.product_game_serial_pool_id, s4_.id, s4_.portrait_image_name, s4_.landscape_image_name, s4_.logo_image_name, s4_.icon_image_name, s4_.landscape_image_name_external, s4_.product_id, sclr_0 ORDER BY sclr_0 DESC, s0_.latest_release_date DESC) dctrn_table;
27.27 ms (29.24%)	1	SELECT (CASE WHEN s0_.latest_release_date IS NULL THEN 1 ELSE 0 END) AS sclr_0, (CASE WHEN s0_.product_type_id = 1 THEN CASE WHEN s1_.discount_percent IS NOT NULL AND s2_.start_date < '2026-02-25 02:43:05' AND s2_.end_date > '2026-02-25 02:43:05' THEN s1_.discount_percent ELSE 0 END ELSE CASE WHEN s3_.discount_percent IS NOT NULL THEN s3_.discount_percent ELSE 0 END END) AS sclr_1, s0_.id AS id_2, s0_.name AS name_3, s0_.introduction AS introduction_4, s0_.old_game_id AS old_game_id_5, s0_.slug AS slug_6, s0_.earliest_release_date AS earliest_release_date_7, s0_.latest_release_date AS latest_release_date_8, s0_.smallest_price AS smallest_price_9, s0_.old_game_url AS old_game_url_10, s0_.is_release_date_visible AS is_release_date_visible_11, s0_.google_conversion_code AS google_conversion_code_12, s4_.id AS id_13, s4_.portrait_image_name AS portrait_image_name_14, s4_.landscape_image_name AS landscape_image_name_15, s4_.logo_image_name AS logo_image_name_16, s4_.icon_image_name AS icon_image_name_17, s4_.landscape_image_name_external AS landscape_image_name_external_18, s0_.status_id AS status_id_19, s0_.family_id AS family_id_20, s0_.product_type_id AS product_type_id_21, s0_.otrsqueue_id AS otrsqueue_id_22, s0_.product_game_serial_pool_id AS product_game_serial_pool_id_23, s4_.product_id AS product_id_24 FROM slith_product s0_ INNER JOIN slith_productart s4_ ON s0_.id = s4_.product_id INNER JOIN slith_product_website s6_ ON s0_.id = s6_.slith_product_id INNER JOIN slith_website s5_ ON s5_.id = s6_.slith_website_id LEFT JOIN slith_product_platform s8_ ON s0_.id = s8_.slith_product_id LEFT JOIN slith_platform s7_ ON s7_.id = s8_.slith_platform_id LEFT JOIN slith_product_genre s10_ ON s0_.id = s10_.slith_product_id LEFT JOIN slith_genre s9_ ON s9_.id = s10_.slith_genre_id LEFT JOIN slith_product_timeline s12_ ON s0_.id = s12_.slith_product_id LEFT JOIN slith_timeline s11_ ON s11_.id = s12_.slith_timeline_id LEFT JOIN slith_product_playstyle s14_ ON s0_.id = s14_.slith_product_id LEFT JOIN slith_playstyle s13_ ON s13_.id = s14_.slith_playstyle_id LEFT JOIN slith_product_developer s16_ ON s0_.id = s16_.slith_product_id LEFT JOIN slith_developer s15_ ON s15_.id = s16_.slith_developer_id LEFT JOIN slith_productbundle s3_ ON s0_.id = s3_.product_id LEFT JOIN slith_gamecontract s17_ ON s0_.id = s17_.product_id LEFT JOIN slith_discountcontract s1_ ON s17_.id = s1_.game_contract_id LEFT JOIN slith_discount s2_ ON s1_.discount_id = s2_.id LEFT JOIN slith_productgame s18_ ON s0_.id = s18_.product_id WHERE s5_.slug = ? AND s0_.status_id IN (?) AND ((s0_.smallest_price IS NOT NULL AND s0_.smallest_price <= ?)) AND (s18_.life_cycle_id NOT IN (?, ?) OR s18_.life_cycle_id IS NULL) GROUP BY s0_.id, s0_.name, s0_.introduction, s0_.old_game_id, s0_.slug, s0_.earliest_release_date, s0_.latest_release_date, s0_.smallest_price, s0_.old_game_url, s0_.is_release_date_visible, s0_.google_conversion_code, s0_.status_id, s0_.family_id, s0_.product_type_id, s0_.otrsqueue_id, s0_.product_game_serial_pool_id, s4_.id, s4_.portrait_image_name, s4_.landscape_image_name, s4_.logo_image_name, s4_.icon_image_name, s4_.landscape_image_name_external, s4_.product_id, sclr_0 ORDER BY sclr_0 DESC, s0_.latest_release_date DESC LIMIT 21 Parameters: [`"slitherine" 2 20 2 4`] View formatted query View runnable query Explain query SELECT ( CASE WHEN s0_.latest_release_date IS NULL THEN 1 ELSE 0 END ) AS sclr_0, ( CASE WHEN s0_.product_type_id = 1 THEN CASE WHEN s1_.discount_percent IS NOT NULL AND s2_.start_date < '2026-02-25 02:43:05' AND s2_.end_date > '2026-02-25 02:43:05' THEN s1_.discount_percent ELSE 0 END ELSE CASE WHEN s3_.discount_percent IS NOT NULL THEN s3_.discount_percent ELSE 0 END END ) AS sclr_1, s0_.id AS id_2, s0_.name AS name_3, s0_.introduction AS introduction_4, s0_.old_game_id AS old_game_id_5, s0_.slug AS slug_6, s0_.earliest_release_date AS earliest_release_date_7, s0_.latest_release_date AS latest_release_date_8, s0_.smallest_price AS smallest_price_9, s0_.old_game_url AS old_game_url_10, s0_.is_release_date_visible AS is_release_date_visible_11, s0_.google_conversion_code AS google_conversion_code_12, s4_.id AS id_13, s4_.portrait_image_name AS portrait_image_name_14, s4_.landscape_image_name AS landscape_image_name_15, s4_.logo_image_name AS logo_image_name_16, s4_.icon_image_name AS icon_image_name_17, s4_.landscape_image_name_external AS landscape_image_name_external_18, s0_.status_id AS status_id_19, s0_.family_id AS family_id_20, s0_.product_type_id AS product_type_id_21, s0_.otrsqueue_id AS otrsqueue_id_22, s0_.product_game_serial_pool_id AS product_game_serial_pool_id_23, s4_.product_id AS product_id_24 FROM slith_product s0_ INNER JOIN slith_productart s4_ ON s0_.id = s4_.product_id INNER JOIN slith_product_website s6_ ON s0_.id = s6_.slith_product_id INNER JOIN slith_website s5_ ON s5_.id = s6_.slith_website_id LEFT JOIN slith_product_platform s8_ ON s0_.id = s8_.slith_product_id LEFT JOIN slith_platform s7_ ON s7_.id = s8_.slith_platform_id LEFT JOIN slith_product_genre s10_ ON s0_.id = s10_.slith_product_id LEFT JOIN slith_genre s9_ ON s9_.id = s10_.slith_genre_id LEFT JOIN slith_product_timeline s12_ ON s0_.id = s12_.slith_product_id LEFT JOIN slith_timeline s11_ ON s11_.id = s12_.slith_timeline_id LEFT JOIN slith_product_playstyle s14_ ON s0_.id = s14_.slith_product_id LEFT JOIN slith_playstyle s13_ ON s13_.id = s14_.slith_playstyle_id LEFT JOIN slith_product_developer s16_ ON s0_.id = s16_.slith_product_id LEFT JOIN slith_developer s15_ ON s15_.id = s16_.slith_developer_id LEFT JOIN slith_productbundle s3_ ON s0_.id = s3_.product_id LEFT JOIN slith_gamecontract s17_ ON s0_.id = s17_.product_id LEFT JOIN slith_discountcontract s1_ ON s17_.id = s1_.game_contract_id LEFT JOIN slith_discount s2_ ON s1_.discount_id = s2_.id LEFT JOIN slith_productgame s18_ ON s0_.id = s18_.product_id WHERE s5_.slug = ? AND s0_.status_id IN (?) AND ( ( s0_.smallest_price IS NOT NULL AND s0_.smallest_price <= ? ) ) AND ( s18_.life_cycle_id NOT IN (?, ?) OR s18_.life_cycle_id IS NULL ) GROUP BY s0_.id, s0_.name, s0_.introduction, s0_.old_game_id, s0_.slug, s0_.earliest_release_date, s0_.latest_release_date, s0_.smallest_price, s0_.old_game_url, s0_.is_release_date_visible, s0_.google_conversion_code, s0_.status_id, s0_.family_id, s0_.product_type_id, s0_.otrsqueue_id, s0_.product_game_serial_pool_id, s4_.id, s4_.portrait_image_name, s4_.landscape_image_name, s4_.logo_image_name, s4_.icon_image_name, s4_.landscape_image_name_external, s4_.product_id, sclr_0 ORDER BY sclr_0 DESC, s0_.latest_release_date DESC LIMIT 21 SELECT (CASE WHEN s0_.latest_release_date IS NULL THEN 1 ELSE 0 END) AS sclr_0, (CASE WHEN s0_.product_type_id = 1 THEN CASE WHEN s1_.discount_percent IS NOT NULL AND s2_.start_date < '2026-02-25 02'slitherine'2' AND s2_.end_date > '2026-02-25 02202' THEN s1_.discount_percent ELSE 0 END ELSE CASE WHEN s3_.discount_percent IS NOT NULL THEN s3_.discount_percent ELSE 0 END END) AS sclr_1, s0_.id AS id_2, s0_.name AS name_3, s0_.introduction AS introduction_4, s0_.old_game_id AS old_game_id_5, s0_.slug AS slug_6, s0_.earliest_release_date AS earliest_release_date_7, s0_.latest_release_date AS latest_release_date_8, s0_.smallest_price AS smallest_price_9, s0_.old_game_url AS old_game_url_10, s0_.is_release_date_visible AS is_release_date_visible_11, s0_.google_conversion_code AS google_conversion_code_12, s4_.id AS id_13, s4_.portrait_image_name AS portrait_image_name_14, s4_.landscape_image_name AS landscape_image_name_15, s4_.logo_image_name AS logo_image_name_16, s4_.icon_image_name AS icon_image_name_17, s4_.landscape_image_name_external AS landscape_image_name_external_18, s0_.status_id AS status_id_19, s0_.family_id AS family_id_20, s0_.product_type_id AS product_type_id_21, s0_.otrsqueue_id AS otrsqueue_id_22, s0_.product_game_serial_pool_id AS product_game_serial_pool_id_23, s4_.product_id AS product_id_24 FROM slith_product s0_ INNER JOIN slith_productart s4_ ON s0_.id = s4_.product_id INNER JOIN slith_product_website s6_ ON s0_.id = s6_.slith_product_id INNER JOIN slith_website s5_ ON s5_.id = s6_.slith_website_id LEFT JOIN slith_product_platform s8_ ON s0_.id = s8_.slith_product_id LEFT JOIN slith_platform s7_ ON s7_.id = s8_.slith_platform_id LEFT JOIN slith_product_genre s10_ ON s0_.id = s10_.slith_product_id LEFT JOIN slith_genre s9_ ON s9_.id = s10_.slith_genre_id LEFT JOIN slith_product_timeline s12_ ON s0_.id = s12_.slith_product_id LEFT JOIN slith_timeline s11_ ON s11_.id = s12_.slith_timeline_id LEFT JOIN slith_product_playstyle s14_ ON s0_.id = s14_.slith_product_id LEFT JOIN slith_playstyle s13_ ON s13_.id = s14_.slith_playstyle_id LEFT JOIN slith_product_developer s16_ ON s0_.id = s16_.slith_product_id LEFT JOIN slith_developer s15_ ON s15_.id = s16_.slith_developer_id LEFT JOIN slith_productbundle s3_ ON s0_.id = s3_.product_id LEFT JOIN slith_gamecontract s17_ ON s0_.id = s17_.product_id LEFT JOIN slith_discountcontract s1_ ON s17_.id = s1_.game_contract_id LEFT JOIN slith_discount s2_ ON s1_.discount_id = s2_.id LEFT JOIN slith_productgame s18_ ON s0_.id = s18_.product_id WHERE s5_.slug = 4 AND s0_.status_id IN (?) AND ((s0_.smallest_price IS NOT NULL AND s0_.smallest_price <= ?)) AND (s18_.life_cycle_id NOT IN (?, ?) OR s18_.life_cycle_id IS NULL) GROUP BY s0_.id, s0_.name, s0_.introduction, s0_.old_game_id, s0_.slug, s0_.earliest_release_date, s0_.latest_release_date, s0_.smallest_price, s0_.old_game_url, s0_.is_release_date_visible, s0_.google_conversion_code, s0_.status_id, s0_.family_id, s0_.product_type_id, s0_.otrsqueue_id, s0_.product_game_serial_pool_id, s4_.id, s4_.portrait_image_name, s4_.landscape_image_name, s4_.logo_image_name, s4_.icon_image_name, s4_.landscape_image_name_external, s4_.product_id, sclr_0 ORDER BY sclr_0 DESC, s0_.latest_release_date DESC LIMIT 21;
7.22 ms (7.74%)	21	SELECT t0.id AS id_1, t0.name AS name_2, t0.introduction AS introduction_3, t0.old_game_id AS old_game_id_4, t0.slug AS slug_5, t0.earliest_release_date AS earliest_release_date_6, t0.latest_release_date AS latest_release_date_7, t0.smallest_price AS smallest_price_8, t0.old_game_url AS old_game_url_9, t0.is_release_date_visible AS is_release_date_visible_10, t0.google_conversion_code AS google_conversion_code_11, t12.id AS id_13, t12.description AS description_14, t12.features AS features_15, t12.requirements AS requirements_16, t12.game_data AS game_data_17, t12.discover_more_link AS discover_more_link_18, t12.historical_background AS historical_background_19, t12.lore AS lore_20, t12.product_id AS product_id_21, t22.id AS id_23, t22.discount_percent AS discount_percent_24, t22.product_id AS product_id_25, t26.id AS id_27, t26.min_players AS min_players_28, t26.max_players AS max_players_29, t26.product_id AS product_id_30, t26.genre_id AS genre_id_31, t26.timeline_id AS timeline_id_32, t26.theatre_id AS theatre_id_33, t26.difficulty_id AS difficulty_id_34, t26.play_style_id AS play_style_id_35, t26.artificial_intelligence_id AS artificial_intelligence_id_36, t26.game_editor_id AS game_editor_id_37, t26.turn_scale_id AS turn_scale_id_38, t26.multiplayer_id AS multiplayer_id_39, t26.unit_scale_id AS unit_scale_id_40, t41.id AS id_42, t41.portrait_image_name AS portrait_image_name_43, t41.landscape_image_name AS landscape_image_name_44, t41.logo_image_name AS logo_image_name_45, t41.icon_image_name AS icon_image_name_46, t41.landscape_image_name_external AS landscape_image_name_external_47, t41.product_id AS product_id_48, t0.status_id AS status_id_49, t0.family_id AS family_id_50, t0.product_type_id AS product_type_id_51, t52.id AS id_53, t52.steam_app_id AS steam_app_id_54, t52.external_forum_id AS external_forum_id_55, t52.forum_url AS forum_url_56, t52.is_serial_steam_key AS is_serial_steam_key_57, t52.is_preorder AS is_preorder_58, t52.is_indie AS is_indie_59, t52.gog_slug AS gog_slug_60, t52.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_61, t52.is_release_notification_sent AS is_release_notification_sent_62, t52.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_63, t52.steam_app_api_key AS steam_app_api_key_64, t52.gog_app_id AS gog_app_id_65, t52.gog_app_api_key AS gog_app_api_key_66, t52.discord_url AS discord_url_67, t52.epic_app_id AS epic_app_id_68, t52.epic_slug AS epic_slug_69, t52.epic_app_sandbox_id AS epic_app_sandbox_id_70, t52.training_url AS training_url_71, t52.folder_name AS folder_name_72, t52.has_custom_button AS has_custom_button_73, t52.custom_button_title AS custom_button_title_74, t52.custom_button_link AS custom_button_link_75, t52.product_id AS product_id_76, t52.developer_id AS developer_id_77, t52.life_cycle_id AS life_cycle_id_78, t52.forum_id AS forum_id_79, t80.id AS id_81, t80.name AS name_82, t80.web_apipublisher_key AS web_apipublisher_key_83, t80.background_image_name AS background_image_name_84, t80.leaderboard_title_id AS leaderboard_title_id_85, t80.secret_key AS secret_key_86, t80.product_id AS product_id_87, t80.status_id AS status_id_88, t80.leaderboard_provider_id AS leaderboard_provider_id_89, t0.otrsqueue_id AS otrsqueue_id_90, t91.id AS id_92, t91.is_license_file_revocable AS is_license_file_revocable_93, t91.is_price_calculator_available AS is_price_calculator_available_94, t91.pro_license_encryption_key AS pro_license_encryption_key_95, t91.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_96, t91.pro_license_generation_alert_email AS pro_license_generation_alert_email_97, t91.capabilities AS capabilities_98, t91.product_id AS product_id_99, t0.product_game_serial_pool_id AS product_game_serial_pool_id_100, t101.id AS id_102, t101.description AS description_103, t101.product_id AS product_id_104, t101.belongs_to_product_id AS belongs_to_product_id_105, t101.merchandise_type_id AS merchandise_type_id_106, t107.id AS id_108, t107.name AS name_109, t107.streak_key AS streak_key_110, t107.sort_order_index AS sort_order_index_111, t107.internal_product_id AS internal_product_id_112, t107.streak_field_product_type_id AS streak_field_product_type_id_113 FROM slith_product t0 LEFT JOIN slith_gamecontent t12 ON t12.product_id = t0.id LEFT JOIN slith_productbundle t22 ON t22.product_id = t0.id LEFT JOIN slith_gameoptions t26 ON t26.product_id = t0.id LEFT JOIN slith_productart t41 ON t41.product_id = t0.id LEFT JOIN slith_productgame t52 ON t52.product_id = t0.id LEFT JOIN slith_leaderboard t80 ON t80.product_id = t0.id LEFT JOIN slith_proproduct t91 ON t91.product_id = t0.id LEFT JOIN slith_productmerchandise t101 ON t101.product_id = t0.id LEFT JOIN slith_streakfieldproduct t107 ON t107.internal_product_id = t0.id INNER JOIN slith_productgame_product ON t0.id = slith_productgame_product.slith_product_id WHERE slith_productgame_product.slith_productgame_id = ? Parameters: [`751`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.introduction AS introduction_3, t0.old_game_id AS old_game_id_4, t0.slug AS slug_5, t0.earliest_release_date AS earliest_release_date_6, t0.latest_release_date AS latest_release_date_7, t0.smallest_price AS smallest_price_8, t0.old_game_url AS old_game_url_9, t0.is_release_date_visible AS is_release_date_visible_10, t0.google_conversion_code AS google_conversion_code_11, t12.id AS id_13, t12.description AS description_14, t12.features AS features_15, t12.requirements AS requirements_16, t12.game_data AS game_data_17, t12.discover_more_link AS discover_more_link_18, t12.historical_background AS historical_background_19, t12.lore AS lore_20, t12.product_id AS product_id_21, t22.id AS id_23, t22.discount_percent AS discount_percent_24, t22.product_id AS product_id_25, t26.id AS id_27, t26.min_players AS min_players_28, t26.max_players AS max_players_29, t26.product_id AS product_id_30, t26.genre_id AS genre_id_31, t26.timeline_id AS timeline_id_32, t26.theatre_id AS theatre_id_33, t26.difficulty_id AS difficulty_id_34, t26.play_style_id AS play_style_id_35, t26.artificial_intelligence_id AS artificial_intelligence_id_36, t26.game_editor_id AS game_editor_id_37, t26.turn_scale_id AS turn_scale_id_38, t26.multiplayer_id AS multiplayer_id_39, t26.unit_scale_id AS unit_scale_id_40, t41.id AS id_42, t41.portrait_image_name AS portrait_image_name_43, t41.landscape_image_name AS landscape_image_name_44, t41.logo_image_name AS logo_image_name_45, t41.icon_image_name AS icon_image_name_46, t41.landscape_image_name_external AS landscape_image_name_external_47, t41.product_id AS product_id_48, t0.status_id AS status_id_49, t0.family_id AS family_id_50, t0.product_type_id AS product_type_id_51, t52.id AS id_53, t52.steam_app_id AS steam_app_id_54, t52.external_forum_id AS external_forum_id_55, t52.forum_url AS forum_url_56, t52.is_serial_steam_key AS is_serial_steam_key_57, t52.is_preorder AS is_preorder_58, t52.is_indie AS is_indie_59, t52.gog_slug AS gog_slug_60, t52.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_61, t52.is_release_notification_sent AS is_release_notification_sent_62, t52.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_63, t52.steam_app_api_key AS steam_app_api_key_64, t52.gog_app_id AS gog_app_id_65, t52.gog_app_api_key AS gog_app_api_key_66, t52.discord_url AS discord_url_67, t52.epic_app_id AS epic_app_id_68, t52.epic_slug AS epic_slug_69, t52.epic_app_sandbox_id AS epic_app_sandbox_id_70, t52.training_url AS training_url_71, t52.folder_name AS folder_name_72, t52.has_custom_button AS has_custom_button_73, t52.custom_button_title AS custom_button_title_74, t52.custom_button_link AS custom_button_link_75, t52.product_id AS product_id_76, t52.developer_id AS developer_id_77, t52.life_cycle_id AS life_cycle_id_78, t52.forum_id AS forum_id_79, t80.id AS id_81, t80.name AS name_82, t80.web_apipublisher_key AS web_apipublisher_key_83, t80.background_image_name AS background_image_name_84, t80.leaderboard_title_id AS leaderboard_title_id_85, t80.secret_key AS secret_key_86, t80.product_id AS product_id_87, t80.status_id AS status_id_88, t80.leaderboard_provider_id AS leaderboard_provider_id_89, t0.otrsqueue_id AS otrsqueue_id_90, t91.id AS id_92, t91.is_license_file_revocable AS is_license_file_revocable_93, t91.is_price_calculator_available AS is_price_calculator_available_94, t91.pro_license_encryption_key AS pro_license_encryption_key_95, t91.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_96, t91.pro_license_generation_alert_email AS pro_license_generation_alert_email_97, t91.capabilities AS capabilities_98, t91.product_id AS product_id_99, t0.product_game_serial_pool_id AS product_game_serial_pool_id_100, t101.id AS id_102, t101.description AS description_103, t101.product_id AS product_id_104, t101.belongs_to_product_id AS belongs_to_product_id_105, t101.merchandise_type_id AS merchandise_type_id_106, t107.id AS id_108, t107.name AS name_109, t107.streak_key AS streak_key_110, t107.sort_order_index AS sort_order_index_111, t107.internal_product_id AS internal_product_id_112, t107.streak_field_product_type_id AS streak_field_product_type_id_113 FROM slith_product t0 LEFT JOIN slith_gamecontent t12 ON t12.product_id = t0.id LEFT JOIN slith_productbundle t22 ON t22.product_id = t0.id LEFT JOIN slith_gameoptions t26 ON t26.product_id = t0.id LEFT JOIN slith_productart t41 ON t41.product_id = t0.id LEFT JOIN slith_productgame t52 ON t52.product_id = t0.id LEFT JOIN slith_leaderboard t80 ON t80.product_id = t0.id LEFT JOIN slith_proproduct t91 ON t91.product_id = t0.id LEFT JOIN slith_productmerchandise t101 ON t101.product_id = t0.id LEFT JOIN slith_streakfieldproduct t107 ON t107.internal_product_id = t0.id INNER JOIN slith_productgame_product ON t0.id = slith_productgame_product.slith_product_id WHERE slith_productgame_product.slith_productgame_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.introduction AS introduction_3, t0.old_game_id AS old_game_id_4, t0.slug AS slug_5, t0.earliest_release_date AS earliest_release_date_6, t0.latest_release_date AS latest_release_date_7, t0.smallest_price AS smallest_price_8, t0.old_game_url AS old_game_url_9, t0.is_release_date_visible AS is_release_date_visible_10, t0.google_conversion_code AS google_conversion_code_11, t12.id AS id_13, t12.description AS description_14, t12.features AS features_15, t12.requirements AS requirements_16, t12.game_data AS game_data_17, t12.discover_more_link AS discover_more_link_18, t12.historical_background AS historical_background_19, t12.lore AS lore_20, t12.product_id AS product_id_21, t22.id AS id_23, t22.discount_percent AS discount_percent_24, t22.product_id AS product_id_25, t26.id AS id_27, t26.min_players AS min_players_28, t26.max_players AS max_players_29, t26.product_id AS product_id_30, t26.genre_id AS genre_id_31, t26.timeline_id AS timeline_id_32, t26.theatre_id AS theatre_id_33, t26.difficulty_id AS difficulty_id_34, t26.play_style_id AS play_style_id_35, t26.artificial_intelligence_id AS artificial_intelligence_id_36, t26.game_editor_id AS game_editor_id_37, t26.turn_scale_id AS turn_scale_id_38, t26.multiplayer_id AS multiplayer_id_39, t26.unit_scale_id AS unit_scale_id_40, t41.id AS id_42, t41.portrait_image_name AS portrait_image_name_43, t41.landscape_image_name AS landscape_image_name_44, t41.logo_image_name AS logo_image_name_45, t41.icon_image_name AS icon_image_name_46, t41.landscape_image_name_external AS landscape_image_name_external_47, t41.product_id AS product_id_48, t0.status_id AS status_id_49, t0.family_id AS family_id_50, t0.product_type_id AS product_type_id_51, t52.id AS id_53, t52.steam_app_id AS steam_app_id_54, t52.external_forum_id AS external_forum_id_55, t52.forum_url AS forum_url_56, t52.is_serial_steam_key AS is_serial_steam_key_57, t52.is_preorder AS is_preorder_58, t52.is_indie AS is_indie_59, t52.gog_slug AS gog_slug_60, t52.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_61, t52.is_release_notification_sent AS is_release_notification_sent_62, t52.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_63, t52.steam_app_api_key AS steam_app_api_key_64, t52.gog_app_id AS gog_app_id_65, t52.gog_app_api_key AS gog_app_api_key_66, t52.discord_url AS discord_url_67, t52.epic_app_id AS epic_app_id_68, t52.epic_slug AS epic_slug_69, t52.epic_app_sandbox_id AS epic_app_sandbox_id_70, t52.training_url AS training_url_71, t52.folder_name AS folder_name_72, t52.has_custom_button AS has_custom_button_73, t52.custom_button_title AS custom_button_title_74, t52.custom_button_link AS custom_button_link_75, t52.product_id AS product_id_76, t52.developer_id AS developer_id_77, t52.life_cycle_id AS life_cycle_id_78, t52.forum_id AS forum_id_79, t80.id AS id_81, t80.name AS name_82, t80.web_apipublisher_key AS web_apipublisher_key_83, t80.background_image_name AS background_image_name_84, t80.leaderboard_title_id AS leaderboard_title_id_85, t80.secret_key AS secret_key_86, t80.product_id AS product_id_87, t80.status_id AS status_id_88, t80.leaderboard_provider_id AS leaderboard_provider_id_89, t0.otrsqueue_id AS otrsqueue_id_90, t91.id AS id_92, t91.is_license_file_revocable AS is_license_file_revocable_93, t91.is_price_calculator_available AS is_price_calculator_available_94, t91.pro_license_encryption_key AS pro_license_encryption_key_95, t91.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_96, t91.pro_license_generation_alert_email AS pro_license_generation_alert_email_97, t91.capabilities AS capabilities_98, t91.product_id AS product_id_99, t0.product_game_serial_pool_id AS product_game_serial_pool_id_100, t101.id AS id_102, t101.description AS description_103, t101.product_id AS product_id_104, t101.belongs_to_product_id AS belongs_to_product_id_105, t101.merchandise_type_id AS merchandise_type_id_106, t107.id AS id_108, t107.name AS name_109, t107.streak_key AS streak_key_110, t107.sort_order_index AS sort_order_index_111, t107.internal_product_id AS internal_product_id_112, t107.streak_field_product_type_id AS streak_field_product_type_id_113 FROM slith_product t0 LEFT JOIN slith_gamecontent t12 ON t12.product_id = t0.id LEFT JOIN slith_productbundle t22 ON t22.product_id = t0.id LEFT JOIN slith_gameoptions t26 ON t26.product_id = t0.id LEFT JOIN slith_productart t41 ON t41.product_id = t0.id LEFT JOIN slith_productgame t52 ON t52.product_id = t0.id LEFT JOIN slith_leaderboard t80 ON t80.product_id = t0.id LEFT JOIN slith_proproduct t91 ON t91.product_id = t0.id LEFT JOIN slith_productmerchandise t101 ON t101.product_id = t0.id LEFT JOIN slith_streakfieldproduct t107 ON t107.internal_product_id = t0.id INNER JOIN slith_productgame_product ON t0.id = slith_productgame_product.slith_product_id WHERE slith_productgame_product.slith_productgame_id = 751;
3.62 ms (3.88%)	34	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.valid_from_time AS valid_from_time_4, t0.valid_until_time AS valid_until_time_5, t0.discount_percent AS discount_percent_6, t0.is_auto_add_to_shopping_cart AS is_auto_add_to_shopping_cart_7, t0.status_id AS status_id_8 FROM slith_crosssale t0 INNER JOIN slith_crosssale_slave_product ON t0.id = slith_crosssale_slave_product.slith_crosssale_id WHERE slith_crosssale_slave_product.slith_product_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.valid_from_time AS valid_from_time_4, t0.valid_until_time AS valid_until_time_5, t0.discount_percent AS discount_percent_6, t0.is_auto_add_to_shopping_cart AS is_auto_add_to_shopping_cart_7, t0.status_id AS status_id_8 FROM slith_crosssale t0 INNER JOIN slith_crosssale_slave_product ON t0.id = slith_crosssale_slave_product.slith_crosssale_id WHERE slith_crosssale_slave_product.slith_product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.valid_from_time AS valid_from_time_4, t0.valid_until_time AS valid_until_time_5, t0.discount_percent AS discount_percent_6, t0.is_auto_add_to_shopping_cart AS is_auto_add_to_shopping_cart_7, t0.status_id AS status_id_8 FROM slith_crosssale t0 INNER JOIN slith_crosssale_slave_product ON t0.id = slith_crosssale_slave_product.slith_crosssale_id WHERE slith_crosssale_slave_product.slith_product_id = 838;
2.44 ms (2.62%)	22	SELECT t0.id AS id_1, t0.steam_app_id AS steam_app_id_2, t0.external_forum_id AS external_forum_id_3, t0.forum_url AS forum_url_4, t0.is_serial_steam_key AS is_serial_steam_key_5, t0.is_preorder AS is_preorder_6, t0.is_indie AS is_indie_7, t0.gog_slug AS gog_slug_8, t0.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_9, t0.is_release_notification_sent AS is_release_notification_sent_10, t0.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_11, t0.steam_app_api_key AS steam_app_api_key_12, t0.gog_app_id AS gog_app_id_13, t0.gog_app_api_key AS gog_app_api_key_14, t0.discord_url AS discord_url_15, t0.epic_app_id AS epic_app_id_16, t0.epic_slug AS epic_slug_17, t0.epic_app_sandbox_id AS epic_app_sandbox_id_18, t0.training_url AS training_url_19, t0.folder_name AS folder_name_20, t0.has_custom_button AS has_custom_button_21, t0.custom_button_title AS custom_button_title_22, t0.custom_button_link AS custom_button_link_23, t0.product_id AS product_id_24, t0.developer_id AS developer_id_25, t0.life_cycle_id AS life_cycle_id_26, t0.forum_id AS forum_id_27 FROM slith_productgame t0 WHERE t0.product_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.steam_app_id AS steam_app_id_2, t0.external_forum_id AS external_forum_id_3, t0.forum_url AS forum_url_4, t0.is_serial_steam_key AS is_serial_steam_key_5, t0.is_preorder AS is_preorder_6, t0.is_indie AS is_indie_7, t0.gog_slug AS gog_slug_8, t0.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_9, t0.is_release_notification_sent AS is_release_notification_sent_10, t0.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_11, t0.steam_app_api_key AS steam_app_api_key_12, t0.gog_app_id AS gog_app_id_13, t0.gog_app_api_key AS gog_app_api_key_14, t0.discord_url AS discord_url_15, t0.epic_app_id AS epic_app_id_16, t0.epic_slug AS epic_slug_17, t0.epic_app_sandbox_id AS epic_app_sandbox_id_18, t0.training_url AS training_url_19, t0.folder_name AS folder_name_20, t0.has_custom_button AS has_custom_button_21, t0.custom_button_title AS custom_button_title_22, t0.custom_button_link AS custom_button_link_23, t0.product_id AS product_id_24, t0.developer_id AS developer_id_25, t0.life_cycle_id AS life_cycle_id_26, t0.forum_id AS forum_id_27 FROM slith_productgame t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.steam_app_id AS steam_app_id_2, t0.external_forum_id AS external_forum_id_3, t0.forum_url AS forum_url_4, t0.is_serial_steam_key AS is_serial_steam_key_5, t0.is_preorder AS is_preorder_6, t0.is_indie AS is_indie_7, t0.gog_slug AS gog_slug_8, t0.is_pre_order_download_available_notification_sent AS is_pre_order_download_available_notification_sent_9, t0.is_release_notification_sent AS is_release_notification_sent_10, t0.is_pre_order_available_notification_sent AS is_pre_order_available_notification_sent_11, t0.steam_app_api_key AS steam_app_api_key_12, t0.gog_app_id AS gog_app_id_13, t0.gog_app_api_key AS gog_app_api_key_14, t0.discord_url AS discord_url_15, t0.epic_app_id AS epic_app_id_16, t0.epic_slug AS epic_slug_17, t0.epic_app_sandbox_id AS epic_app_sandbox_id_18, t0.training_url AS training_url_19, t0.folder_name AS folder_name_20, t0.has_custom_button AS has_custom_button_21, t0.custom_button_title AS custom_button_title_22, t0.custom_button_link AS custom_button_link_23, t0.product_id AS product_id_24, t0.developer_id AS developer_id_25, t0.life_cycle_id AS life_cycle_id_26, t0.forum_id AS forum_id_27 FROM slith_productgame t0 WHERE t0.product_id = 838;
2.32 ms (2.48%)	21	SELECT t0.id AS id_1, t0.contract AS contract_2, t0.price AS price_3, t0.is_round AS is_round_4, t0.old_platform_contract_id AS old_platform_contract_id_5, t0.weight AS weight_6, t0.length AS length_7, t0.width AS width_8, t0.depth AS depth_9, t0.is_free AS is_free_10, t0.contract_priority AS contract_priority_11, t0.game_platform_id AS game_platform_id_12, t0.store_id AS store_id_13, t0.contract_type_id AS contract_type_id_14, t0.shipping_type_id AS shipping_type_id_15, t0.status_id AS status_id_16, t0.product_id AS product_id_17, t0.game_edition_id AS game_edition_id_18, t0.shopping_cart_coupon_id AS shopping_cart_coupon_id_19 FROM slith_gamecontract t0 WHERE t0.game_platform_id = ? Parameters: [`1211`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.contract AS contract_2, t0.price AS price_3, t0.is_round AS is_round_4, t0.old_platform_contract_id AS old_platform_contract_id_5, t0.weight AS weight_6, t0.length AS length_7, t0.width AS width_8, t0.depth AS depth_9, t0.is_free AS is_free_10, t0.contract_priority AS contract_priority_11, t0.game_platform_id AS game_platform_id_12, t0.store_id AS store_id_13, t0.contract_type_id AS contract_type_id_14, t0.shipping_type_id AS shipping_type_id_15, t0.status_id AS status_id_16, t0.product_id AS product_id_17, t0.game_edition_id AS game_edition_id_18, t0.shopping_cart_coupon_id AS shopping_cart_coupon_id_19 FROM slith_gamecontract t0 WHERE t0.game_platform_id = ? SELECT t0.id AS id_1, t0.contract AS contract_2, t0.price AS price_3, t0.is_round AS is_round_4, t0.old_platform_contract_id AS old_platform_contract_id_5, t0.weight AS weight_6, t0.length AS length_7, t0.width AS width_8, t0.depth AS depth_9, t0.is_free AS is_free_10, t0.contract_priority AS contract_priority_11, t0.game_platform_id AS game_platform_id_12, t0.store_id AS store_id_13, t0.contract_type_id AS contract_type_id_14, t0.shipping_type_id AS shipping_type_id_15, t0.status_id AS status_id_16, t0.product_id AS product_id_17, t0.game_edition_id AS game_edition_id_18, t0.shopping_cart_coupon_id AS shopping_cart_coupon_id_19 FROM slith_gamecontract t0 WHERE t0.game_platform_id = 1211;
2.20 ms (2.36%)	22	SELECT t0.id AS id_1, t0.description AS description_2, t0.features AS features_3, t0.requirements AS requirements_4, t0.game_data AS game_data_5, t0.discover_more_link AS discover_more_link_6, t0.historical_background AS historical_background_7, t0.lore AS lore_8, t0.product_id AS product_id_9 FROM slith_gamecontent t0 WHERE t0.product_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.description AS description_2, t0.features AS features_3, t0.requirements AS requirements_4, t0.game_data AS game_data_5, t0.discover_more_link AS discover_more_link_6, t0.historical_background AS historical_background_7, t0.lore AS lore_8, t0.product_id AS product_id_9 FROM slith_gamecontent t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.description AS description_2, t0.features AS features_3, t0.requirements AS requirements_4, t0.game_data AS game_data_5, t0.discover_more_link AS discover_more_link_6, t0.historical_background AS historical_background_7, t0.lore AS lore_8, t0.product_id AS product_id_9 FROM slith_gamecontent t0 WHERE t0.product_id = 838;
2.15 ms (2.31%)	16	SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.image_file_name AS image_file_name_6, t0.do_not_send_notification AS do_not_send_notification_7, t0.status_id AS status_id_8, t9.id AS id_10, t9.trigger_time AS trigger_time_11, t9.notification_id AS notification_id_12, t9.action_status_id AS action_status_id_13, t9.notification_type_id AS notification_type_id_14, t9.discount_id AS discount_id_15, t9.product_id AS product_id_16, t9.transaction_id AS transaction_id_17, t9.tournament_id AS tournament_id_18, t9.user_id AS user_id_19, t20.id AS id_21, t20.name AS name_22, t20.description AS description_23, t20.date_created AS date_created_24, t20.date_finished AS date_finished_25, t20.email_subject AS email_subject_26, t20.notification_status_id AS notification_status_id_27, t20.notification_type_id AS notification_type_id_28, t20.notification_template_id AS notification_template_id_29, t20.wishlist_id AS wishlist_id_30, t20.product_id AS product_id_31, t20.discount_id AS discount_id_32, t20.transaction_id AS transaction_id_33, t20.tournament_id AS tournament_id_34, t0.discount_method_id AS discount_method_id_35 FROM slith_discount t0 LEFT JOIN slith_notificationtrigger t9 ON t9.discount_id = t0.id LEFT JOIN slith_notification t20 ON t20.discount_id = t0.id WHERE t0.id = ? Parameters: [`162`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.image_file_name AS image_file_name_6, t0.do_not_send_notification AS do_not_send_notification_7, t0.status_id AS status_id_8, t9.id AS id_10, t9.trigger_time AS trigger_time_11, t9.notification_id AS notification_id_12, t9.action_status_id AS action_status_id_13, t9.notification_type_id AS notification_type_id_14, t9.discount_id AS discount_id_15, t9.product_id AS product_id_16, t9.transaction_id AS transaction_id_17, t9.tournament_id AS tournament_id_18, t9.user_id AS user_id_19, t20.id AS id_21, t20.name AS name_22, t20.description AS description_23, t20.date_created AS date_created_24, t20.date_finished AS date_finished_25, t20.email_subject AS email_subject_26, t20.notification_status_id AS notification_status_id_27, t20.notification_type_id AS notification_type_id_28, t20.notification_template_id AS notification_template_id_29, t20.wishlist_id AS wishlist_id_30, t20.product_id AS product_id_31, t20.discount_id AS discount_id_32, t20.transaction_id AS transaction_id_33, t20.tournament_id AS tournament_id_34, t0.discount_method_id AS discount_method_id_35 FROM slith_discount t0 LEFT JOIN slith_notificationtrigger t9 ON t9.discount_id = t0.id LEFT JOIN slith_notification t20 ON t20.discount_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.image_file_name AS image_file_name_6, t0.do_not_send_notification AS do_not_send_notification_7, t0.status_id AS status_id_8, t9.id AS id_10, t9.trigger_time AS trigger_time_11, t9.notification_id AS notification_id_12, t9.action_status_id AS action_status_id_13, t9.notification_type_id AS notification_type_id_14, t9.discount_id AS discount_id_15, t9.product_id AS product_id_16, t9.transaction_id AS transaction_id_17, t9.tournament_id AS tournament_id_18, t9.user_id AS user_id_19, t20.id AS id_21, t20.name AS name_22, t20.description AS description_23, t20.date_created AS date_created_24, t20.date_finished AS date_finished_25, t20.email_subject AS email_subject_26, t20.notification_status_id AS notification_status_id_27, t20.notification_type_id AS notification_type_id_28, t20.notification_template_id AS notification_template_id_29, t20.wishlist_id AS wishlist_id_30, t20.product_id AS product_id_31, t20.discount_id AS discount_id_32, t20.transaction_id AS transaction_id_33, t20.tournament_id AS tournament_id_34, t0.discount_method_id AS discount_method_id_35 FROM slith_discount t0 LEFT JOIN slith_notificationtrigger t9 ON t9.discount_id = t0.id LEFT JOIN slith_notification t20 ON t20.discount_id = t0.id WHERE t0.id = 162;
2.09 ms (2.24%)	21	SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.requirements AS requirements_3, t0.release_date AS release_date_4, t0.old_game_platform_id AS old_game_platform_id_5, t0.short_url AS short_url_6, t0.product_id AS product_id_7, t0.platform_id AS platform_id_8, t0.status_id AS status_id_9 FROM slith_gameplatform t0 WHERE t0.product_id = ? Parameters: [`751`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.requirements AS requirements_3, t0.release_date AS release_date_4, t0.old_game_platform_id AS old_game_platform_id_5, t0.short_url AS short_url_6, t0.product_id AS product_id_7, t0.platform_id AS platform_id_8, t0.status_id AS status_id_9 FROM slith_gameplatform t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.requirements AS requirements_3, t0.release_date AS release_date_4, t0.old_game_platform_id AS old_game_platform_id_5, t0.short_url AS short_url_6, t0.product_id AS product_id_7, t0.platform_id AS platform_id_8, t0.status_id AS status_id_9 FROM slith_gameplatform t0 WHERE t0.product_id = 751;
1.98 ms (2.12%)	21	SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.discount_id AS discount_id_3, t0.game_contract_id AS game_contract_id_4 FROM slith_discountcontract t0 WHERE t0.game_contract_id = ? Parameters: [`1507`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.discount_id AS discount_id_3, t0.game_contract_id AS game_contract_id_4 FROM slith_discountcontract t0 WHERE t0.game_contract_id = ? SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.discount_id AS discount_id_3, t0.game_contract_id AS game_contract_id_4 FROM slith_discountcontract t0 WHERE t0.game_contract_id = 1507;
1.89 ms (2.03%)	22	SELECT t0.id AS id_1, t0.min_players AS min_players_2, t0.max_players AS max_players_3, t0.product_id AS product_id_4, t0.genre_id AS genre_id_5, t0.timeline_id AS timeline_id_6, t0.theatre_id AS theatre_id_7, t0.difficulty_id AS difficulty_id_8, t0.play_style_id AS play_style_id_9, t0.artificial_intelligence_id AS artificial_intelligence_id_10, t0.game_editor_id AS game_editor_id_11, t0.turn_scale_id AS turn_scale_id_12, t0.multiplayer_id AS multiplayer_id_13, t0.unit_scale_id AS unit_scale_id_14 FROM slith_gameoptions t0 WHERE t0.product_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.min_players AS min_players_2, t0.max_players AS max_players_3, t0.product_id AS product_id_4, t0.genre_id AS genre_id_5, t0.timeline_id AS timeline_id_6, t0.theatre_id AS theatre_id_7, t0.difficulty_id AS difficulty_id_8, t0.play_style_id AS play_style_id_9, t0.artificial_intelligence_id AS artificial_intelligence_id_10, t0.game_editor_id AS game_editor_id_11, t0.turn_scale_id AS turn_scale_id_12, t0.multiplayer_id AS multiplayer_id_13, t0.unit_scale_id AS unit_scale_id_14 FROM slith_gameoptions t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.min_players AS min_players_2, t0.max_players AS max_players_3, t0.product_id AS product_id_4, t0.genre_id AS genre_id_5, t0.timeline_id AS timeline_id_6, t0.theatre_id AS theatre_id_7, t0.difficulty_id AS difficulty_id_8, t0.play_style_id AS play_style_id_9, t0.artificial_intelligence_id AS artificial_intelligence_id_10, t0.game_editor_id AS game_editor_id_11, t0.turn_scale_id AS turn_scale_id_12, t0.multiplayer_id AS multiplayer_id_13, t0.unit_scale_id AS unit_scale_id_14 FROM slith_gameoptions t0 WHERE t0.product_id = 838;
1.83 ms (1.96%)	22	SELECT t0.id AS id_1, t0.name AS name_2, t0.web_apipublisher_key AS web_apipublisher_key_3, t0.background_image_name AS background_image_name_4, t0.leaderboard_title_id AS leaderboard_title_id_5, t0.secret_key AS secret_key_6, t0.product_id AS product_id_7, t0.status_id AS status_id_8, t0.leaderboard_provider_id AS leaderboard_provider_id_9 FROM slith_leaderboard t0 WHERE t0.product_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.web_apipublisher_key AS web_apipublisher_key_3, t0.background_image_name AS background_image_name_4, t0.leaderboard_title_id AS leaderboard_title_id_5, t0.secret_key AS secret_key_6, t0.product_id AS product_id_7, t0.status_id AS status_id_8, t0.leaderboard_provider_id AS leaderboard_provider_id_9 FROM slith_leaderboard t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.web_apipublisher_key AS web_apipublisher_key_3, t0.background_image_name AS background_image_name_4, t0.leaderboard_title_id AS leaderboard_title_id_5, t0.secret_key AS secret_key_6, t0.product_id AS product_id_7, t0.status_id AS status_id_8, t0.leaderboard_provider_id AS leaderboard_provider_id_9 FROM slith_leaderboard t0 WHERE t0.product_id = 838;
1.76 ms (1.89%)	22	SELECT t0.id AS id_1, t0.is_license_file_revocable AS is_license_file_revocable_2, t0.is_price_calculator_available AS is_price_calculator_available_3, t0.pro_license_encryption_key AS pro_license_encryption_key_4, t0.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_5, t0.pro_license_generation_alert_email AS pro_license_generation_alert_email_6, t0.capabilities AS capabilities_7, t0.product_id AS product_id_8 FROM slith_proproduct t0 WHERE t0.product_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.is_license_file_revocable AS is_license_file_revocable_2, t0.is_price_calculator_available AS is_price_calculator_available_3, t0.pro_license_encryption_key AS pro_license_encryption_key_4, t0.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_5, t0.pro_license_generation_alert_email AS pro_license_generation_alert_email_6, t0.capabilities AS capabilities_7, t0.product_id AS product_id_8 FROM slith_proproduct t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.is_license_file_revocable AS is_license_file_revocable_2, t0.is_price_calculator_available AS is_price_calculator_available_3, t0.pro_license_encryption_key AS pro_license_encryption_key_4, t0.pro_license_encryption_key_salt AS pro_license_encryption_key_salt_5, t0.pro_license_generation_alert_email AS pro_license_generation_alert_email_6, t0.capabilities AS capabilities_7, t0.product_id AS product_id_8 FROM slith_proproduct t0 WHERE t0.product_id = 838;
1.66 ms (1.77%)	22	SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3, t0.belongs_to_product_id AS belongs_to_product_id_4, t0.merchandise_type_id AS merchandise_type_id_5 FROM slith_productmerchandise t0 WHERE t0.product_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3, t0.belongs_to_product_id AS belongs_to_product_id_4, t0.merchandise_type_id AS merchandise_type_id_5 FROM slith_productmerchandise t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.description AS description_2, t0.product_id AS product_id_3, t0.belongs_to_product_id AS belongs_to_product_id_4, t0.merchandise_type_id AS merchandise_type_id_5 FROM slith_productmerchandise t0 WHERE t0.product_id = 838;
1.59 ms (1.71%)	22	SELECT t0.id AS id_1, t0.name AS name_2, t0.streak_key AS streak_key_3, t0.sort_order_index AS sort_order_index_4, t0.internal_product_id AS internal_product_id_5, t0.streak_field_product_type_id AS streak_field_product_type_id_6 FROM slith_streakfieldproduct t0 WHERE t0.internal_product_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.streak_key AS streak_key_3, t0.sort_order_index AS sort_order_index_4, t0.internal_product_id AS internal_product_id_5, t0.streak_field_product_type_id AS streak_field_product_type_id_6 FROM slith_streakfieldproduct t0 WHERE t0.internal_product_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.streak_key AS streak_key_3, t0.sort_order_index AS sort_order_index_4, t0.internal_product_id AS internal_product_id_5, t0.streak_field_product_type_id AS streak_field_product_type_id_6 FROM slith_streakfieldproduct t0 WHERE t0.internal_product_id = 838;
1.57 ms (1.69%)	22	SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.product_id AS product_id_3 FROM slith_productbundle t0 WHERE t0.product_id = ? Parameters: [`838`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.product_id AS product_id_3 FROM slith_productbundle t0 WHERE t0.product_id = ? SELECT t0.id AS id_1, t0.discount_percent AS discount_percent_2, t0.product_id AS product_id_3 FROM slith_productbundle t0 WHERE t0.product_id = 838;
0.37 ms (0.39%)	4	SELECT t0.id AS id_1, t0.trigger_time AS trigger_time_2, t0.notification_id AS notification_id_3, t0.action_status_id AS action_status_id_4, t0.notification_type_id AS notification_type_id_5, t0.discount_id AS discount_id_6, t0.product_id AS product_id_7, t0.transaction_id AS transaction_id_8, t0.tournament_id AS tournament_id_9, t0.user_id AS user_id_10 FROM slith_notificationtrigger t0 WHERE t0.notification_id = ? Parameters: [`787`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.trigger_time AS trigger_time_2, t0.notification_id AS notification_id_3, t0.action_status_id AS action_status_id_4, t0.notification_type_id AS notification_type_id_5, t0.discount_id AS discount_id_6, t0.product_id AS product_id_7, t0.transaction_id AS transaction_id_8, t0.tournament_id AS tournament_id_9, t0.user_id AS user_id_10 FROM slith_notificationtrigger t0 WHERE t0.notification_id = ? SELECT t0.id AS id_1, t0.trigger_time AS trigger_time_2, t0.notification_id AS notification_id_3, t0.action_status_id AS action_status_id_4, t0.notification_type_id AS notification_type_id_5, t0.discount_id AS discount_id_6, t0.product_id AS product_id_7, t0.transaction_id AS transaction_id_8, t0.tournament_id AS tournament_id_9, t0.user_id AS user_id_10 FROM slith_notificationtrigger t0 WHERE t0.notification_id = 787;
0.30 ms (0.33%)	2	SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.description AS description_4, s0_.status_id AS status_id_5, s0_.block_location_id AS block_location_id_6 FROM slith_block s0_ INNER JOIN slith_block_website s2_ ON s0_.id = s2_.slith_block_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id INNER JOIN slith_blocklocation s3_ ON s0_.block_location_id = s3_.id WHERE s0_.status_id IN (?) AND s3_.id = ? AND s1_.id = ? Parameters: [`2 7 2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.description AS description_4, s0_.status_id AS status_id_5, s0_.block_location_id AS block_location_id_6 FROM slith_block s0_ INNER JOIN slith_block_website s2_ ON s0_.id = s2_.slith_block_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id INNER JOIN slith_blocklocation s3_ ON s0_.block_location_id = s3_.id WHERE s0_.status_id IN (?) AND s3_.id = ? AND s1_.id = ? SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.description AS description_4, s0_.status_id AS status_id_5, s0_.block_location_id AS block_location_id_6 FROM slith_block s0_ INNER JOIN slith_block_website s2_ ON s0_.id = s2_.slith_block_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id INNER JOIN slith_blocklocation s3_ ON s0_.block_location_id = s3_.id WHERE s0_.status_id IN (2) AND s3_.id = 7 AND s1_.id = 2;
0.25 ms (0.27%)	2	SELECT t0.id AS id_1, t0.store AS store_2, t0.style AS style_3, t0.label AS label_4, t0.show_price AS show_price_5, t0.logo_file_name AS logo_file_name_6, t0.old_store_id AS old_store_id_7, t0.slug AS slug_8, t0.purchase_method_id AS purchase_method_id_9 FROM slith_store t0 INNER JOIN slith_store_platform ON t0.id = slith_store_platform.slith_store_id WHERE slith_store_platform.slith_platform_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.store AS store_2, t0.style AS style_3, t0.label AS label_4, t0.show_price AS show_price_5, t0.logo_file_name AS logo_file_name_6, t0.old_store_id AS old_store_id_7, t0.slug AS slug_8, t0.purchase_method_id AS purchase_method_id_9 FROM slith_store t0 INNER JOIN slith_store_platform ON t0.id = slith_store_platform.slith_store_id WHERE slith_store_platform.slith_platform_id = ? SELECT t0.id AS id_1, t0.store AS store_2, t0.style AS style_3, t0.label AS label_4, t0.show_price AS show_price_5, t0.logo_file_name AS logo_file_name_6, t0.old_store_id AS old_store_id_7, t0.slug AS slug_8, t0.purchase_method_id AS purchase_method_id_9 FROM slith_store t0 INNER JOIN slith_store_platform ON t0.id = slith_store_platform.slith_store_id WHERE slith_store_platform.slith_platform_id = 1;
0.24 ms (0.26%)	1	SELECT s0_.id AS id_0, s0_.developer_name AS developer_name_1, s0_.old_developer_id AS old_developer_id_2, s0_.email AS email_3, s0_.first_name AS first_name_4, s0_.last_name AS last_name_5, s0_.status_id AS status_id_6 FROM slith_developer s0_ INNER JOIN slith_status s1_ ON s0_.status_id = s1_.id WHERE s1_.id = ? ORDER BY s0_.developer_name ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.developer_name AS developer_name_1, s0_.old_developer_id AS old_developer_id_2, s0_.email AS email_3, s0_.first_name AS first_name_4, s0_.last_name AS last_name_5, s0_.status_id AS status_id_6 FROM slith_developer s0_ INNER JOIN slith_status s1_ ON s0_.status_id = s1_.id WHERE s1_.id = ? ORDER BY s0_.developer_name ASC SELECT s0_.id AS id_0, s0_.developer_name AS developer_name_1, s0_.old_developer_id AS old_developer_id_2, s0_.email AS email_3, s0_.first_name AS first_name_4, s0_.last_name AS last_name_5, s0_.status_id AS status_id_6 FROM slith_developer s0_ INNER JOIN slith_status s1_ ON s0_.status_id = s1_.id WHERE s1_.id = 2 ORDER BY s0_.developer_name ASC;
0.24 ms (0.26%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.bluesnap_data_protection_key AS bluesnap_data_protection_key_3, t0.factory_allowed_ips AS factory_allowed_ips_4, t0.minimum_stock_steam_keys AS minimum_stock_steam_keys_5, t0.max_notification_emails_per_batch AS max_notification_emails_per_batch_6, t0.max_notification_users_created_per_batch AS max_notification_users_created_per_batch_7, t0.factory_feed_deferral_days AS factory_feed_deferral_days_8, t0.max_bluesnap_report_items_per_page AS max_bluesnap_report_items_per_page_9, t0.pro_license_encryption_key AS pro_license_encryption_key_10, t0.pro_license_generation_alert_email AS pro_license_generation_alert_email_11, t0.is_notification_test AS is_notification_test_12, t0.notification_test_email AS notification_test_email_13, t0.re_captcha_secret_key AS re_captcha_secret_key_14, t0.re_captcha_key AS re_captcha_key_15, t0.contact_pro_recipient AS contact_pro_recipient_16, t0.contact_press_recipient AS contact_press_recipient_17, t0.max_wrong_count_coupon_code_applications AS max_wrong_count_coupon_code_applications_18, t0.max_time_between_wrong_coupon_code_applications AS max_time_between_wrong_coupon_code_applications_19, t0.max_time_between_user_active AS max_time_between_user_active_20, t0.pro_license_expiration_notification_day AS pro_license_expiration_notification_day_21, t0.pro_license_expiration_notification_survey_day AS pro_license_expiration_notification_survey_day_22, t0.pro_license_expiration_notification_survey_link AS pro_license_expiration_notification_survey_link_23, t0.pro_license_new_user_notification_survey_day AS pro_license_new_user_notification_survey_day_24, t0.pro_license_new_user_notification_survey_link AS pro_license_new_user_notification_survey_link_25, t0.otrsmax_message_length AS otrsmax_message_length_26, t0.creditcard_processing_seconds_threshold AS creditcard_processing_seconds_threshold_27, t0.pro_licensing_otrsqueue AS pro_licensing_otrsqueue_28, t0.contact_pro_quote_request_logs_recipient AS contact_pro_quote_request_logs_recipient_29, t0.max_forum_badge_selectable AS max_forum_badge_selectable_30, t0.ttl_elorating_leaderboard_page_cache AS ttl_elorating_leaderboard_page_cache_31, t0.max_items_per_page_elorating_leaderboard AS max_items_per_page_elorating_leaderboard_32, t0.max_items_per_page_elorating_leaderboard_history AS max_items_per_page_elorating_leaderboard_history_33, t0.contact_press_kproject_recipient AS contact_press_kproject_recipient_34, t0.event_max_spots_count AS event_max_spots_count_35, t0.stripe_apikey AS stripe_apikey_36, t0.stripe_apisecret_key AS stripe_apisecret_key_37, t0.test_stripe_apikey AS test_stripe_apikey_38, t0.test_stripe_apisecret_key AS test_stripe_apisecret_key_39, t0.minimum_stock_coupons_notification_email AS minimum_stock_coupons_notification_email_40, t0.is_re_captcha_ipwhitelist_enable AS is_re_captcha_ipwhitelist_enable_41, t0.re_captcha_ipwhitelist AS re_captcha_ipwhitelist_42, t0.max_days_bluesnap_log_ttl AS max_days_bluesnap_log_ttl_43, t0.is_streak_integration_enabled AS is_streak_integration_enabled_44, t0.language_id AS language_id_45, t0.currency_id AS currency_id_46, t0.website_user_id AS website_user_id_47, t0.xmas_mode_status_id AS xmas_mode_status_id_48, t0.helpdesk_id AS helpdesk_id_49, t0.pro_helpdesk_id AS pro_helpdesk_id_50, t0.default_website_id AS default_website_id_51, t0.current_pbem_server_id AS current_pbem_server_id_52 FROM slith_config t0 WHERE t0.id = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.bluesnap_data_protection_key AS bluesnap_data_protection_key_3, t0.factory_allowed_ips AS factory_allowed_ips_4, t0.minimum_stock_steam_keys AS minimum_stock_steam_keys_5, t0.max_notification_emails_per_batch AS max_notification_emails_per_batch_6, t0.max_notification_users_created_per_batch AS max_notification_users_created_per_batch_7, t0.factory_feed_deferral_days AS factory_feed_deferral_days_8, t0.max_bluesnap_report_items_per_page AS max_bluesnap_report_items_per_page_9, t0.pro_license_encryption_key AS pro_license_encryption_key_10, t0.pro_license_generation_alert_email AS pro_license_generation_alert_email_11, t0.is_notification_test AS is_notification_test_12, t0.notification_test_email AS notification_test_email_13, t0.re_captcha_secret_key AS re_captcha_secret_key_14, t0.re_captcha_key AS re_captcha_key_15, t0.contact_pro_recipient AS contact_pro_recipient_16, t0.contact_press_recipient AS contact_press_recipient_17, t0.max_wrong_count_coupon_code_applications AS max_wrong_count_coupon_code_applications_18, t0.max_time_between_wrong_coupon_code_applications AS max_time_between_wrong_coupon_code_applications_19, t0.max_time_between_user_active AS max_time_between_user_active_20, t0.pro_license_expiration_notification_day AS pro_license_expiration_notification_day_21, t0.pro_license_expiration_notification_survey_day AS pro_license_expiration_notification_survey_day_22, t0.pro_license_expiration_notification_survey_link AS pro_license_expiration_notification_survey_link_23, t0.pro_license_new_user_notification_survey_day AS pro_license_new_user_notification_survey_day_24, t0.pro_license_new_user_notification_survey_link AS pro_license_new_user_notification_survey_link_25, t0.otrsmax_message_length AS otrsmax_message_length_26, t0.creditcard_processing_seconds_threshold AS creditcard_processing_seconds_threshold_27, t0.pro_licensing_otrsqueue AS pro_licensing_otrsqueue_28, t0.contact_pro_quote_request_logs_recipient AS contact_pro_quote_request_logs_recipient_29, t0.max_forum_badge_selectable AS max_forum_badge_selectable_30, t0.ttl_elorating_leaderboard_page_cache AS ttl_elorating_leaderboard_page_cache_31, t0.max_items_per_page_elorating_leaderboard AS max_items_per_page_elorating_leaderboard_32, t0.max_items_per_page_elorating_leaderboard_history AS max_items_per_page_elorating_leaderboard_history_33, t0.contact_press_kproject_recipient AS contact_press_kproject_recipient_34, t0.event_max_spots_count AS event_max_spots_count_35, t0.stripe_apikey AS stripe_apikey_36, t0.stripe_apisecret_key AS stripe_apisecret_key_37, t0.test_stripe_apikey AS test_stripe_apikey_38, t0.test_stripe_apisecret_key AS test_stripe_apisecret_key_39, t0.minimum_stock_coupons_notification_email AS minimum_stock_coupons_notification_email_40, t0.is_re_captcha_ipwhitelist_enable AS is_re_captcha_ipwhitelist_enable_41, t0.re_captcha_ipwhitelist AS re_captcha_ipwhitelist_42, t0.max_days_bluesnap_log_ttl AS max_days_bluesnap_log_ttl_43, t0.is_streak_integration_enabled AS is_streak_integration_enabled_44, t0.language_id AS language_id_45, t0.currency_id AS currency_id_46, t0.website_user_id AS website_user_id_47, t0.xmas_mode_status_id AS xmas_mode_status_id_48, t0.helpdesk_id AS helpdesk_id_49, t0.pro_helpdesk_id AS pro_helpdesk_id_50, t0.default_website_id AS default_website_id_51, t0.current_pbem_server_id AS current_pbem_server_id_52 FROM slith_config t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.bluesnap_data_protection_key AS bluesnap_data_protection_key_3, t0.factory_allowed_ips AS factory_allowed_ips_4, t0.minimum_stock_steam_keys AS minimum_stock_steam_keys_5, t0.max_notification_emails_per_batch AS max_notification_emails_per_batch_6, t0.max_notification_users_created_per_batch AS max_notification_users_created_per_batch_7, t0.factory_feed_deferral_days AS factory_feed_deferral_days_8, t0.max_bluesnap_report_items_per_page AS max_bluesnap_report_items_per_page_9, t0.pro_license_encryption_key AS pro_license_encryption_key_10, t0.pro_license_generation_alert_email AS pro_license_generation_alert_email_11, t0.is_notification_test AS is_notification_test_12, t0.notification_test_email AS notification_test_email_13, t0.re_captcha_secret_key AS re_captcha_secret_key_14, t0.re_captcha_key AS re_captcha_key_15, t0.contact_pro_recipient AS contact_pro_recipient_16, t0.contact_press_recipient AS contact_press_recipient_17, t0.max_wrong_count_coupon_code_applications AS max_wrong_count_coupon_code_applications_18, t0.max_time_between_wrong_coupon_code_applications AS max_time_between_wrong_coupon_code_applications_19, t0.max_time_between_user_active AS max_time_between_user_active_20, t0.pro_license_expiration_notification_day AS pro_license_expiration_notification_day_21, t0.pro_license_expiration_notification_survey_day AS pro_license_expiration_notification_survey_day_22, t0.pro_license_expiration_notification_survey_link AS pro_license_expiration_notification_survey_link_23, t0.pro_license_new_user_notification_survey_day AS pro_license_new_user_notification_survey_day_24, t0.pro_license_new_user_notification_survey_link AS pro_license_new_user_notification_survey_link_25, t0.otrsmax_message_length AS otrsmax_message_length_26, t0.creditcard_processing_seconds_threshold AS creditcard_processing_seconds_threshold_27, t0.pro_licensing_otrsqueue AS pro_licensing_otrsqueue_28, t0.contact_pro_quote_request_logs_recipient AS contact_pro_quote_request_logs_recipient_29, t0.max_forum_badge_selectable AS max_forum_badge_selectable_30, t0.ttl_elorating_leaderboard_page_cache AS ttl_elorating_leaderboard_page_cache_31, t0.max_items_per_page_elorating_leaderboard AS max_items_per_page_elorating_leaderboard_32, t0.max_items_per_page_elorating_leaderboard_history AS max_items_per_page_elorating_leaderboard_history_33, t0.contact_press_kproject_recipient AS contact_press_kproject_recipient_34, t0.event_max_spots_count AS event_max_spots_count_35, t0.stripe_apikey AS stripe_apikey_36, t0.stripe_apisecret_key AS stripe_apisecret_key_37, t0.test_stripe_apikey AS test_stripe_apikey_38, t0.test_stripe_apisecret_key AS test_stripe_apisecret_key_39, t0.minimum_stock_coupons_notification_email AS minimum_stock_coupons_notification_email_40, t0.is_re_captcha_ipwhitelist_enable AS is_re_captcha_ipwhitelist_enable_41, t0.re_captcha_ipwhitelist AS re_captcha_ipwhitelist_42, t0.max_days_bluesnap_log_ttl AS max_days_bluesnap_log_ttl_43, t0.is_streak_integration_enabled AS is_streak_integration_enabled_44, t0.language_id AS language_id_45, t0.currency_id AS currency_id_46, t0.website_user_id AS website_user_id_47, t0.xmas_mode_status_id AS xmas_mode_status_id_48, t0.helpdesk_id AS helpdesk_id_49, t0.pro_helpdesk_id AS pro_helpdesk_id_50, t0.default_website_id AS default_website_id_51, t0.current_pbem_server_id AS current_pbem_server_id_52 FROM slith_config t0 WHERE t0.id = 1 LIMIT 1;
0.21 ms (0.23%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.server_name AS server_name_3, t0.server_address AS server_address_4, t0.status_id AS status_id_5 FROM slith_webserver t0 WHERE t0.server_address = ? LIMIT 1 Parameters: [`"192.168.19.44"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.server_name AS server_name_3, t0.server_address AS server_address_4, t0.status_id AS status_id_5 FROM slith_webserver t0 WHERE t0.server_address = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.server_name AS server_name_3, t0.server_address AS server_address_4, t0.status_id AS status_id_5 FROM slith_webserver t0 WHERE t0.server_address = '192.168.19.44' LIMIT 1;
0.20 ms (0.21%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo_file_name AS logo_file_name_4, t0.highlight AS highlight_5, t0.description AS description_6 FROM slith_gameedition t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo_file_name AS logo_file_name_4, t0.highlight AS highlight_5, t0.description AS description_6 FROM slith_gameedition t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo_file_name AS logo_file_name_4, t0.highlight AS highlight_5, t0.description AS description_6 FROM slith_gameedition t0;
0.20 ms (0.21%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.domain_name AS domain_name_3, t0.old_website_id AS old_website_id_4, t0.slug AS slug_5, t0.google_analytics_tag AS google_analytics_tag_6, t0.facebook_pixel_id AS facebook_pixel_id_7, t0.favicon AS favicon_8, t0.youtube_channel_id AS youtube_channel_id_9, t0.twitch_channel_name AS twitch_channel_name_10, t0.smtp_ip AS smtp_ip_11, t0.smtp_user AS smtp_user_12, t0.smtp_password AS smtp_password_13, t0.email_address AS email_address_14, t0.re_captcha_key AS re_captcha_key_15, t0.forum_url AS forum_url_16, t0.re_captcha_secret_key AS re_captcha_secret_key_17, t0.logo_file_path AS logo_file_path_18, t0.smtp_port AS smtp_port_19, t0.facebook_username AS facebook_username_20, t0.discord_username AS discord_username_21, t0.twitter_handle AS twitter_handle_22, t0.instagram_username AS instagram_username_23, t0.youtube_username AS youtube_username_24, t0.teads_pixel_id AS teads_pixel_id_25, t0.is_subscribe_discount_coupons_available AS is_subscribe_discount_coupons_available_26, t0.reddit_pixel_id AS reddit_pixel_id_27, t0.is_forum_badge_capable AS is_forum_badge_capable_28, t0.forum_badge_update_endpoint AS forum_badge_update_endpoint_29, t0.support_email_address AS support_email_address_30, t31.id AS id_32, t31.name AS name_33, t31.newsletter_id AS newsletter_id_34, t31.newsletter_provider_id AS newsletter_provider_id_35, t31.status_id AS status_id_36, t31.website_id AS website_id_37, t0.forum_id AS forum_id_38 FROM slith_website t0 LEFT JOIN slith_newsletter t31 ON t31.website_id = t0.id WHERE t0.domain_name = ? LIMIT 1 Parameters: [`"www51.slitherine.com"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.domain_name AS domain_name_3, t0.old_website_id AS old_website_id_4, t0.slug AS slug_5, t0.google_analytics_tag AS google_analytics_tag_6, t0.facebook_pixel_id AS facebook_pixel_id_7, t0.favicon AS favicon_8, t0.youtube_channel_id AS youtube_channel_id_9, t0.twitch_channel_name AS twitch_channel_name_10, t0.smtp_ip AS smtp_ip_11, t0.smtp_user AS smtp_user_12, t0.smtp_password AS smtp_password_13, t0.email_address AS email_address_14, t0.re_captcha_key AS re_captcha_key_15, t0.forum_url AS forum_url_16, t0.re_captcha_secret_key AS re_captcha_secret_key_17, t0.logo_file_path AS logo_file_path_18, t0.smtp_port AS smtp_port_19, t0.facebook_username AS facebook_username_20, t0.discord_username AS discord_username_21, t0.twitter_handle AS twitter_handle_22, t0.instagram_username AS instagram_username_23, t0.youtube_username AS youtube_username_24, t0.teads_pixel_id AS teads_pixel_id_25, t0.is_subscribe_discount_coupons_available AS is_subscribe_discount_coupons_available_26, t0.reddit_pixel_id AS reddit_pixel_id_27, t0.is_forum_badge_capable AS is_forum_badge_capable_28, t0.forum_badge_update_endpoint AS forum_badge_update_endpoint_29, t0.support_email_address AS support_email_address_30, t31.id AS id_32, t31.name AS name_33, t31.newsletter_id AS newsletter_id_34, t31.newsletter_provider_id AS newsletter_provider_id_35, t31.status_id AS status_id_36, t31.website_id AS website_id_37, t0.forum_id AS forum_id_38 FROM slith_website t0 LEFT JOIN slith_newsletter t31 ON t31.website_id = t0.id WHERE t0.domain_name = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.domain_name AS domain_name_3, t0.old_website_id AS old_website_id_4, t0.slug AS slug_5, t0.google_analytics_tag AS google_analytics_tag_6, t0.facebook_pixel_id AS facebook_pixel_id_7, t0.favicon AS favicon_8, t0.youtube_channel_id AS youtube_channel_id_9, t0.twitch_channel_name AS twitch_channel_name_10, t0.smtp_ip AS smtp_ip_11, t0.smtp_user AS smtp_user_12, t0.smtp_password AS smtp_password_13, t0.email_address AS email_address_14, t0.re_captcha_key AS re_captcha_key_15, t0.forum_url AS forum_url_16, t0.re_captcha_secret_key AS re_captcha_secret_key_17, t0.logo_file_path AS logo_file_path_18, t0.smtp_port AS smtp_port_19, t0.facebook_username AS facebook_username_20, t0.discord_username AS discord_username_21, t0.twitter_handle AS twitter_handle_22, t0.instagram_username AS instagram_username_23, t0.youtube_username AS youtube_username_24, t0.teads_pixel_id AS teads_pixel_id_25, t0.is_subscribe_discount_coupons_available AS is_subscribe_discount_coupons_available_26, t0.reddit_pixel_id AS reddit_pixel_id_27, t0.is_forum_badge_capable AS is_forum_badge_capable_28, t0.forum_badge_update_endpoint AS forum_badge_update_endpoint_29, t0.support_email_address AS support_email_address_30, t31.id AS id_32, t31.name AS name_33, t31.newsletter_id AS newsletter_id_34, t31.newsletter_provider_id AS newsletter_provider_id_35, t31.status_id AS status_id_36, t31.website_id AS website_id_37, t0.forum_id AS forum_id_38 FROM slith_website t0 LEFT JOIN slith_newsletter t31 ON t31.website_id = t0.id WHERE t0.domain_name = 'www51.slitherine.com' LIMIT 1;
0.19 ms (0.20%)	1	SELECT s0_.id AS id_0, s0_.start_time AS start_time_1, s0_.end_time AS end_time_2, s0_.announcement AS announcement_3, s0_.is_sticky AS is_sticky_4, s0_.is_one_time AS is_one_time_5, s0_.name AS name_6, s0_.is_blocking AS is_blocking_7, s0_.slug AS slug_8, s0_.is_true_false AS is_true_false_9, s0_.refresh AS refresh_10, s0_.status_id AS status_id_11 FROM slith_globalannouncement s0_ INNER JOIN slith_globalannouncement_website s2_ ON s0_.id = s2_.slith_globalannouncement_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id WHERE s1_.id = ? AND s0_.status_id IN (?) Parameters: [`2 2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.start_time AS start_time_1, s0_.end_time AS end_time_2, s0_.announcement AS announcement_3, s0_.is_sticky AS is_sticky_4, s0_.is_one_time AS is_one_time_5, s0_.name AS name_6, s0_.is_blocking AS is_blocking_7, s0_.slug AS slug_8, s0_.is_true_false AS is_true_false_9, s0_.refresh AS refresh_10, s0_.status_id AS status_id_11 FROM slith_globalannouncement s0_ INNER JOIN slith_globalannouncement_website s2_ ON s0_.id = s2_.slith_globalannouncement_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id WHERE s1_.id = ? AND s0_.status_id IN (?) SELECT s0_.id AS id_0, s0_.start_time AS start_time_1, s0_.end_time AS end_time_2, s0_.announcement AS announcement_3, s0_.is_sticky AS is_sticky_4, s0_.is_one_time AS is_one_time_5, s0_.name AS name_6, s0_.is_blocking AS is_blocking_7, s0_.slug AS slug_8, s0_.is_true_false AS is_true_false_9, s0_.refresh AS refresh_10, s0_.status_id AS status_id_11 FROM slith_globalannouncement s0_ INNER JOIN slith_globalannouncement_website s2_ ON s0_.id = s2_.slith_globalannouncement_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id WHERE s1_.id = 2 AND s0_.status_id IN (2);
0.19 ms (0.20%)	2	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.url AS url_4 FROM slith_blocklocation t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"copyright"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.url AS url_4 FROM slith_blocklocation t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.url AS url_4 FROM slith_blocklocation t0 WHERE t0.slug = 'copyright' LIMIT 1;
0.17 ms (0.18%)	1	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.valid_from AS valid_from_3, s0_.valid_until AS valid_until_4, s0_.left_image_path AS left_image_path_5, s0_.right_image_path AS right_image_path_6, s0_.status_id AS status_id_7 FROM slith_skin s0_ INNER JOIN slith_skin_website s2_ ON s0_.id = s2_.slith_skin_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id WHERE s1_.id = ? AND s0_.status_id IN (?) AND (s0_.valid_from IS NULL OR s0_.valid_from <= ?) AND (s0_.valid_until IS NULL OR s0_.valid_until >= ?) LIMIT 1 Parameters: [`2 2 "2026-02-25 02:43:05" "2026-02-25 02:43:05"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.valid_from AS valid_from_3, s0_.valid_until AS valid_until_4, s0_.left_image_path AS left_image_path_5, s0_.right_image_path AS right_image_path_6, s0_.status_id AS status_id_7 FROM slith_skin s0_ INNER JOIN slith_skin_website s2_ ON s0_.id = s2_.slith_skin_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id WHERE s1_.id = ? AND s0_.status_id IN (?) AND ( s0_.valid_from IS NULL OR s0_.valid_from <= ? ) AND ( s0_.valid_until IS NULL OR s0_.valid_until >= ? ) LIMIT 1 SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.valid_from AS valid_from_3, s0_.valid_until AS valid_until_4, s0_.left_image_path AS left_image_path_5, s0_.right_image_path AS right_image_path_6, s0_.status_id AS status_id_7 FROM slith_skin s0_ INNER JOIN slith_skin_website s2_ ON s0_.id = s2_.slith_skin_id INNER JOIN slith_website s1_ ON s1_.id = s2_.slith_website_id WHERE s1_.id = 2 AND s0_.status_id IN (2) AND (s0_.valid_from IS NULL OR s0_.valid_from <= '2026-02-25 02:43:05') AND (s0_.valid_until IS NULL OR s0_.valid_until >= '2026-02-25 02:43:05') LIMIT 1;
0.13 ms (0.14%)	1	SELECT s0_.id AS id_0, s0_.product_type AS product_type_1, s0_.slug AS slug_2 FROM slith_producttype s0_ Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.product_type AS product_type_1, s0_.slug AS slug_2 FROM slith_producttype s0_ SELECT s0_.id AS id_0, s0_.product_type AS product_type_1, s0_.slug AS slug_2 FROM slith_producttype s0_;
0.11 ms (0.12%)	1	SELECT s0_.id AS id_0, s0_.platform AS platform_1, s0_.wikipedia_url AS wikipedia_url_2, s0_.logo_file_name AS logo_file_name_3, s0_.old_platform_id AS old_platform_id_4, s0_.logo_light_file_name AS logo_light_file_name_5, s0_.slug AS slug_6 FROM slith_platform s0_ Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.platform AS platform_1, s0_.wikipedia_url AS wikipedia_url_2, s0_.logo_file_name AS logo_file_name_3, s0_.old_platform_id AS old_platform_id_4, s0_.logo_light_file_name AS logo_light_file_name_5, s0_.slug AS slug_6 FROM slith_platform s0_ SELECT s0_.id AS id_0, s0_.platform AS platform_1, s0_.wikipedia_url AS wikipedia_url_2, s0_.logo_file_name AS logo_file_name_3, s0_.old_platform_id AS old_platform_id_4, s0_.logo_light_file_name AS logo_light_file_name_5, s0_.slug AS slug_6 FROM slith_platform s0_;
0.10 ms (0.11%)	1	SELECT t0.id AS id_1, t0.currency AS currency_2, t0.display_format_full AS display_format_full_3, t0.display_format_short AS display_format_short_4, t0.iso3 AS iso3_5, t0.exchange_rate AS exchange_rate_6, t0.exchange_rate_updated AS exchange_rate_updated_7, t0.is_custom_exchange_rate AS is_custom_exchange_rate_8, t0.is_pay_pal_currency AS is_pay_pal_currency_9, t0.old_currency_id AS old_currency_id_10 FROM slith_currency t0 WHERE t0.id = ? Parameters: [`56`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.currency AS currency_2, t0.display_format_full AS display_format_full_3, t0.display_format_short AS display_format_short_4, t0.iso3 AS iso3_5, t0.exchange_rate AS exchange_rate_6, t0.exchange_rate_updated AS exchange_rate_updated_7, t0.is_custom_exchange_rate AS is_custom_exchange_rate_8, t0.is_pay_pal_currency AS is_pay_pal_currency_9, t0.old_currency_id AS old_currency_id_10 FROM slith_currency t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.currency AS currency_2, t0.display_format_full AS display_format_full_3, t0.display_format_short AS display_format_short_4, t0.iso3 AS iso3_5, t0.exchange_rate AS exchange_rate_6, t0.exchange_rate_updated AS exchange_rate_updated_7, t0.is_custom_exchange_rate AS is_custom_exchange_rate_8, t0.is_pay_pal_currency AS is_pay_pal_currency_9, t0.old_currency_id AS old_currency_id_10 FROM slith_currency t0 WHERE t0.id = 56;
0.10 ms (0.10%)	1	SELECT s0_.id AS id_0, s0_.genre AS genre_1, s0_.old_genre_id AS old_genre_id_2 FROM slith_genre s0_ Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.genre AS genre_1, s0_.old_genre_id AS old_genre_id_2 FROM slith_genre s0_ SELECT s0_.id AS id_0, s0_.genre AS genre_1, s0_.old_genre_id AS old_genre_id_2 FROM slith_genre s0_;
0.10 ms (0.10%)	1	SELECT s0_.id AS id_0, s0_.timeline AS timeline_1, s0_.old_timeline_id AS old_timeline_id_2 FROM slith_timeline s0_ Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.timeline AS timeline_1, s0_.old_timeline_id AS old_timeline_id_2 FROM slith_timeline s0_ SELECT s0_.id AS id_0, s0_.timeline AS timeline_1, s0_.old_timeline_id AS old_timeline_id_2 FROM slith_timeline s0_;
0.10 ms (0.10%)	1	SELECT t0.id AS id_1, t0.life_cycle AS life_cycle_2, t0.slug AS slug_3, t0.old_game_status_id AS old_game_status_id_4 FROM slith_gamelifecycle t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.life_cycle AS life_cycle_2, t0.slug AS slug_3, t0.old_game_status_id AS old_game_status_id_4 FROM slith_gamelifecycle t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.life_cycle AS life_cycle_2, t0.slug AS slug_3, t0.old_game_status_id AS old_game_status_id_4 FROM slith_gamelifecycle t0 WHERE t0.id = 3;
0.09 ms (0.10%)	1	SELECT t0.id AS id_1, t0.contract_type AS contract_type_2, t0.label AS label_3, t0.style AS style_4, t0.shipping AS shipping_5, t0.old_contract_type_id AS old_contract_type_id_6, t0.slug AS slug_7, t0.super_contract_type_id AS super_contract_type_id_8 FROM slith_contracttype t0 WHERE t0.id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.contract_type AS contract_type_2, t0.label AS label_3, t0.style AS style_4, t0.shipping AS shipping_5, t0.old_contract_type_id AS old_contract_type_id_6, t0.slug AS slug_7, t0.super_contract_type_id AS super_contract_type_id_8 FROM slith_contracttype t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.contract_type AS contract_type_2, t0.label AS label_3, t0.style AS style_4, t0.shipping AS shipping_5, t0.old_contract_type_id AS old_contract_type_id_6, t0.slug AS slug_7, t0.super_contract_type_id AS super_contract_type_id_8 FROM slith_contracttype t0 WHERE t0.id = 12;
0.09 ms (0.10%)	1	SELECT t0.id AS id_1, t0.discount_method AS discount_method_2, t0.slug AS slug_3 FROM slith_discountmethod t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.discount_method AS discount_method_2, t0.slug AS slug_3 FROM slith_discountmethod t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.discount_method AS discount_method_2, t0.slug AS slug_3 FROM slith_discountmethod t0 WHERE t0.id = 1;
0.08 ms (0.09%)	1	SELECT s0_.id AS id_0, s0_.play_style AS play_style_1, s0_.old_play_style_id AS old_play_style_id_2 FROM slith_playstyle s0_ Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.play_style AS play_style_1, s0_.old_play_style_id AS old_play_style_id_2 FROM slith_playstyle s0_ SELECT s0_.id AS id_0, s0_.play_style AS play_style_1, s0_.old_play_style_id AS old_play_style_id_2 FROM slith_playstyle s0_;
0.08 ms (0.09%)	1	SELECT t0.id AS id_1, t0.status AS status_2, t0.slug AS slug_3 FROM slith_status t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.status AS status_2, t0.slug AS slug_3 FROM slith_status t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.status AS status_2, t0.slug AS slug_3 FROM slith_status t0 WHERE t0.id = 2;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Developer	107
App\Entity\DiscountContract	43
App\Entity\Product	34
App\Entity\GameContent	34
App\Entity\GameOptions	34
App\Entity\ProductGame	34
App\Entity\ProductArt	34
App\Entity\GamePlatform	23
App\Entity\GameContract	21
App\Entity\Platform	20
App\Entity\Timeline	17
App\Entity\Discount	16
App\Entity\Family	12
App\Entity\Genre	9
App\Entity\Theatre	7
App\Entity\Multiplayer	6
App\Entity\News	5
App\Entity\PlayStyle	5
App\Entity\Block	4
App\Entity\GameEdition	4
App\Entity\NotificationTrigger	4
App\Entity\Notification	4
App\Entity\GameLifeCycle	3
App\Entity\Difficulty	3
App\Entity\ProductType	3
App\Entity\GameEditor	3
App\Entity\UnitScale	3
App\Entity\Status	2
App\Entity\Helpdesk	2
App\Entity\Forum	2
App\Entity\BlockLocation	2
App\Entity\ArtificialIntelligence	2
App\Entity\Store	2
App\Entity\PurchaseMethod	2
App\Entity\Config	1
App\Entity\Language	1
App\Entity\Currency	1
App\Entity\User	1
App\Entity\Website	1
App\Entity\PbemServer	1
App\Entity\Newsletter	1
App\Entity\NewsletterProvider	1
App\Entity\GlobalAnnouncement	1
App\Entity\NewsZone	1
App\Entity\DiscountMethod	1
App\Entity\ContractType	1
App\Entity\ActionStatus	1
App\Entity\NotificationType	1
App\Entity\NotificationStatus	1
App\Entity\NotificationTemplate	1

Entities Mapping

Class	Mapping errors
App\Entity\WebServer	No errors.
App\Entity\Status	No errors.
App\Entity\Config	No errors.
App\Entity\Language	No errors.
App\Entity\Currency	The mappings App\Entity\Currency#bluesnapCountries and App\Entity\Country#bluesnapCurrency are inconsistent with each other.
App\Entity\User	No errors.
App\Entity\Helpdesk	No errors.
App\Entity\Website	No errors.
App\Entity\PbemServer	No errors.
App\Entity\PaymentCreditCard	No errors.
App\Entity\Newsletter	No errors.
App\Entity\NewsletterProvider	No errors.
App\Entity\Forum	No errors.
App\Entity\Product	No errors.
App\Entity\News	No errors.
App\Entity\Page	No errors.
App\Entity\BetaGame	No errors.
App\Entity\GlobalAnnouncement	No errors.
App\Entity\ProductViewLog	No errors.
App\Entity\Block	No errors.
App\Entity\GameContractMessage	No errors.
App\Entity\DiscountWebsiteImage	No errors.
App\Entity\GlobalVariable	No errors.
App\Entity\NotificationType	No errors.
App\Entity\Skin	No errors.
App\Entity\Mailing	No errors.
App\Entity\MailingTemplate	No errors.
App\Entity\BetaGameForumGroup	No errors.
App\Entity\CacheForumGroup	No errors.
App\Entity\ContactHelpdeskDepartment	No errors.
App\Entity\ProductUserWebsiteForumBadge	No errors.
App\Entity\Event	No errors.
App\Entity\WebsiteDomain	No errors.
App\Entity\NewsletterSubscriptionHistory	No errors.
App\Entity\BlockLocation	No errors.
App\Entity\NewsZone	No errors.
App\Entity\NewsRelation	No errors.
App\Entity\AudienceType	No errors.
App\Entity\NewsType	No errors.
App\Entity\GameLifeCycle	No errors.
App\Entity\ProductArt	No errors.
App\Entity\GamePlatform	No errors.
App\Entity\GameContent	No errors.
App\Entity\ProductBundle	No errors.
App\Entity\GameOptions	No errors.
App\Entity\Genre	No errors.
App\Entity\Timeline	No errors.
App\Entity\Theatre	No errors.
App\Entity\Difficulty	No errors.
App\Entity\PlayStyle	No errors.
App\Entity\ArtificialIntelligence	No errors.
App\Entity\GameEditor	No errors.
App\Entity\TurnScale	No errors.
App\Entity\Multiplayer	No errors.
App\Entity\UnitScale	No errors.
App\Entity\Manual	No errors.
App\Entity\GameScreen	No errors.
App\Entity\GameContract	No errors.
App\Entity\Family	No errors.
App\Entity\HotProduct	No errors.
App\Entity\ProductType	No errors.
App\Entity\ProductGame	No errors.
App\Entity\Developer	No errors.
App\Entity\UserGame	No errors.
App\Entity\Serial	No errors.
App\Entity\SteamKey	No errors.
App\Entity\SerialSummaryCache	No errors.
App\Entity\SteamKeySummaryCache	No errors.
App\Entity\ProUserGameLicense	No errors.
App\Entity\PlayFabLeaderboardCache	No errors.
App\Entity\PbemGame	No errors.
App\Entity\ProUserGameLicenseIssueCount	No errors.
App\Entity\LicenseQuote	No errors.
App\Entity\PingPBEMUserChallengeMessage	No errors.
App\Entity\OnlineStore	No errors.
App\Entity\GameVideo	No errors.
App\Entity\Download	No errors.
App\Entity\MediaReview	No errors.
App\Entity\DownloadLink	No errors.
App\Entity\Tournament	No errors.
App\Entity\Wishlist	No errors.
App\Entity\ProductViewCount	No errors.
App\Entity\UserProductLog	No errors.
App\Entity\Leaderboard	No errors.
App\Entity\LeaderboardProvider	No errors.
App\Entity\NotificationUser	No errors.
App\Entity\NotificationTrigger	No errors.
App\Entity\LauncherSale	No errors.
App\Entity\ProDownload	No errors.
App\Entity\OTRSQueue	No errors.
App\Entity\ProProduct	No errors.
App\Entity\ProProductPrice	No errors.
App\Entity\CrossSale	No errors.
App\Entity\Platform	No errors.
App\Entity\ProLicenseQuoteRequestLog	No errors.
App\Entity\ELORatingLeaderboard	No errors.
App\Entity\ContactProRequest	No errors.
App\Entity\GameSlide	No errors.
App\Entity\GameFAQ	No errors.
App\Entity\GameRequirements	No errors.
App\Entity\ProductUserMayLike	No errors.
App\Entity\ProductMerchandise	No errors.
App\Entity\MerchandiseType	No errors.
App\Entity\StreakFieldProduct	No errors.
App\Entity\StreakFieldProductType	No errors.
App\Entity\Discount	No errors.
App\Entity\DiscountMethod	No errors.
App\Entity\DiscountContract	No errors.
App\Entity\GameEdition	No errors.
App\Entity\Store	No errors.
App\Entity\JobPosting	No errors.
App\Entity\Dealer	No errors.
App\Entity\HttpLinkServer	No errors.
App\Entity\Coupon	No errors.
App\Entity\CouponCode	No errors.
App\Entity\StripeTaxRate	No errors.
App\Entity\EventTicket	No errors.
App\Entity\ProInstallationType	No errors.
App\Entity\ProLicenseMultiplayerServerType	No errors.
App\Entity\PurchaseMethod	No errors.
App\Entity\ContractType	No errors.
App\Entity\ShippingType	No errors.
App\Entity\ShoppingCartCoupon	No errors.
App\Entity\ShoppingCartItem	No errors.
App\Entity\CouponContract	No errors.
App\Entity\MerchandiseSize	No errors.
App\Entity\MerchandiseColor	No errors.
App\Entity\Notification	No errors.
App\Entity\ActionStatus	No errors.
App\Entity\Transaction	No errors.
App\Entity\NotificationStatus	No errors.
App\Entity\NotificationTemplate	No errors.
App\Entity\DiscountBundle	No errors.
App\Entity\CouponContractType	No errors.
App\Entity\Country	The association App\Entity\Country#bluesnapCurrency refers to the inverse side field App\Entity\Currency#blusnapCountries which does not exist.
App\Entity\CustomerInvoice	No errors.
App\Entity\BankAccount	No errors.
App\Entity\LicenseInvoice	No errors.
App\Entity\CustomInvoice	No errors.
App\Entity\CustomQuote	No errors.
App\Entity\CustomerQuote	No errors.

Symfony Profiler

GET https://www51.slitherine.com/inventory?coming-soon=exclude&discontinued=exclude&search=budget-games

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping