Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

1.18 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.34 ms	SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = ? Parameters: [`null`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = ? SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = NULL;
2	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.campus_id AS campus_id_4, t0.department_id AS department_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_school_id AS user_school_id_8 FROM user_major t0 WHERE t0.user_school_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.campus_id AS campus_id_4, t0.department_id AS department_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_school_id AS user_school_id_8 FROM user_major t0 WHERE t0.user_school_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.campus_id AS campus_id_4, t0.department_id AS department_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_school_id AS user_school_id_8 FROM user_major t0 WHERE t0.user_school_id = 1;
3	0.34 ms	SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = ? Parameters: [`null`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = ? SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = NULL;

#▲

Time

Info

0.34 ms

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = ?

Parameters:

[
  null
]

View formatted query View runnable query Explain query

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.active AS active_2,
  u0_.tax AS tax_3,
  u0_.bookstore_id AS bookstore_id_4,
  u0_.created_at AS created_at_5,
  u0_.updated_at AS updated_at_6,
  u0_.school_settings_id AS school_settings_id_7,
  u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8
FROM
  user_school u0_
WHERE
  u0_.active = 1
  OR u0_.id = ?

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = NULL;

0.50 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.campus_id AS campus_id_4, t0.department_id AS department_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_school_id AS user_school_id_8 FROM user_major t0 WHERE t0.user_school_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.campus_id AS campus_id_4,
  t0.department_id AS department_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.user_school_id AS user_school_id_8
FROM
  user_major t0
WHERE
  t0.user_school_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.campus_id AS campus_id_4, t0.department_id AS department_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_school_id AS user_school_id_8 FROM user_major t0 WHERE t0.user_school_id = 1;

0.34 ms

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = ?

Parameters:

[
  null
]

View formatted query View runnable query Explain query

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.active AS active_2,
  u0_.tax AS tax_3,
  u0_.bookstore_id AS bookstore_id_4,
  u0_.created_at AS created_at_5,
  u0_.updated_at AS updated_at_6,
  u0_.school_settings_id AS school_settings_id_7,
  u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8
FROM
  user_school u0_
WHERE
  u0_.active = 1
  OR u0_.id = ?

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = NULL;

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
FMT\Data\Entity\Transaction	No errors.
FMT\Data\Entity\UserTransaction	No errors.
FOS\UserBundle\Model\User	No errors.
FMT\Data\Entity\User	No errors.
FMT\Data\Entity\Order	No errors.
FMT\Data\Entity\UserStatistic	No errors.
FMT\Data\Entity\UserSchool	No errors.
FMT\Data\Entity\Campaign	No errors.
FMT\Data\Entity\UserContact	No errors.
FMT\Data\Entity\UserNotifications	No errors.
FMT\Data\Entity\UserMajor	No errors.
FMT\Data\Entity\DwollaEvent	No errors.
FMT\Data\Entity\BookstoreTransfer	No errors.
FMT\Data\Entity\UserSchoolSettings	No errors.
FMT\Data\Entity\UserSchoolTransferAttempts	No errors.
FMT\Data\Entity\UserProfile	No errors.

Symfony Profiler

https://app.fundmytextbooks.com/sign-up

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping