Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

5.01 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

customer connection

#▲	Time	Info
1	0.69 ms	SELECT dbname FROM saas_instance WHERE hostname = ? LIMIT 1 Parameters: [`"app.gymplusoptimal.com"`] View formatted query View runnable query Explain query SELECT dbname FROM saas_instance WHERE hostname = ? LIMIT 1 SELECT dbname FROM saas_instance WHERE hostname = 'app.gymplusoptimal.com' LIMIT 1;
2	0.68 ms	SELECT dbname FROM saas_instance WHERE hostname = ? LIMIT 1 Parameters: [`"app.gymplusoptimal.com"`] View formatted query View runnable query Explain query SELECT dbname FROM saas_instance WHERE hostname = ? LIMIT 1 SELECT dbname FROM saas_instance WHERE hostname = 'app.gymplusoptimal.com' LIMIT 1;

#▲

Time

Info

0.69 ms

SELECT dbname FROM saas_instance WHERE hostname = ? LIMIT 1

Parameters:

[
  "app.gymplusoptimal.com"
]

View formatted query View runnable query Explain query

SELECT
  dbname
FROM
  saas_instance
WHERE
  hostname = ?
LIMIT
  1

SELECT dbname FROM saas_instance WHERE hostname = 'app.gymplusoptimal.com' LIMIT 1;

0.68 ms

SELECT dbname FROM saas_instance WHERE hostname = ? LIMIT 1

Parameters:

[
  "app.gymplusoptimal.com"
]

View formatted query View runnable query Explain query

SELECT
  dbname
FROM
  saas_instance
WHERE
  hostname = ?
LIMIT
  1

SELECT dbname FROM saas_instance WHERE hostname = 'app.gymplusoptimal.com' LIMIT 1;

default connection


USE `gym_prod_topline`
USE `gym_prod_topline`
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()

#▲	Time	Info
1	0.33 ms	USE `gym_prod_topline` Parameters: [] View formatted query View runnable query Explain query USE `gym_prod_topline` USE `gym_prod_topline`;
2	0.28 ms	USE `gym_prod_topline` Parameters: [] View formatted query View runnable query Explain query USE `gym_prod_topline` USE `gym_prod_topline`;
3	0.51 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
4	2.02 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"gym_prod_topline"`] 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 = 'gym_prod_topline' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
5	0.50 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Database Connections

Name	Service
default	doctrine.dbal.default_connection
customer	doctrine.dbal.customer_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
customer	doctrine.orm.customer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

customer entity manager

Class	Amount of managed objects

Symfony Profiler

GET https://app.gymplusoptimal.com/node/.env

Query Metrics

Queries

customer connection

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

customer entity manager

Entities Mapping

default entity manager

customer entity manager

GET https://app.gymplusoptimal.com/node/.env

Configuration Settings

Theme

Page Width

Query Metrics

Queries

customer connection

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

customer entity manager

Entities Mapping

default entity manager

customer entity manager