Query Metrics
25
Database Queries
4
Different statements
183.08 ms
Query time
0
Invalid entities
679
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
147.96 ms (80.82%) |
1 |
SELECT t0.id AS id_1, t0.gen_id AS gen_id_2, t0.base_id AS base_id_3, t0.old_id AS old_id_4, t0.token AS token_5, t0.infos AS infos_6, t0.cart AS cart_7, t0.result AS result_8, t0.status AS status_9, t0.state AS state_10, t0.payment_type AS payment_type_11, t0.amount AS amount_12, t0.amount_show AS amount_show_13, t0.options AS options_14, t0.transfered AS transfered_15, t0.mailed AS mailed_16, t0.mailed_pay AS mailed_pay_17, t0.mailed_count AS mailed_count_18, t0.exported AS exported_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.venue_title AS venue_title_22, t0.email_content AS email_content_23, t0.lang AS lang_24, t0.is_flash AS is_flash_25, t0.action AS action_26, t0.alerting AS alerting_27, t0.venue_id AS venue_id_28, t29.id AS id_30, t29.title AS title_31, t29.slug AS slug_32, t29.description AS description_33, t29.thumbnail AS thumbnail_34, t29.start AS start_35, t29.end AS end_36, t29.season AS season_37, t29.force_day AS force_day_38, t29.deleted AS deleted_39, t29.created_at AS created_at_40, t29.updated_at AS updated_at_41, t29.is_full AS is_full_42, t29.concert_id AS concert_id_43, t29.venue_type_id AS venue_type_id_44, t0.user_id AS user_id_45, t46.id AS id_47, t46.username AS username_48, t46.email AS email_49, t46.password AS password_50, t46.forgot AS forgot_51, t46.roles AS roles_52, t46.infos AS infos_53, t46.created_at AS created_at_54, t46.updated_at AS updated_at_55, t46.logged_at AS logged_at_56, t46.deleted AS deleted_57, t46.email_recap AS email_recap_58 FROM framework_booking t0 LEFT JOIN framework_venue t29 ON t0.venue_id = t29.id LEFT JOIN framework_user t46 ON t0.user_id = t46.id WHERE t0.token = ? LIMIT 1
Parameters:
[
"1761561975766"
]
|
|
19.03 ms (10.40%) |
2 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM framework_translation t0
Parameters:
[] |
|
15.08 ms (8.24%) |
21 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.url AS url_4, t0.content AS content_5, t0.is_home AS is_home_6, t0.is_cms AS is_cms_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM framework_page t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "reservation-payment" "fr" ] |
|
1.00 ms (0.55%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.thumbnail AS thumbnail_5, t0.season AS season_6, t0.position AS position_7, t0.food AS food_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM framework_venue_type t0 WHERE t0.id IN (?)
Parameters:
[
32
]
|
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\Framework\AppBundle\Entity\Translation | 659 |
| App\Framework\AppBundle\Entity\Page | 16 |
| App\Framework\AppBundle\Entity\Booking | 1 |
| App\Framework\AppBundle\Entity\Venue | 1 |
| App\Framework\AppBundle\Entity\VenueType | 1 |
| App\Framework\AppBundle\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Framework\AppBundle\Entity\Translation | No errors. |
| App\Framework\AppBundle\Entity\Page | No errors. |
| App\Framework\AppBundle\Entity\Booking | No errors. |
| App\Framework\AppBundle\Entity\Venue | No errors. |
| App\Framework\AppBundle\Entity\Concert | No errors. |
| App\Framework\AppBundle\Entity\VenueType | No errors. |
| App\Framework\AppBundle\Entity\User | No errors. |
| App\Framework\AppBundle\Entity\Places | No errors. |