POST https://admin.escal-hatoup.klerthis.net/tour/8/managesteps

Query Metrics

13 Database Queries
8 Different statements
5.67 ms Query time
2 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone AS phone_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.publicurl AS publicurl_3, t0.adminurl AS adminurl_4, t0.address AS address_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.logofilename AS logofilename_9, t0.faviconfilename AS faviconfilename_10, t0.email AS email_11, t0.updated_at AS updated_at_12, t0.siret AS siret_13, t0.naf AS naf_14, t0.vatnumber AS vatnumber_15, t0.companyname AS companyname_16, t0.rcs AS rcs_17, t0.theme AS theme_18, t0.paymentsolution AS paymentsolution_19 FROM company t0 LIMIT 1
Parameters:
[]
3 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.publicurl AS publicurl_3, t0.adminurl AS adminurl_4, t0.address AS address_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.logofilename AS logofilename_9, t0.faviconfilename AS faviconfilename_10, t0.email AS email_11, t0.updated_at AS updated_at_12, t0.siret AS siret_13, t0.naf AS naf_14, t0.vatnumber AS vatnumber_15, t0.companyname AS companyname_16, t0.rcs AS rcs_17, t0.theme AS theme_18, t0.paymentsolution AS paymentsolution_19 FROM company t0 LIMIT 1
Parameters:
[]
4 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.publicurl AS publicurl_3, t0.adminurl AS adminurl_4, t0.address AS address_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.logofilename AS logofilename_9, t0.faviconfilename AS faviconfilename_10, t0.email AS email_11, t0.updated_at AS updated_at_12, t0.siret AS siret_13, t0.naf AS naf_14, t0.vatnumber AS vatnumber_15, t0.companyname AS companyname_16, t0.rcs AS rcs_17, t0.theme AS theme_18, t0.paymentsolution AS paymentsolution_19 FROM company t0 LIMIT 1
Parameters:
[]
5 0.24 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
6 0.31 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.tour_id = ? ORDER BY t0.time ASC
Parameters:
[
  8
]
7 0.43 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.id = ? AND t0.tour_id = ? LIMIT 1
Parameters:
[
  "36"
  8
]
8 0.32 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.id = ? AND t0.tour_id = ? LIMIT 1
Parameters:
[
  "33"
  8
]
9 0.22 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.id = ? AND t0.tour_id = ? LIMIT 1
Parameters:
[
  "34"
  8
]
10 0.18 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.id = ? AND t0.tour_id = ? LIMIT 1
Parameters:
[
  "35"
  8
]
11 0.17 ms
"START TRANSACTION"
Parameters:
[]
12 0.54 ms
DELETE FROM step WHERE id = ?
Parameters:
[
  36
]
13 2.43 ms
"COMMIT"
Parameters:
[]

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
App\Entity\Step 3
App\Entity\Pier 3
App\Entity\User 1
App\Entity\Company 1
App\Entity\Tour 1
App\Entity\Service 1
App\Entity\Boat 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Userparam No errors.
App\Entity\Booking
  • The mappings App\Entity\Booking#retailer and App\Entity\User#bookings are inconsistent with each other.
App\Entity\Order
  • The mappings App\Entity\Order#retailer and App\Entity\User#orders are inconsistent with each other.
App\Entity\Company No errors.
App\Entity\Tour No errors.
App\Entity\Service No errors.
App\Entity\Boat No errors.
App\Entity\Pricetype No errors.
App\Entity\Step No errors.
App\Entity\Tourday No errors.
App\Entity\Option No errors.
App\Entity\Pier No errors.