Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.49 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	3.49 ms	SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.locale AS locale_2, s0_.url AS url_3, s0_.country_code AS country_code_4 FROM social_network_links s0_ WHERE s0_.country_code IS NULL AND s0_.locale = ? ORDER BY s0_.type ASC Parameters: [`"fr_CA"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.locale AS locale_2, s0_.url AS url_3, s0_.country_code AS country_code_4 FROM social_network_links s0_ WHERE s0_.country_code IS NULL AND s0_.locale = ? ORDER BY s0_.type ASC SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.locale AS locale_2, s0_.url AS url_3, s0_.country_code AS country_code_4 FROM social_network_links s0_ WHERE s0_.country_code IS NULL AND s0_.locale = 'fr_CA' ORDER BY s0_.type ASC;

#▲

Time

Info

3.49 ms

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.locale AS locale_2, s0_.url AS url_3, s0_.country_code AS country_code_4 FROM social_network_links s0_ WHERE s0_.country_code IS NULL AND s0_.locale = ? ORDER BY s0_.type ASC

Parameters:

[
  "fr_CA"
]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.locale AS locale_2,
  s0_.url AS url_3,
  s0_.country_code AS country_code_4
FROM
  social_network_links s0_
WHERE
  s0_.country_code IS NULL
  AND s0_.locale = ?
ORDER BY
  s0_.type ASC

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.locale AS locale_2, s0_.url AS url_3, s0_.country_code AS country_code_4 FROM social_network_links s0_ WHERE s0_.country_code IS NULL AND s0_.locale = 'fr_CA' ORDER BY s0_.type ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
game_transaction	doctrine.dbal.game_transaction_connection
vavadapart	doctrine.dbal.vavadapart_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
game_transaction	doctrine.orm.game_transaction_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\SocialNetworkLink	No errors.
App\Entity\Country	No errors.

game_transaction entity manager

No loaded entities.