Symfony Profiler

Query Metrics

34 Database Queries

11 Different statements

16.80 ms Query time

0 Invalid entities

Queries


SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.slug = ? LIMIT 1
SELECT g0_.id AS id_0, g0_.unique_id AS unique_id_1, g0_.learning_locale AS learning_locale_2, g0_.title AS title_3, g0_.canonical_title AS canonical_title_4, g0_.slug AS slug_5, g0_.url AS url_6, g0_.tooltip AS tooltip_7, g0_.free AS free_8, g0_.free_until AS free_until_9, g0_.word_count AS word_count_10, g0_.mark AS mark_11, g0_.thumbnail AS thumbnail_12, g1_.id AS id_13, g2_.id AS id_14, g2_.position AS position_15, g2_.screenshot AS screenshot_16, g0_.config_id AS config_id_17, g0_.main_category_id AS main_category_id_18, g0_.main_theme_id AS main_theme_id_19, g0_.main_class_id AS main_class_id_20, g0_.hero_id AS hero_id_21, g0_.speaky_id AS speaky_id_22, g0_.original_game_id AS original_game_id_23, g2_.game_id AS game_id_24 FROM game g0_ LEFT JOIN game_config g1_ ON g0_.config_id = g1_.id LEFT JOIN game_screenshot g2_ ON g0_.id = g2_.game_id LEFT JOIN games_categories g4_ ON g0_.id = g4_.game_id LEFT JOIN category c3_ ON c3_.id = g4_.category_id LEFT JOIN games_themes g6_ ON g0_.id = g6_.game_id LEFT JOIN category c5_ ON c5_.id = g6_.category_id LEFT JOIN games_classes g8_ ON g0_.id = g8_.game_id LEFT JOIN category c7_ ON c7_.id = g8_.category_id WHERE g0_.published_at < CURRENT_TIMESTAMP AND g0_.learning_locale = ? AND (c3_.id = ? OR c5_.id = ? OR c7_.id = ?) GROUP BY g0_.id
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'speakyplanet-pp' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE        AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ?
SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1

