Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

0.76 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.40 ms	SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = ? Parameters: [`"13"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = '13';
2	0.36 ms	SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = ? AND t0.approved = ? LIMIT 1 Parameters: [`13 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = ? AND t0.approved = ? LIMIT 1 SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = 13 AND t0.approved = 1 LIMIT 1;

#▲

Time

Info

0.40 ms

SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = ?

Parameters:

[
  "13"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.image AS image_3,
  t0.title_nl AS title_nl_4,
  t0.title_en AS title_en_5,
  t0.description_nl AS description_nl_6,
  t0.description_en AS description_en_7,
  t0.intro_nl AS intro_nl_8,
  t0.intro_en AS intro_en_9,
  t0.text_nl AS text_nl_10,
  t0.text_en AS text_en_11,
  t0.added AS added_12,
  t0.user_id AS user_id_13,
  t0.username AS username_14,
  t0.edited AS edited_15,
  t0.edited_user_id AS edited_user_id_16,
  t0.edited_username AS edited_username_17,
  t0.approved AS approved_18,
  t0.approved_user_id AS approved_user_id_19,
  t0.approved_username AS approved_username_20,
  t0.num_reviews AS num_reviews_21,
  t0.keywords_nl AS keywords_nl_22,
  t0.keywords_en AS keywords_en_23
FROM
  glossaries t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = '13';

0.36 ms

SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = ? AND t0.approved = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.image AS image_3,
  t0.title_nl AS title_nl_4,
  t0.title_en AS title_en_5,
  t0.description_nl AS description_nl_6,
  t0.description_en AS description_en_7,
  t0.intro_nl AS intro_nl_8,
  t0.intro_en AS intro_en_9,
  t0.text_nl AS text_nl_10,
  t0.text_en AS text_en_11,
  t0.added AS added_12,
  t0.user_id AS user_id_13,
  t0.username AS username_14,
  t0.edited AS edited_15,
  t0.edited_user_id AS edited_user_id_16,
  t0.edited_username AS edited_username_17,
  t0.approved AS approved_18,
  t0.approved_user_id AS approved_user_id_19,
  t0.approved_username AS approved_username_20,
  t0.num_reviews AS num_reviews_21,
  t0.keywords_nl AS keywords_nl_22,
  t0.keywords_en AS keywords_en_23
FROM
  glossaries t0
WHERE
  t0.id = ?
  AND t0.approved = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.image AS image_3, t0.title_nl AS title_nl_4, t0.title_en AS title_en_5, t0.description_nl AS description_nl_6, t0.description_en AS description_en_7, t0.intro_nl AS intro_nl_8, t0.intro_en AS intro_en_9, t0.text_nl AS text_nl_10, t0.text_en AS text_en_11, t0.added AS added_12, t0.user_id AS user_id_13, t0.username AS username_14, t0.edited AS edited_15, t0.edited_user_id AS edited_user_id_16, t0.edited_username AS edited_username_17, t0.approved AS approved_18, t0.approved_user_id AS approved_user_id_19, t0.approved_username AS approved_username_20, t0.num_reviews AS num_reviews_21, t0.keywords_nl AS keywords_nl_22, t0.keywords_en AS keywords_en_23 FROM glossaries t0 WHERE t0.id = 13 AND t0.approved = 1 LIMIT 1;

forumdb connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
forumdb	doctrine.dbal.forumdb_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
forumdb	doctrine.orm.forumdb_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Glossaries	No errors.
App\Entity\GlossaryReviews	No errors.

forumdb entity manager

No loaded entities.