Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

9.35 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	4.74 ms	SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = ?) AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1 Parameters: [`"error_."`] View formatted query View runnable query Explain query SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = ?) AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1 SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = 'error_.') AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1;
2	4.61 ms	SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = ?) AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1 Parameters: [`"."`] View formatted query View runnable query Explain query SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = ?) AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1 SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = '.') AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1;

#▲

Time

Info

4.74 ms

SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = ?) AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1

Parameters:

[
  "error_."
]

View formatted query View runnable query Explain query

SELECT
  u0_.created AS created_0,
  u0_.modified AS modified_1,
  u0_.id AS id_2,
  u0_.action AS action_3,
  u0_.description AS description_4,
  u0_.ip_address AS ip_address_5,
  u0_.is_successful AS is_successful_6,
  u0_.type AS type_7,
  u0_.deleted AS deleted_8,
  u0_.user_id AS user_id_9,
  u0_.session_id AS session_id_10
FROM
  user_action u0_
WHERE
  (u0_.action = ?)
  AND (u0_.deleted IS NULL)
ORDER BY
  u0_.id DESC
LIMIT
  1

SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = 'error_.') AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1;

4.61 ms

SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = ?) AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1

Parameters:

[
  "."
]

View formatted query View runnable query Explain query

SELECT
  u0_.created AS created_0,
  u0_.modified AS modified_1,
  u0_.id AS id_2,
  u0_.action AS action_3,
  u0_.description AS description_4,
  u0_.ip_address AS ip_address_5,
  u0_.is_successful AS is_successful_6,
  u0_.type AS type_7,
  u0_.deleted AS deleted_8,
  u0_.user_id AS user_id_9,
  u0_.session_id AS session_id_10
FROM
  user_action u0_
WHERE
  (u0_.action = ?)
  AND (u0_.deleted IS NULL)
ORDER BY
  u0_.id DESC
LIMIT
  1

SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = '.') AND (u0_.deleted IS NULL) ORDER BY u0_.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
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\BaseEntity	No errors.
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\User\UserAction	No errors.
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\User\User	No errors.
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\User\UserSession	No errors.
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\Customer\Customer	No errors.
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\Country	No errors.
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\User\ChangeProfileRequest	No errors.
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\About\TermsAndConditions	No errors.
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\About\PrivacyPolicy	No errors.
LaunchPad\Bundle\LaunchPadBundle\Base\Service\Processor\XTM\Entity\XtmAdditionalUserData	The field LaunchPad\Bundle\LaunchPadBundle\Base\Service\Processor\XTM\Entity\XtmAdditionalUserData#user is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity LaunchPad\Bundle\LaunchPadBundle\Base\Entity\User\User# does not contain the required 'inversedBy' attribute.
LaunchPad\Bundle\LaunchPadBundle\Base\Entity\User\UserDevice	No errors.

Symfony Profiler

http://backend-kabn.dev.pannovate.net/robots.txt

Configuration Settings

Theme