Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.23 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.97 ms (88.53%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.language AS language_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM gender t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"qys"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.language AS language_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM gender t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.language AS language_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM gender t0 WHERE t0.name = 'qys' LIMIT 1;
0.26 ms (11.47%)	1	SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4 FROM PAGE p0_ WHERE p0_.slug = ? ORDER BY p0_.id DESC LIMIT 1 Parameters: [`"page_home_en"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4 FROM PAGE p0_ WHERE p0_.slug = ? ORDER BY p0_.id DESC LIMIT 1 SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4 FROM PAGE p0_ WHERE p0_.slug = 'page_home_en' ORDER BY p0_.id DESC LIMIT 1;

Time▼

Count

Info

1.97 ms
(88.53%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.language AS language_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM gender t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "qys"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.gender AS gender_3,
  t0.language AS language_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  gender t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.language AS language_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM gender t0 WHERE t0.name = 'qys' LIMIT 1;

0.26 ms
(11.47%)

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4 FROM PAGE p0_ WHERE p0_.slug = ? ORDER BY p0_.id DESC LIMIT 1

Parameters:

[
  "page_home_en"
]

View formatted query View runnable query Explain query

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.content AS content_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4
FROM
  PAGE p0_
WHERE
  p0_.slug = ?
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4 FROM PAGE p0_ WHERE p0_.slug = 'page_home_en' ORDER BY p0_.id DESC 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\Gender	No errors.
App\Entity\Page	No errors.

Symfony Profiler

https://gbt.inkylab.com/en/api/v1/guess-gender/qys

Configuration Settings

Theme