Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.69 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.69 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.theme AS theme_4, t0.order_confirmation_recipients AS order_confirmation_recipients_5, t0.website AS website_6, t0.address AS address_7, t0.company AS company_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM site t0 WHERE t0.id = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.theme AS theme_4, t0.order_confirmation_recipients AS order_confirmation_recipients_5, t0.website AS website_6, t0.address AS address_7, t0.company AS company_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM site t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.theme AS theme_4, t0.order_confirmation_recipients AS order_confirmation_recipients_5, t0.website AS website_6, t0.address AS address_7, t0.company AS company_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM site t0 WHERE t0.id = 1 LIMIT 1;

#▲

Time

Info

0.69 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.theme AS theme_4, t0.order_confirmation_recipients AS order_confirmation_recipients_5, t0.website AS website_6, t0.address AS address_7, t0.company AS company_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM site t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.logo AS logo_3,
  t0.theme AS theme_4,
  t0.order_confirmation_recipients AS order_confirmation_recipients_5,
  t0.website AS website_6,
  t0.address AS address_7,
  t0.company AS company_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  site t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.theme AS theme_4, t0.order_confirmation_recipients AS order_confirmation_recipients_5, t0.website AS website_6, t0.address AS address_7, t0.company AS company_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM site t0 WHERE t0.id = 1 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
Roothirsch\CoreBundle\Translation\Entity\Language	No errors.
Roothirsch\CoreBundle\FeatureFlag\Entity\FeatureFlag	No errors.
Roothirsch\CoreBundle\Site\Entity\Site	No errors.
Roothirsch\CoreBundle\Entity\User	No errors.
Roothirsch\CoreBundle\Entity\Group	No errors.
Roothirsch\CoreBundle\Translation\Entity\TranslationScope	The mappings Roothirsch\CoreBundle\Translation\Entity\TranslationScope#units and Roothirsch\CoreBundle\Translation\Entity\TranslationUnit#scope are inconsistent with each other.
Roothirsch\ShopBundle\Entity\Order	No errors.

Symfony Profiler

https://int.my.stf-lizenzsystem.de/api/shop/orders?limit=30&page=1&state=ordered

Configuration Settings

Theme