GET https://dev.petso.halisz.pl/rasy/koty

Query Metrics

6 Database Queries
6 Different statements
13.57 ms Query time
1 Invalid entities
62 Managed entities

Grouped Statements

Show all queries

Time Count Info
8.32 ms
(61.33%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.content AS content_2, b0_.stat_size AS stat_size_3, b0_.stat_exercises AS stat_exercises_4, b0_.stat_training AS stat_training_5, b0_.stat_hair_amount AS stat_hair_amount_6, b0_.stat_haircut_frequency AS stat_haircut_frequency_7, b0_.stat_kids AS stat_kids_8, b0_.stat_health AS stat_health_9, b0_.stat_costs AS stat_costs_10, b0_.stat_intelligence AS stat_intelligence_11, b0_.param_life AS param_life_12, b0_.param_weight_male AS param_weight_male_13, b0_.param_weight_female AS param_weight_female_14, b0_.param_growth AS param_growth_15, b0_.param_recognized_by_fci AS param_recognized_by_fci_16, b0_.blocks AS blocks_17, b0_.title AS title_18, b0_.meta_title AS meta_title_19, b0_.meta_keywords AS meta_keywords_20, b0_.meta_description AS meta_description_21, b1_.id AS id_22, b1_.name AS name_23, b1_.slug AS slug_24, b1_.description AS description_25, b1_.active AS active_26, b1_.breeding_description AS breeding_description_27, b1_.title AS title_28, b1_.meta_title AS meta_title_29, b1_.meta_keywords AS meta_keywords_30, b1_.meta_description AS meta_description_31, c2_.id AS id_32, c2_.name AS name_33, c2_.slug AS slug_34, c2_.description AS description_35, c2_.active AS active_36, c2_.position AS position_37, c2_.breeding_description AS breeding_description_38, c2_.title AS title_39, c2_.meta_title AS meta_title_40, c2_.meta_keywords AS meta_keywords_41, c2_.meta_description AS meta_description_42, i3_.id AS id_43, i3_.name AS name_44, i3_.alt AS alt_45, i3_.file AS file_46, i3_.uuid AS uuid_47, i3_.type AS type_48, i3_.temp AS temp_49, i3_.path AS path_50, i3_.width AS width_51, i3_.height AS height_52, i3_.extension AS extension_53, i3_.position AS position_54, i3_.created_at AS created_at_55, i3_.updated_at AS updated_at_56, b0_.breed_id AS breed_id_57, b1_.image_id AS image_id_58, b1_.category_id AS category_id_59, c2_.category_id AS category_id_60, c2_.image_id AS image_id_61, i3_.owner_id AS owner_id_62 FROM breed_information b0_ LEFT JOIN breed b1_ ON b0_.breed_id = b1_.id LEFT JOIN category c2_ ON b1_.category_id = c2_.id LEFT JOIN image i3_ ON b1_.image_id = i3_.id WHERE c2_.active = ? AND b1_.active = ? AND b1_.id NOT IN (?, ?) AND c2_.slug = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b1_.name ASC
Parameters:
[
  1
  1
  52
  53
  "koty"
  42
  44
  45
  38
  10
  59
  58
  31
  54
  46
  57
  50
  11
  49
  47
  39
  34
  13
  32
  43
]
1.52 ms
(11.21%)
1
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM breed_information b0_ LEFT JOIN breed b1_ ON b0_.breed_id = b1_.id LEFT JOIN category c2_ ON b1_.category_id = c2_.id LEFT JOIN image i3_ ON b1_.image_id = i3_.id WHERE c2_.active = ? AND b1_.active = ? AND b1_.id NOT IN (?, ?) AND c2_.slug = ?
Parameters:
[
  1
  1
  52
  53
  "koty"
]
1.39 ms
(10.25%)
1
SELECT DISTINCT b0_.id AS id_0, b1_.name AS name_1 FROM breed_information b0_ LEFT JOIN breed b1_ ON b0_.breed_id = b1_.id LEFT JOIN category c2_ ON b1_.category_id = c2_.id LEFT JOIN image i3_ ON b1_.image_id = i3_.id WHERE c2_.active = ? AND b1_.active = ? AND b1_.id NOT IN (?, ?) AND c2_.slug = ? ORDER BY b1_.name ASC LIMIT 20
Parameters:
[
  1
  1
  52
  53
  "koty"
]
0.94 ms
(6.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.active AS active_5, t0.position AS position_6, t0.breeding_description AS breeding_description_7, t0.title AS title_8, t0.meta_title AS meta_title_9, t0.meta_keywords AS meta_keywords_10, t0.meta_description AS meta_description_11, t0.category_id AS category_id_12, t0.image_id AS image_id_13 FROM category t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "koty"
  1
]
0.73 ms
(5.39%)
1
SELECT s0_.value AS value_0 FROM setting s0_ WHERE s0_.name = ? LIMIT 1
Parameters:
[
  "breed_content_bottom_1"
]
0.66 ms
(4.85%)
1
SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_
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\Image 21
App\Entity\BreedInformation 20
App\Entity\Breed 20
App\Entity\Category 1

Entities Mapping

Class Mapping errors
App\Entity\Category No errors.
App\Entity\Image No errors.
App\Entity\Breed No errors.
App\Entity\Offer No errors.
App\Entity\Filter No errors.
App\Entity\Setting No errors.
App\Entity\BreedInformation No errors.
App\Entity\User
  • The mappings App\Entity\User#plans and App\Entity\UserPlan#owner are inconsistent with each other.