#▲	Time	Info
1	0.31 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"cm2"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.slug = 'cm2' LIMIT 1;
2	8.23 ms	SELECT g0_.id AS id_0, g0_.unique_id AS unique_id_1, g0_.learning_locale AS learning_locale_2, g0_.title AS title_3, g0_.canonical_title AS canonical_title_4, g0_.slug AS slug_5, g0_.url AS url_6, g0_.tooltip AS tooltip_7, g0_.free AS free_8, g0_.free_until AS free_until_9, g0_.word_count AS word_count_10, g0_.mark AS mark_11, g0_.thumbnail AS thumbnail_12, g1_.id AS id_13, g2_.id AS id_14, g2_.position AS position_15, g2_.screenshot AS screenshot_16, g0_.config_id AS config_id_17, g0_.main_category_id AS main_category_id_18, g0_.main_theme_id AS main_theme_id_19, g0_.main_class_id AS main_class_id_20, g0_.hero_id AS hero_id_21, g0_.speaky_id AS speaky_id_22, g0_.original_game_id AS original_game_id_23, g2_.game_id AS game_id_24 FROM game g0_ LEFT JOIN game_config g1_ ON g0_.config_id = g1_.id LEFT JOIN game_screenshot g2_ ON g0_.id = g2_.game_id LEFT JOIN games_categories g4_ ON g0_.id = g4_.game_id LEFT JOIN category c3_ ON c3_.id = g4_.category_id LEFT JOIN games_themes g6_ ON g0_.id = g6_.game_id LEFT JOIN category c5_ ON c5_.id = g6_.category_id LEFT JOIN games_classes g8_ ON g0_.id = g8_.game_id LEFT JOIN category c7_ ON c7_.id = g8_.category_id WHERE g0_.published_at < CURRENT_TIMESTAMP AND g0_.learning_locale = ? AND (c3_.id = ? OR c5_.id = ? OR c7_.id = ?) GROUP BY g0_.id Parameters: [`"en" 50 50 50`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.unique_id AS unique_id_1, g0_.learning_locale AS learning_locale_2, g0_.title AS title_3, g0_.canonical_title AS canonical_title_4, g0_.slug AS slug_5, g0_.url AS url_6, g0_.tooltip AS tooltip_7, g0_.free AS free_8, g0_.free_until AS free_until_9, g0_.word_count AS word_count_10, g0_.mark AS mark_11, g0_.thumbnail AS thumbnail_12, g1_.id AS id_13, g2_.id AS id_14, g2_.position AS position_15, g2_.screenshot AS screenshot_16, g0_.config_id AS config_id_17, g0_.main_category_id AS main_category_id_18, g0_.main_theme_id AS main_theme_id_19, g0_.main_class_id AS main_class_id_20, g0_.hero_id AS hero_id_21, g0_.speaky_id AS speaky_id_22, g0_.original_game_id AS original_game_id_23, g2_.game_id AS game_id_24 FROM game g0_ LEFT JOIN game_config g1_ ON g0_.config_id = g1_.id LEFT JOIN game_screenshot g2_ ON g0_.id = g2_.game_id LEFT JOIN games_categories g4_ ON g0_.id = g4_.game_id LEFT JOIN category c3_ ON c3_.id = g4_.category_id LEFT JOIN games_themes g6_ ON g0_.id = g6_.game_id LEFT JOIN category c5_ ON c5_.id = g6_.category_id LEFT JOIN games_classes g8_ ON g0_.id = g8_.game_id LEFT JOIN category c7_ ON c7_.id = g8_.category_id WHERE g0_.published_at < CURRENT_TIMESTAMP AND g0_.learning_locale = ? AND ( c3_.id = ? OR c5_.id = ? OR c7_.id = ? ) GROUP BY g0_.id SELECT g0_.id AS id_0, g0_.unique_id AS unique_id_1, g0_.learning_locale AS learning_locale_2, g0_.title AS title_3, g0_.canonical_title AS canonical_title_4, g0_.slug AS slug_5, g0_.url AS url_6, g0_.tooltip AS tooltip_7, g0_.free AS free_8, g0_.free_until AS free_until_9, g0_.word_count AS word_count_10, g0_.mark AS mark_11, g0_.thumbnail AS thumbnail_12, g1_.id AS id_13, g2_.id AS id_14, g2_.position AS position_15, g2_.screenshot AS screenshot_16, g0_.config_id AS config_id_17, g0_.main_category_id AS main_category_id_18, g0_.main_theme_id AS main_theme_id_19, g0_.main_class_id AS main_class_id_20, g0_.hero_id AS hero_id_21, g0_.speaky_id AS speaky_id_22, g0_.original_game_id AS original_game_id_23, g2_.game_id AS game_id_24 FROM game g0_ LEFT JOIN game_config g1_ ON g0_.config_id = g1_.id LEFT JOIN game_screenshot g2_ ON g0_.id = g2_.game_id LEFT JOIN games_categories g4_ ON g0_.id = g4_.game_id LEFT JOIN category c3_ ON c3_.id = g4_.category_id LEFT JOIN games_themes g6_ ON g0_.id = g6_.game_id LEFT JOIN category c5_ ON c5_.id = g6_.category_id LEFT JOIN games_classes g8_ ON g0_.id = g8_.game_id LEFT JOIN category c7_ ON c7_.id = g8_.category_id WHERE g0_.published_at < CURRENT_TIMESTAMP AND g0_.learning_locale = 'en' AND (c3_.id = 50 OR c5_.id = 50 OR c7_.id = 50) GROUP BY g0_.id;
3	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
4	0.87 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"speakyplanet-pp"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'speakyplanet-pp' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
5	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
6	0.73 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"speakyplanet-pp"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'speakyplanet-pp' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
7	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
8	0.54 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"speakyplanet-pp" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'speakyplanet-pp' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
9	0.13 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
10	0.76 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'speakyplanet-pp' / ORDER BY k.ORDINAL_POSITION Parameters: [`"speakyplanet-pp" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'speakyplanet-pp' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'speakyplanet-pp' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'speakyplanet-pp' / ORDER BY k.ORDINAL_POSITION;
11	0.80 ms	SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"speakyplanet-pp" "speakyplanet-pp" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'speakyplanet-pp' AND t.TABLE_SCHEMA = 'speakyplanet-pp' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
12	0.10 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
13	0.40 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"speakyplanet-pp" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'speakyplanet-pp' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
14	0.12 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
15	0.09 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
16	0.19 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`58`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 58;
17	0.16 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`55`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 55;
18	0.20 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 22;
19	0.19 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 29;
20	0.16 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`26`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 26;
21	0.19 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 18;
22	0.16 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`25`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 25;
23	0.18 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`54`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 54;
24	0.18 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`19`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 19;
25	0.13 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 21;
26	0.16 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`24`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 24;
27	0.15 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`57`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 57;
28	0.15 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 28;
29	0.16 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`27`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 27;
30	0.15 ms	SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? Parameters: [`20`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.class_order AS class_order_2, t0.name AS name_3, t0.slug AS slug_4, t0.type AS type_5, t0.intro AS intro_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.games_count AS games_count_10, t0.popularity AS popularity_11, t0.published_games_count AS published_games_count_12, t0.app_published_games_count AS app_published_games_count_13, t0.image_height AS image_height_14, t0.thumbnail AS thumbnail_15, t0.mobile_thumbnail AS mobile_thumbnail_16, t0.weekly_trophy_thumbnail AS weekly_trophy_thumbnail_17 FROM category t0 WHERE t0.id = 20;
31	0.19 ms	SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1 Parameters: [`"cgv-jeu-anglais-vitamin-crew.html"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1 SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = 'cgv-jeu-anglais-vitamin-crew.html' LIMIT 1;
32	0.17 ms	SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1 Parameters: [`"cgv-fr"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1 SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = 'cgv-fr' LIMIT 1;
33	0.19 ms	SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1 Parameters: [`"confidentialite-jeu-anglais-vitamin-crew.html"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1 SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = 'confidentialite-jeu-anglais-vitamin-crew.html' LIMIT 1;
34	0.19 ms	SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1 Parameters: [`"confidentialite-fr"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = ? LIMIT 1 SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.title AS title_2, p0_.mobile_title AS mobile_title_3, p0_.url AS url_4, p0_.meta_description AS meta_description_5, p0_.route AS route_6, p0_.parent_route AS parent_route_7, p0_.parent_label AS parent_label_8, p0_.content AS content_9, p0_.keywords AS keywords_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.thumbnail AS thumbnail_13, p0_.mobile_thumbnail AS mobile_thumbnail_14 FROM page p0_ WHERE p0_.route = 'confidentialite-fr' LIMIT 1;

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.

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Game	No errors.
App\Entity\GameConfig	No errors.
App\Entity\GameScreenshot	No errors.
App\Entity\WeeklyHero	No errors.
App\Entity\Speaky	No errors.
App\Entity\GameComment	No errors.
App\Entity\GamePlay	No errors.
App\Entity\GameSound	No errors.
App\Entity\GameVote	No errors.
App\Entity\Trophie	No errors.
App\Entity\UserGameConfig	No errors.
App\Entity\GameFile	No errors.
App\Entity\SpeakyPart	No errors.
App\Entity\User	No errors.
App\Entity\GameWord	No errors.
App\Entity\Page	No errors.

Symfony Profiler

GET http://preprod.speakyplanet.fr/jeu-anglais-vitamin-crew.html/home_footer

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping