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

Query Metrics

19 Database Queries
10 Different statements
6.38 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.59 ms
(24.95%)
2
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "speakyplanet-pp"
]
0.86 ms
(13.46%)
1
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"
]
0.75 ms
(11.68%)
4
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"
]
0.74 ms
(11.65%)
1
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"
]
0.73 ms
(11.43%)
6
SELECT DATABASE()
Parameters:
[]
0.51 ms
(8.00%)
1
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.learning_locale AS learning_locale_3, t0.flash_game AS flash_game_4, t0.app_game AS app_game_5, t0.v3_wrapper AS v3_wrapper_6, t0.html5 AS html5_7, t0.challenge_banned AS challenge_banned_8, t0.engine AS engine_9, t0.client_display AS client_display_10, t0.min_app_version AS min_app_version_11, t0.available_small AS available_small_12, t0.available_medium AS available_medium_13, t0.title AS title_14, t0.newsletter_subject AS newsletter_subject_15, t0.learn_title AS learn_title_16, t0.dico_title AS dico_title_17, t0.canonical_title AS canonical_title_18, t0.slug AS slug_19, t0.url AS url_20, t0.app_intro AS app_intro_21, t0.intro AS intro_22, t0.description AS description_23, t0.tooltip AS tooltip_24, t0.video_id AS video_id_25, t0.published_at AS published_at_26, t0.app_published_at AS app_published_at_27, t0.published_at_de AS published_at_de_28, t0.app_published_at_de AS app_published_at_de_29, t0.published_at_es AS published_at_es_30, t0.app_published_at_es AS app_published_at_es_31, t0.published_at_it AS published_at_it_32, t0.app_published_at_it AS app_published_at_it_33, t0.free AS free_34, t0.free_until AS free_until_35, t0.infos AS infos_36, t0.limited_message AS limited_message_37, t0.serialized_help_ids AS serialized_help_ids_38, t0.popularity AS popularity_39, t0.month_popularity AS month_popularity_40, t0.sheet_count AS sheet_count_41, t0.word_count AS word_count_42, t0.newsletterword_count AS newsletterword_count_43, t0.mark AS mark_44, t0.last_modif AS last_modif_45, t0.serialized_app_help_ids AS serialized_app_help_ids_46, t0.created_at AS created_at_47, t0.updated_at AS updated_at_48, t0.newsletter AS newsletter_49, t0.thumbnail AS thumbnail_50, t0.challenge_home_thumbnail AS challenge_home_thumbnail_51, t0.challenge_popin_thumbnail AS challenge_popin_thumbnail_52, t0.sheet AS sheet_53, t0.grammar AS grammar_54, t0.extra_sheet AS extra_sheet_55, t0.sheet_title AS sheet_title_56, t0.sheet_small_title AS sheet_small_title_57, t0.sheet_thumbnail AS sheet_thumbnail_58, t0.assets_file AS assets_file_59, t0.swf AS swf_60, t0.help_swf AS help_swf_61, t0.app_help_swf AS app_help_swf_62, t0.config_id AS config_id_63, t0.main_category_id AS main_category_id_64, t0.main_theme_id AS main_theme_id_65, t0.main_class_id AS main_class_id_66, t0.hero_id AS hero_id_67, t0.speaky_id AS speaky_id_68, t0.original_game_id AS original_game_id_69 FROM game t0 WHERE t0.canonical_title = ? LIMIT 1
Parameters:
[
  "la-salle-a-manger"
]
0.50 ms
(7.82%)
1
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"
]
0.40 ms
(6.30%)
1
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"
]
0.18 ms
(2.76%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.screenshot AS screenshot_3, t0.game_id AS game_id_4 FROM game_screenshot t0 WHERE t0.game_id = ?
Parameters:
[
  61
]
0.12 ms
(1.94%)
1
SELECT * FROM doctrine_migration_versions
Parameters:
[]

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\Game No errors.
App\Entity\GameConfig No errors.
App\Entity\Category No errors.
App\Entity\WeeklyHero No errors.
App\Entity\Speaky No errors.
App\Entity\GameComment No errors.
App\Entity\GamePlay No errors.
App\Entity\GameScreenshot 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.