Query Metrics
6
Database Queries
5
Different statements
41.75 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.maintenance_mode AS maintenance_mode_3, t0.maintenance_title AS maintenance_title_4, t0.maintenance_subtitle AS maintenance_subtitle_5, t0.maintenance_text AS maintenance_text_6, t0.checkin_threshold_before AS checkin_threshold_before_7, t0.checkin_threshold_after AS checkin_threshold_after_8, t0.maximum_web_sales AS maximum_web_sales_9, t0.expire_web_sales AS expire_web_sales_10, t0.agenda AS agenda_11, t0.show_agenda AS show_agenda_12, t0.advice_title AS advice_title_13, t0.advice_content AS advice_content_14, t0.show_advice AS show_advice_15 FROM tkt_setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"lugo"
]
|
| 2 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.maintenance_mode AS maintenance_mode_3, t0.maintenance_title AS maintenance_title_4, t0.maintenance_subtitle AS maintenance_subtitle_5, t0.maintenance_text AS maintenance_text_6, t0.checkin_threshold_before AS checkin_threshold_before_7, t0.checkin_threshold_after AS checkin_threshold_after_8, t0.maximum_web_sales AS maximum_web_sales_9, t0.expire_web_sales AS expire_web_sales_10, t0.agenda AS agenda_11, t0.show_agenda AS show_agenda_12, t0.advice_title AS advice_title_13, t0.advice_content AS advice_content_14, t0.show_advice AS show_advice_15 FROM tkt_setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"lugo"
]
|
| 3 | 37.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.subtitle AS subtitle_3, t0.description AS description_4, t0.length AS length_5, t0.`interval` AS interval_6, t0.customNamePlace AS customNamePlace_7, t0.customUrlMapPlace AS customUrlMapPlace_8, t0.discount AS discount_9, t0.discountText AS discountText_10, t0.image AS image_11, t0.banner AS banner_12, t0.numbered AS numbered_13, t0.free AS free_14, t0.sale_by_box_office AS sale_by_box_office_15, t0.public_on_box_office AS public_on_box_office_16, t0.sale_by_web AS sale_by_web_17, t0.public_on_web AS public_on_web_18, t0.status AS status_19, t0.active AS active_20, t0.`external` AS external_21, t0.external_place AS external_place_22, t0.external_address AS external_address_23, t0.external_url AS external_url_24, t0.external_price AS external_price_25, t0.slug AS slug_26, t0.publish_at AS publish_at_27, t0.start_selling_at AS start_selling_at_28, t0.created_at AS created_at_29, t0.update_at AS update_at_30, t0.not_show AS not_show_31, t0.campaign_id AS campaign_id_32, t0.place_id AS place_id_33, t0.type_id AS type_id_34, t0.ticket_layout_id AS ticket_layout_id_35, t0.scheduling_id AS scheduling_id_36 FROM tkt_event t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"test-entradas"
]
|
| 4 | 1.91 ms |
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.status AS status_3, t0.active AS active_4, t0.sale_open AS sale_open_5, t0.total_reservations_sold AS total_reservations_sold_6, t0.total_reservations AS total_reservations_7, t0.event_id AS event_id_8, t9.id AS id_10, t9.name AS name_11, t9.subtitle AS subtitle_12, t9.description AS description_13, t9.length AS length_14, t9.`interval` AS interval_15, t9.customNamePlace AS customNamePlace_16, t9.customUrlMapPlace AS customUrlMapPlace_17, t9.discount AS discount_18, t9.discountText AS discountText_19, t9.image AS image_20, t9.banner AS banner_21, t9.numbered AS numbered_22, t9.free AS free_23, t9.sale_by_box_office AS sale_by_box_office_24, t9.public_on_box_office AS public_on_box_office_25, t9.sale_by_web AS sale_by_web_26, t9.public_on_web AS public_on_web_27, t9.status AS status_28, t9.active AS active_29, t9.`external` AS external_30, t9.external_place AS external_place_31, t9.external_address AS external_address_32, t9.external_url AS external_url_33, t9.external_price AS external_price_34, t9.slug AS slug_35, t9.publish_at AS publish_at_36, t9.start_selling_at AS start_selling_at_37, t9.created_at AS created_at_38, t9.update_at AS update_at_39, t9.not_show AS not_show_40, t9.campaign_id AS campaign_id_41, t9.place_id AS place_id_42, t9.type_id AS type_id_43, t9.ticket_layout_id AS ticket_layout_id_44, t9.scheduling_id AS scheduling_id_45, t0.scheduling_id AS scheduling_id_46 FROM tkt_event_presentation t0 LEFT JOIN tkt_event t9 ON t0.event_id = t9.id WHERE t0.event_id = ? ORDER BY t0.start_at DESC
Parameters:
[
1073
]
|
| 5 | 0.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.slug AS slug_4, t0.system AS system_5 FROM tkt_event_campaign t0 WHERE t0.id = ?
Parameters:
[
42
]
|
| 6 | 0.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.system AS system_4 FROM tkt_event_type t0 WHERE t0.id = ?
Parameters:
[
6
]
|
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 |
|---|---|
| App\Entity\Order | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Setting | No errors. |
| App\Entity\Presentation | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Cart\Item | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\Price | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\Campaign | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\Type | No errors. |
| App\Entity\TicketLayout | No errors. |
| App\Entity\Scheduling | No errors. |