https://piratskaskolicka.cz/

Query Metrics

7 Database Queries
7 Different statements
1.37 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.type AS type_4, t0.main AS main_5, t0.under_construction AS under_construction_6, t0.favicon AS favicon_7, t0.layout AS layout_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted AS deleted_12, t0.deleted_at AS deleted_at_13, t0.language_id AS language_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.deleted_by_id AS deleted_by_id_17 FROM domain t0 WHERE t0.domain = ? LIMIT 1
Parameters:
[
  "piratskaskolicka.cz"
]
2 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.enter_player_details AS enter_player_details_5, t0.description AS description_6, t0.cancellation_policy AS cancellation_policy_7, t0.contact_name AS contact_name_8, t0.contact_job AS contact_job_9, t0.contact_phone AS contact_phone_10, t0.contact_email AS contact_email_11, t0.capacity AS capacity_12, t0.capacity_goalkeeper AS capacity_goalkeeper_13, t0.unlimited AS unlimited_14, t0.price_all AS price_all_15, t0.price_term AS price_term_16, t0.price_deposit AS price_deposit_17, t0.date_payment_at AS date_payment_at_18, t0.date_payment_deposit_at AS date_payment_deposit_at_19, t0.header_background AS header_background_20, t0.header_background_color AS header_background_color_21, t0.header_image AS header_image_22, t0.age AS age_23, t0.focus AS focus_24, t0.use_coupon AS use_coupon_25, t0.settings_tshirts AS settings_tshirts_26, t0.settings_shorts AS settings_shorts_27, t0.active AS active_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.deleted AS deleted_31, t0.deleted_at AS deleted_at_32, t0.domain_id AS domain_id_33, t0.created_by_id AS created_by_id_34, t0.updated_by_id AS updated_by_id_35, t0.deleted_by_id AS deleted_by_id_36 FROM event t0 WHERE t0.domain_id = ? AND t0.active = ? AND t0.deleted = ? LIMIT 1
Parameters:
[
  3
  1
  0
]
3 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.text AS text_4, t0.menu AS menu_5, t0.event_show AS event_show_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.sort AS sort_12, t0.domain_id AS domain_id_13, t0.event_id AS event_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.deleted_by_id AS deleted_by_id_17 FROM page t0 WHERE t0.domain_id = ? AND t0.menu = ? AND t0.active = ? AND t0.deleted = ? ORDER BY t0.sort DESC
Parameters:
[
  3
  1
  1
  0
]
4 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.text AS text_4, t0.menu AS menu_5, t0.event_show AS event_show_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.sort AS sort_12, t0.domain_id AS domain_id_13, t0.event_id AS event_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.deleted_by_id AS deleted_by_id_17 FROM page t0 WHERE t0.domain_id = ? AND t0.active = ? AND t0.deleted = ? ORDER BY t0.sort DESC
Parameters:
[
  3
  1
  0
]
5 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.text AS text_4, t0.menu AS menu_5, t0.event_show AS event_show_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted AS deleted_10, t0.deleted_at AS deleted_at_11, t0.sort AS sort_12, t0.domain_id AS domain_id_13, t0.event_id AS event_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.deleted_by_id AS deleted_by_id_17 FROM page t0 WHERE t0.domain_id = ? AND t0.event_show = ? AND t0.active = ? AND t0.deleted = ? ORDER BY t0.sort DESC LIMIT 1
Parameters:
[
  3
  1
  1
  0
]
6 0.18 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.date_to AS date_to_3, t0.description AS description_4, t0.capacity AS capacity_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.event_id AS event_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM event_date t0 WHERE t0.event_id = ?
Parameters:
[
  10
]
7 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price_all AS price_all_4, t0.price_term AS price_term_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted AS deleted_9, t0.deleted_at AS deleted_at_10, t0.event_id AS event_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM event_type t0 WHERE t0.event_id = ?
Parameters:
[
  10
]

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\Setup\Domain No errors.
App\Entity\Setup\Language No errors.
App\Entity\User\User No errors.
App\Entity\Event\Event No errors.
App\Entity\Setup\DomainScript No errors.
App\Entity\Setup\DomainTranslate No errors.
App\Entity\Page\Page No errors.
App\Entity\Event\EventDate No errors.
App\Entity\Event\EventType No errors.
App\Entity\User\UserChildren No errors.
App\Entity\Reservation\Reservation No errors.
App\Entity\Reservation\ReservationDate No errors.
App\Entity\Coupon\Coupon No errors.
App\Entity\Partition\PartitionItem No errors.
App\Entity\Page\PageImage No errors.
App\Entity\Page\PageVideo No errors.