Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.81 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.81 ms

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.order_number AS order_number_3, t0.created_on AS created_on_4, t0.modified_on AS modified_on_5, t0.channel AS channel_6, t0.testmode AS testmode_7, t0.customer_email AS customer_email_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.address1 AS address1_11, t0.address2 AS address2_12, t0.city AS city_13, t0.state AS state_14, t0.country_code AS country_code_15, t0.postalcode AS postalcode_16, t0.phone AS phone_17, t0.shipping_address AS shipping_address_18, t0.fulfillment_status AS fulfillment_status_19, t0.internal_notes AS internal_notes_20, t0.shipping_lines AS shipping_lines_21, t0.discount_lines AS discount_lines_22, t0.form_submission AS form_submission_23, t0.fulfillments AS fulfillments_24, t0.subtotal_currency AS subtotal_currency_25, t0.subtotal AS subtotal_26, t0.shipping_total AS shipping_total_27, t0.discount_total AS discount_total_28, t0.tax_total AS tax_total_29, t0.refunded_total AS refunded_total_30, t0.grand_total_currency AS grand_total_currency_31, t0.grand_total AS grand_total_32, t0.channel_name AS channel_name_33, t0.eternal_order_reference AS eternal_order_reference_34, t0.fulfilled_on AS fulfilled_on_35, t0.price_tax_interpretation AS price_tax_interpretation_36, t0.shipping_total_currency AS shipping_total_currency_37, t0.discount_total_currency AS discount_total_currency_38, t0.tax_total_currency AS tax_total_currency_39, t0.refunded_total_currency AS refunded_total_currency_40, t0.is_vip AS is_vip_41, t0.date_from AS date_from_42, t0.date_to AS date_to_43, t0.quantity AS quantity_44, t0.product_name AS product_name_45, t0.product_date AS product_date_46, t0.jotform_submission_id AS jotform_submission_id_47 FROM onsite_ticket t0 WHERE t0.id = ?

Parameters:

[
  "batch-delete"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.order_id AS order_id_2,
  t0.order_number AS order_number_3,
  t0.created_on AS created_on_4,
  t0.modified_on AS modified_on_5,
  t0.channel AS channel_6,
  t0.testmode AS testmode_7,
  t0.customer_email AS customer_email_8,
  t0.first_name AS first_name_9,
  t0.last_name AS last_name_10,
  t0.address1 AS address1_11,
  t0.address2 AS address2_12,
  t0.city AS city_13,
  t0.state AS state_14,
  t0.country_code AS country_code_15,
  t0.postalcode AS postalcode_16,
  t0.phone AS phone_17,
  t0.shipping_address AS shipping_address_18,
  t0.fulfillment_status AS fulfillment_status_19,
  t0.internal_notes AS internal_notes_20,
  t0.shipping_lines AS shipping_lines_21,
  t0.discount_lines AS discount_lines_22,
  t0.form_submission AS form_submission_23,
  t0.fulfillments AS fulfillments_24,
  t0.subtotal_currency AS subtotal_currency_25,
  t0.subtotal AS subtotal_26,
  t0.shipping_total AS shipping_total_27,
  t0.discount_total AS discount_total_28,
  t0.tax_total AS tax_total_29,
  t0.refunded_total AS refunded_total_30,
  t0.grand_total_currency AS grand_total_currency_31,
  t0.grand_total AS grand_total_32,
  t0.channel_name AS channel_name_33,
  t0.eternal_order_reference AS eternal_order_reference_34,
  t0.fulfilled_on AS fulfilled_on_35,
  t0.price_tax_interpretation AS price_tax_interpretation_36,
  t0.shipping_total_currency AS shipping_total_currency_37,
  t0.discount_total_currency AS discount_total_currency_38,
  t0.tax_total_currency AS tax_total_currency_39,
  t0.refunded_total_currency AS refunded_total_currency_40,
  t0.is_vip AS is_vip_41,
  t0.date_from AS date_from_42,
  t0.date_to AS date_to_43,
  t0.quantity AS quantity_44,
  t0.product_name AS product_name_45,
  t0.product_date AS product_date_46,
  t0.jotform_submission_id AS jotform_submission_id_47
FROM
  onsite_ticket t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.order_number AS order_number_3, t0.created_on AS created_on_4, t0.modified_on AS modified_on_5, t0.channel AS channel_6, t0.testmode AS testmode_7, t0.customer_email AS customer_email_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.address1 AS address1_11, t0.address2 AS address2_12, t0.city AS city_13, t0.state AS state_14, t0.country_code AS country_code_15, t0.postalcode AS postalcode_16, t0.phone AS phone_17, t0.shipping_address AS shipping_address_18, t0.fulfillment_status AS fulfillment_status_19, t0.internal_notes AS internal_notes_20, t0.shipping_lines AS shipping_lines_21, t0.discount_lines AS discount_lines_22, t0.form_submission AS form_submission_23, t0.fulfillments AS fulfillments_24, t0.subtotal_currency AS subtotal_currency_25, t0.subtotal AS subtotal_26, t0.shipping_total AS shipping_total_27, t0.discount_total AS discount_total_28, t0.tax_total AS tax_total_29, t0.refunded_total AS refunded_total_30, t0.grand_total_currency AS grand_total_currency_31, t0.grand_total AS grand_total_32, t0.channel_name AS channel_name_33, t0.eternal_order_reference AS eternal_order_reference_34, t0.fulfilled_on AS fulfilled_on_35, t0.price_tax_interpretation AS price_tax_interpretation_36, t0.shipping_total_currency AS shipping_total_currency_37, t0.discount_total_currency AS discount_total_currency_38, t0.tax_total_currency AS tax_total_currency_39, t0.refunded_total_currency AS refunded_total_currency_40, t0.is_vip AS is_vip_41, t0.date_from AS date_from_42, t0.date_to AS date_to_43, t0.quantity AS quantity_44, t0.product_name AS product_name_45, t0.product_date AS product_date_46, t0.jotform_submission_id AS jotform_submission_id_47 FROM onsite_ticket t0 WHERE t0.id = 'batch-delete';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 146)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 111)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 254)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 65)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 141)
12	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequestPrettyUrls (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\OnsiteTicket	No errors.

Symfony Profiler

GET https://registration.genevasupercarshow.com/onsite-ticket/batch-delete?page=3&sort%5Bcity%5D=DESC

Configuration Settings

Theme

Page Width