https://tuchassou.projet-client.com/?page=2

Query Metrics

28 Database Queries
15 Different statements
8.93 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.71 ms
SELECT h0_.id AS id_0, h0_.title AS title_1 FROM hunting_mode h0_ ORDER BY h0_.title ASC
Parameters:
[]
2 0.25 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.gibier_id AS gibier_id_2 FROM animal a0_ ORDER BY a0_.name ASC
Parameters:
[]
3 0.18 ms
SELECT w0_.id AS id_0, w0_.name AS name_1 FROM weapon w0_ ORDER BY w0_.name ASC
Parameters:
[]
4 0.16 ms
SELECT g0_.id AS id_0, g0_.title AS title_1 FROM gibier g0_ ORDER BY g0_.title ASC
Parameters:
[]
5 1.84 ms
SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.title AS title_2, o0_.slug AS slug_3, o0_.gibier_description AS gibier_description_4, o0_.team_experience_description AS team_experience_description_5, o0_.unfolds_day AS unfolds_day_6, o0_.hunting_plan AS hunting_plan_7, o0_.start_at AS start_at_8, o0_.end_at AS end_at_9, o0_.recurrence AS recurrence_10, o0_.price AS price_11, o0_.half_action_price AS half_action_price_12, o0_.half_action_nb_days AS half_action_nb_days_13, o0_.nb_actions_available AS nb_actions_available_14, o0_.nb_bracelet_person_max AS nb_bracelet_person_max_15, o0_.nb_bracelets_available AS nb_bracelets_available_16, o0_.max_nb_persons_hunting_day AS max_nb_persons_hunting_day_17, o0_.nb_places_day AS nb_places_day_18, o0_.further_information AS further_information_19, o0_.companions AS companions_20, o0_.half_action AS half_action_21, o0_.status AS status_22, o0_.is_paused AS is_paused_23, o0_.equipement AS equipement_24, o0_.planning_text AS planning_text_25, o0_.is_tuchassou_selected AS is_tuchassou_selected_26, o0_.disponibilities AS disponibilities_27, o0_.quantity_booked AS quantity_booked_28, o0_.created_at AS created_at_29, o0_.caracteric_gibier AS caracteric_gibier_30, o0_.cover AS cover_31, o0_.frais_chasseur AS frais_chasseur_32, o0_.frais_hote AS frais_hote_33, o0_.recurrence_exception AS recurrence_exception_34, o0_.is_managed_by_tuchassou AS is_managed_by_tuchassou_35, o0_.territory_id AS territory_id_36, o0_.created_by_id AS created_by_id_37 FROM offer o0_ LEFT JOIN territory t1_ ON o0_.territory_id = t1_.id LEFT JOIN offer_weapon o3_ ON o0_.id = o3_.offer_id LEFT JOIN weapon w2_ ON w2_.id = o3_.weapon_id WHERE o0_.status IN (?) GROUP BY o0_.id ORDER BY o0_.id DESC, o0_.is_tuchassou_selected DESC
Parameters:
[
  [
    1
    3
  ]
]
6 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.nb_hectares AS nb_hectares_4, t0.address AS address_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.department AS department_8, t0.region AS region_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.biotope AS biotope_12, t0.biotope_text AS biotope_text_13, t0.created_at AS created_at_14, t0.tuchassou_recommendations AS tuchassou_recommendations_15, t0.is_tuchassou_selected AS is_tuchassou_selected_16, t0.created_by_id AS created_by_id_17 FROM territory t0 WHERE t0.id = ?
Parameters:
[
  116
]
7 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.nb_hectares AS nb_hectares_4, t0.address AS address_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.department AS department_8, t0.region AS region_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.biotope AS biotope_12, t0.biotope_text AS biotope_text_13, t0.created_at AS created_at_14, t0.tuchassou_recommendations AS tuchassou_recommendations_15, t0.is_tuchassou_selected AS is_tuchassou_selected_16, t0.created_by_id AS created_by_id_17 FROM territory t0 WHERE t0.id = ?
Parameters:
[
  112
]
8 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.nb_hectares AS nb_hectares_4, t0.address AS address_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.department AS department_8, t0.region AS region_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.biotope AS biotope_12, t0.biotope_text AS biotope_text_13, t0.created_at AS created_at_14, t0.tuchassou_recommendations AS tuchassou_recommendations_15, t0.is_tuchassou_selected AS is_tuchassou_selected_16, t0.created_by_id AS created_by_id_17 FROM territory t0 WHERE t0.id = ?
Parameters:
[
  113
]
9 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.nb_hectares AS nb_hectares_4, t0.address AS address_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.department AS department_8, t0.region AS region_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.biotope AS biotope_12, t0.biotope_text AS biotope_text_13, t0.created_at AS created_at_14, t0.tuchassou_recommendations AS tuchassou_recommendations_15, t0.is_tuchassou_selected AS is_tuchassou_selected_16, t0.created_by_id AS created_by_id_17 FROM territory t0 WHERE t0.id = ?
Parameters:
[
  115
]
10 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = ?
Parameters:
[
  88
]
11 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = ?
Parameters:
[
  87
]
12 0.21 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.is_cover AS is_cover_3, t0.territory_id AS territory_id_4 FROM territory_image t0 WHERE t0.territory_id = ?
Parameters:
[
  112
]
13 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = ?
Parameters:
[
  86
]
14 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = ?
Parameters:
[
  85
]
15 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = ?
Parameters:
[
  84
]
16 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = ?
Parameters:
[
  83
]
17 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = ?
Parameters:
[
  82
]
18 0.46 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
19 0.36 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
20 0.12 ms
SELECT DATABASE()
Parameters:
[]
21 0.34 ms
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'tuchassou' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
22 0.16 ms
SELECT DATABASE()
Parameters:
[]
23 0.44 ms
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'tuchassou' /*!50116 AND c.CONSTRAINT_SCHEMA = 'tuchassou' */ORDER BY k.ORDINAL_POSITION
Parameters:
[]
24 0.08 ms
SELECT DATABASE()
Parameters:
[]
25 0.23 ms
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'tuchassou' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
26 0.40 ms
SELECT t.ENGINE,
       t.AUTO_INCREMENT,
       t.TABLE_COMMENT,
       t.CREATE_OPTIONS,
       t.TABLE_COLLATION,
       ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
    INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa
        ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
27 0.19 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
28 0.15 ms
SELECT DATABASE()
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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Offer
  • The association App\Entity\Offer#gibiers refers to the inverse side field App\Entity\Gibier#allOffers which does not exist.
App\Entity\HuntingMode No errors.
App\Entity\Animal No errors.
App\Entity\Gibier
  • The mappings App\Entity\Gibier#offers and App\Entity\Offer#gibiers are inconsistent with each other.
App\Entity\Weapon No errors.
App\Entity\Territory No errors.
App\Entity\Booking No errors.
App\Entity\OfferAdditionalService No errors.
App\Entity\OfferCancellationRequest No errors.
App\Entity\OfferImage No errors.
App\Entity\TerritoryImage No errors.
App\Entity\BookingDates
  • If association App\Entity\BookingDates#Booking is one-to-one, then the inversed side App\Entity\Booking#bookingDates has to be one-to-one as well.
App\Entity\AdditionalService No errors.
App\Entity\ResetPasswordRequest No errors.