Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

6.15 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
6.15 ms (100.00%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.subscription_count AS subscription_count_4, t0.comment AS comment_5, t0.description AS description_6, t0.cover AS cover_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.status_id AS status_id_10, t0.country_id AS country_id_11, t0.plan_type_id AS plan_type_id_12, t0.partner_id AS partner_id_13 FROM project t0 WHERE t0.id = ? Parameters: [`"172"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.subscription_count AS subscription_count_4, t0.comment AS comment_5, t0.description AS description_6, t0.cover AS cover_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.status_id AS status_id_10, t0.country_id AS country_id_11, t0.plan_type_id AS plan_type_id_12, t0.partner_id AS partner_id_13 FROM project t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.subscription_count AS subscription_count_4, t0.comment AS comment_5, t0.description AS description_6, t0.cover AS cover_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.status_id AS status_id_10, t0.country_id AS country_id_11, t0.plan_type_id AS plan_type_id_12, t0.partner_id AS partner_id_13 FROM project t0 WHERE t0.id = '172';

Time▼

Count

Info

6.15 ms
(100.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.subscription_count AS subscription_count_4, t0.comment AS comment_5, t0.description AS description_6, t0.cover AS cover_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.status_id AS status_id_10, t0.country_id AS country_id_11, t0.plan_type_id AS plan_type_id_12, t0.partner_id AS partner_id_13 FROM project t0 WHERE t0.id = ?

Parameters:

[
  "172"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.subscription_count AS subscription_count_4,
  t0.comment AS comment_5,
  t0.description AS description_6,
  t0.cover AS cover_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.status_id AS status_id_10,
  t0.country_id AS country_id_11,
  t0.plan_type_id AS plan_type_id_12,
  t0.partner_id AS partner_id_13
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.subscription_count AS subscription_count_4, t0.comment AS comment_5, t0.description AS description_6, t0.cover AS cover_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.status_id AS status_id_10, t0.country_id AS country_id_11, t0.plan_type_id AS plan_type_id_12, t0.partner_id AS partner_id_13 FROM project t0 WHERE t0.id = '172';

Database Connections

Name	Service
default	doctrine.dbal.default_connection
wordpress	doctrine.dbal.wordpress_connection
legacy	doctrine.dbal.legacy_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
wordpress	doctrine.orm.wordpress_entity_manager
legacy	doctrine.orm.legacy_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Project	No errors.
App\Entity\ProjectStatus	No errors.
App\Entity\Country	No errors.
App\Entity\PlanType	No errors.
App\Entity\Partner	No errors.
App\Entity\Plan	The association App\Entity\Plan#gifts refers to the owning side field App\Entity\Plan#plan which does not exist. The association App\Entity\Plan#reinvestmentPlans refers to the owning side field App\Entity\Gift#reinvestmentPlan which does not exist.
App\Entity\Peasant	No errors.
App\Entity\Loan	No errors.
App\Entity\Newsletter	No errors.

wordpress entity manager

No loaded entities.

legacy entity manager