Query Metrics
20
Database Queries
10
Different statements
25.84 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.69 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.subtitle_alternative AS subtitle_alternative_6, t0.subtitle_alternative_2 AS subtitle_alternative_2_7, t0.image_one_file_name AS image_one_file_name_8, t0.image_one_name AS image_one_name_9, t0.image_two_file_name AS image_two_file_name_10, t0.mobile_image_two_file_name AS mobile_image_two_file_name_11, t0.image_two_name AS image_two_name_12, t0.title_shelter AS title_shelter_13, t0.button_shelter_text AS button_shelter_text_14, t0.image_shelter_file_name AS image_shelter_file_name_15, t0.image_shelter_name AS image_shelter_name_16, t0.title_adoption AS title_adoption_17, t0.subtitle_adoption AS subtitle_adoption_18, t0.button_adoption_text AS button_adoption_text_19, t0.image_adoption_file_name AS image_adoption_file_name_20, t0.image_adoption_name AS image_adoption_name_21, t0.title_help AS title_help_22, t0.subtitle_help AS subtitle_help_23, t0.subtitle_help2 AS subtitle_help2_24, t0.button_help_text AS button_help_text_25, t0.button_help_url AS button_help_url_26, t0.image_help_file_name AS image_help_file_name_27, t0.image_help_name AS image_help_name_28, t0.title_story AS title_story_29, t0.subtitle_story AS subtitle_story_30, t0.story_button_text AS story_button_text_31, t0.story_button_url AS story_button_url_32, t0.adopting_counter_base AS adopting_counter_base_33, t0.adopting_counter_title AS adopting_counter_title_34, t0.file_update_at AS file_update_at_35, t0.title_card_story AS title_card_story_36, t0.subtitle_card_story AS subtitle_card_story_37, t0.image_card_story_file_name AS image_card_story_file_name_38, t0.image_card_story_name AS image_card_story_name_39, t0.button_card_story_text AS button_card_story_text_40, t0.button_card_story_url AS button_card_story_url_41, t0.pre_footer_title AS pre_footer_title_42, t0.disclaimer AS disclaimer_43 FROM home_texts t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 2 | 1.79 ms |
SELECT t0.id AS id_1, t0.script AS script_2, t0.pixel AS pixel_3 FROM script_head t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 3 | 4.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.size AS size_4, t0.special_status AS special_status_5, t0.race AS race_6, t0.pet_profile_image AS pet_profile_image_7, t0.birthday AS birthday_8, t0.adopted_at AS adopted_at_9, t0.location AS location_10, t0.adopted_via AS adopted_via_11, t0.description AS description_12, t0.short_description AS short_description_13, t0.delivery AS delivery_14, t0.vaccinated AS vaccinated_15, t0.desparasited AS desparasited_16, t0.healthy AS healthy_17, t0.sterilized AS sterilized_18, t0.identified AS identified_19, t0.chip AS chip_20, t0.passport AS passport_21, t0.dog_compatible AS dog_compatible_22, t0.cat_compatible AS cat_compatible_23, t0.kid_compatible AS kid_compatible_24, t0.adoption_tax AS adoption_tax_25, t0.active AS active_26, t0.images AS images_27, t0.infraction_type AS infraction_type_28, t0.infraction_text AS infraction_text_29, t0.updated_at AS updated_at_30, t0.specie_id AS specie_id_31, t0.shelter_id AS shelter_id_32 FROM pet t0 WHERE t0.active = ?
Parameters:
[
1
]
|
| 4 | 1.13 ms |
SELECT t0.id AS id_1, t0.script AS script_2, t0.pixel AS pixel_3 FROM script_head t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 5 | 2.88 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.name AS name_3, t0.cif AS cif_4, t0.location AS location_5, t0.url AS url_6, t0.description AS description_7, t0.email AS email_8, t0.phone AS phone_9, t0.images AS images_10, t0.adopted_base AS adopted_base_11, t0.social_media AS social_media_12, t0.active AS active_13, t0.infraction_type AS infraction_type_14, t0.infraction_text AS infraction_text_15, t0.shelter_profile_image AS shelter_profile_image_16, t0.shelter_profile_doc AS shelter_profile_doc_17, t0.type AS type_18, t0.is_public_entity AS is_public_entity_19, t0.documents AS documents_20, t0.is_refuge AS is_refuge_21, t0.is_looking_for_foster AS is_looking_for_foster_22, t0.is_looking_for_volunteers AS is_looking_for_volunteers_23, t0.is_accepting_donations AS is_accepting_donations_24, t0.created_date AS created_date_25 FROM shelter t0 WHERE t0.active = ?
Parameters:
[
1
]
|
| 6 | 1.50 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gender AS gender_2, p0_.size AS size_3, p0_.special_status AS special_status_4, p0_.race AS race_5, p0_.pet_profile_image AS pet_profile_image_6, p0_.birthday AS birthday_7, p0_.adopted_at AS adopted_at_8, p0_.location AS location_9, p0_.adopted_via AS adopted_via_10, p0_.description AS description_11, p0_.short_description AS short_description_12, p0_.delivery AS delivery_13, p0_.vaccinated AS vaccinated_14, p0_.desparasited AS desparasited_15, p0_.healthy AS healthy_16, p0_.sterilized AS sterilized_17, p0_.identified AS identified_18, p0_.chip AS chip_19, p0_.passport AS passport_20, p0_.dog_compatible AS dog_compatible_21, p0_.cat_compatible AS cat_compatible_22, p0_.kid_compatible AS kid_compatible_23, p0_.adoption_tax AS adoption_tax_24, p0_.active AS active_25, p0_.images AS images_26, p0_.infraction_type AS infraction_type_27, p0_.infraction_text AS infraction_text_28, p0_.updated_at AS updated_at_29, p0_.specie_id AS specie_id_30, p0_.shelter_id AS shelter_id_31 FROM pet p0_ LEFT JOIN shelter s1_ ON p0_.shelter_id = s1_.id WHERE p0_.shelter_id = ? AND p0_.active = ? AND p0_.special_status = ?
Parameters:
[ 8 1 "URGENT" ] |
| 7 | 0.86 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gender AS gender_2, p0_.size AS size_3, p0_.special_status AS special_status_4, p0_.race AS race_5, p0_.pet_profile_image AS pet_profile_image_6, p0_.birthday AS birthday_7, p0_.adopted_at AS adopted_at_8, p0_.location AS location_9, p0_.adopted_via AS adopted_via_10, p0_.description AS description_11, p0_.short_description AS short_description_12, p0_.delivery AS delivery_13, p0_.vaccinated AS vaccinated_14, p0_.desparasited AS desparasited_15, p0_.healthy AS healthy_16, p0_.sterilized AS sterilized_17, p0_.identified AS identified_18, p0_.chip AS chip_19, p0_.passport AS passport_20, p0_.dog_compatible AS dog_compatible_21, p0_.cat_compatible AS cat_compatible_22, p0_.kid_compatible AS kid_compatible_23, p0_.adoption_tax AS adoption_tax_24, p0_.active AS active_25, p0_.images AS images_26, p0_.infraction_type AS infraction_type_27, p0_.infraction_text AS infraction_text_28, p0_.updated_at AS updated_at_29, p0_.specie_id AS specie_id_30, p0_.shelter_id AS shelter_id_31 FROM pet p0_ LEFT JOIN shelter s1_ ON p0_.shelter_id = s1_.id WHERE p0_.shelter_id = ? AND p0_.active = ? AND p0_.special_status = ?
Parameters:
[ 172 1 "URGENT" ] |
| 8 | 1.17 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gender AS gender_2, p0_.size AS size_3, p0_.special_status AS special_status_4, p0_.race AS race_5, p0_.pet_profile_image AS pet_profile_image_6, p0_.birthday AS birthday_7, p0_.adopted_at AS adopted_at_8, p0_.location AS location_9, p0_.adopted_via AS adopted_via_10, p0_.description AS description_11, p0_.short_description AS short_description_12, p0_.delivery AS delivery_13, p0_.vaccinated AS vaccinated_14, p0_.desparasited AS desparasited_15, p0_.healthy AS healthy_16, p0_.sterilized AS sterilized_17, p0_.identified AS identified_18, p0_.chip AS chip_19, p0_.passport AS passport_20, p0_.dog_compatible AS dog_compatible_21, p0_.cat_compatible AS cat_compatible_22, p0_.kid_compatible AS kid_compatible_23, p0_.adoption_tax AS adoption_tax_24, p0_.active AS active_25, p0_.images AS images_26, p0_.infraction_type AS infraction_type_27, p0_.infraction_text AS infraction_text_28, p0_.updated_at AS updated_at_29, p0_.specie_id AS specie_id_30, p0_.shelter_id AS shelter_id_31 FROM pet p0_ LEFT JOIN shelter s1_ ON p0_.shelter_id = s1_.id WHERE p0_.shelter_id = ? AND p0_.active = ? AND p0_.special_status = ?
Parameters:
[ 173 1 "URGENT" ] |
| 9 | 0.49 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gender AS gender_2, p0_.size AS size_3, p0_.special_status AS special_status_4, p0_.race AS race_5, p0_.pet_profile_image AS pet_profile_image_6, p0_.birthday AS birthday_7, p0_.adopted_at AS adopted_at_8, p0_.location AS location_9, p0_.adopted_via AS adopted_via_10, p0_.description AS description_11, p0_.short_description AS short_description_12, p0_.delivery AS delivery_13, p0_.vaccinated AS vaccinated_14, p0_.desparasited AS desparasited_15, p0_.healthy AS healthy_16, p0_.sterilized AS sterilized_17, p0_.identified AS identified_18, p0_.chip AS chip_19, p0_.passport AS passport_20, p0_.dog_compatible AS dog_compatible_21, p0_.cat_compatible AS cat_compatible_22, p0_.kid_compatible AS kid_compatible_23, p0_.adoption_tax AS adoption_tax_24, p0_.active AS active_25, p0_.images AS images_26, p0_.infraction_type AS infraction_type_27, p0_.infraction_text AS infraction_text_28, p0_.updated_at AS updated_at_29, p0_.specie_id AS specie_id_30, p0_.shelter_id AS shelter_id_31 FROM pet p0_ LEFT JOIN shelter s1_ ON p0_.shelter_id = s1_.id WHERE p0_.shelter_id = ? AND p0_.active = ? AND p0_.special_status = ?
Parameters:
[ 175 1 "URGENT" ] |
| 10 | 0.45 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gender AS gender_2, p0_.size AS size_3, p0_.special_status AS special_status_4, p0_.race AS race_5, p0_.pet_profile_image AS pet_profile_image_6, p0_.birthday AS birthday_7, p0_.adopted_at AS adopted_at_8, p0_.location AS location_9, p0_.adopted_via AS adopted_via_10, p0_.description AS description_11, p0_.short_description AS short_description_12, p0_.delivery AS delivery_13, p0_.vaccinated AS vaccinated_14, p0_.desparasited AS desparasited_15, p0_.healthy AS healthy_16, p0_.sterilized AS sterilized_17, p0_.identified AS identified_18, p0_.chip AS chip_19, p0_.passport AS passport_20, p0_.dog_compatible AS dog_compatible_21, p0_.cat_compatible AS cat_compatible_22, p0_.kid_compatible AS kid_compatible_23, p0_.adoption_tax AS adoption_tax_24, p0_.active AS active_25, p0_.images AS images_26, p0_.infraction_type AS infraction_type_27, p0_.infraction_text AS infraction_text_28, p0_.updated_at AS updated_at_29, p0_.specie_id AS specie_id_30, p0_.shelter_id AS shelter_id_31 FROM pet p0_ LEFT JOIN shelter s1_ ON p0_.shelter_id = s1_.id WHERE p0_.shelter_id = ? AND p0_.active = ? AND p0_.special_status = ?
Parameters:
[ 178 1 "URGENT" ] |
| 11 | 0.78 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gender AS gender_2, p0_.size AS size_3, p0_.special_status AS special_status_4, p0_.race AS race_5, p0_.pet_profile_image AS pet_profile_image_6, p0_.birthday AS birthday_7, p0_.adopted_at AS adopted_at_8, p0_.location AS location_9, p0_.adopted_via AS adopted_via_10, p0_.description AS description_11, p0_.short_description AS short_description_12, p0_.delivery AS delivery_13, p0_.vaccinated AS vaccinated_14, p0_.desparasited AS desparasited_15, p0_.healthy AS healthy_16, p0_.sterilized AS sterilized_17, p0_.identified AS identified_18, p0_.chip AS chip_19, p0_.passport AS passport_20, p0_.dog_compatible AS dog_compatible_21, p0_.cat_compatible AS cat_compatible_22, p0_.kid_compatible AS kid_compatible_23, p0_.adoption_tax AS adoption_tax_24, p0_.active AS active_25, p0_.images AS images_26, p0_.infraction_type AS infraction_type_27, p0_.infraction_text AS infraction_text_28, p0_.updated_at AS updated_at_29, p0_.specie_id AS specie_id_30, p0_.shelter_id AS shelter_id_31 FROM pet p0_ LEFT JOIN shelter s1_ ON p0_.shelter_id = s1_.id WHERE p0_.shelter_id = ? AND p0_.active = ? AND p0_.special_status = ?
Parameters:
[ 180 1 "URGENT" ] |
| 12 | 0.70 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gender AS gender_2, p0_.size AS size_3, p0_.special_status AS special_status_4, p0_.race AS race_5, p0_.pet_profile_image AS pet_profile_image_6, p0_.birthday AS birthday_7, p0_.adopted_at AS adopted_at_8, p0_.location AS location_9, p0_.adopted_via AS adopted_via_10, p0_.description AS description_11, p0_.short_description AS short_description_12, p0_.delivery AS delivery_13, p0_.vaccinated AS vaccinated_14, p0_.desparasited AS desparasited_15, p0_.healthy AS healthy_16, p0_.sterilized AS sterilized_17, p0_.identified AS identified_18, p0_.chip AS chip_19, p0_.passport AS passport_20, p0_.dog_compatible AS dog_compatible_21, p0_.cat_compatible AS cat_compatible_22, p0_.kid_compatible AS kid_compatible_23, p0_.adoption_tax AS adoption_tax_24, p0_.active AS active_25, p0_.images AS images_26, p0_.infraction_type AS infraction_type_27, p0_.infraction_text AS infraction_text_28, p0_.updated_at AS updated_at_29, p0_.specie_id AS specie_id_30, p0_.shelter_id AS shelter_id_31 FROM pet p0_ LEFT JOIN shelter s1_ ON p0_.shelter_id = s1_.id WHERE p0_.shelter_id = ? AND p0_.active = ? AND p0_.special_status = ?
Parameters:
[ 183 1 "URGENT" ] |
| 13 | 0.72 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gender AS gender_2, p0_.size AS size_3, p0_.special_status AS special_status_4, p0_.race AS race_5, p0_.pet_profile_image AS pet_profile_image_6, p0_.birthday AS birthday_7, p0_.adopted_at AS adopted_at_8, p0_.location AS location_9, p0_.adopted_via AS adopted_via_10, p0_.description AS description_11, p0_.short_description AS short_description_12, p0_.delivery AS delivery_13, p0_.vaccinated AS vaccinated_14, p0_.desparasited AS desparasited_15, p0_.healthy AS healthy_16, p0_.sterilized AS sterilized_17, p0_.identified AS identified_18, p0_.chip AS chip_19, p0_.passport AS passport_20, p0_.dog_compatible AS dog_compatible_21, p0_.cat_compatible AS cat_compatible_22, p0_.kid_compatible AS kid_compatible_23, p0_.adoption_tax AS adoption_tax_24, p0_.active AS active_25, p0_.images AS images_26, p0_.infraction_type AS infraction_type_27, p0_.infraction_text AS infraction_text_28, p0_.updated_at AS updated_at_29, p0_.specie_id AS specie_id_30, p0_.shelter_id AS shelter_id_31 FROM pet p0_ LEFT JOIN shelter s1_ ON p0_.shelter_id = s1_.id WHERE p0_.shelter_id = ? AND p0_.active = ? AND p0_.special_status = ?
Parameters:
[ 184 1 "URGENT" ] |
| 14 | 1.02 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM specie t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 15 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM specie t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 16 | 0.62 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.subtitle_alternative AS subtitle_alternative_6, t0.subtitle_alternative_2 AS subtitle_alternative_2_7, t0.image_one_file_name AS image_one_file_name_8, t0.image_one_name AS image_one_name_9, t0.image_two_file_name AS image_two_file_name_10, t0.mobile_image_two_file_name AS mobile_image_two_file_name_11, t0.image_two_name AS image_two_name_12, t0.title_shelter AS title_shelter_13, t0.button_shelter_text AS button_shelter_text_14, t0.image_shelter_file_name AS image_shelter_file_name_15, t0.image_shelter_name AS image_shelter_name_16, t0.title_adoption AS title_adoption_17, t0.subtitle_adoption AS subtitle_adoption_18, t0.button_adoption_text AS button_adoption_text_19, t0.image_adoption_file_name AS image_adoption_file_name_20, t0.image_adoption_name AS image_adoption_name_21, t0.title_help AS title_help_22, t0.subtitle_help AS subtitle_help_23, t0.subtitle_help2 AS subtitle_help2_24, t0.button_help_text AS button_help_text_25, t0.button_help_url AS button_help_url_26, t0.image_help_file_name AS image_help_file_name_27, t0.image_help_name AS image_help_name_28, t0.title_story AS title_story_29, t0.subtitle_story AS subtitle_story_30, t0.story_button_text AS story_button_text_31, t0.story_button_url AS story_button_url_32, t0.adopting_counter_base AS adopting_counter_base_33, t0.adopting_counter_title AS adopting_counter_title_34, t0.file_update_at AS file_update_at_35, t0.title_card_story AS title_card_story_36, t0.subtitle_card_story AS subtitle_card_story_37, t0.image_card_story_file_name AS image_card_story_file_name_38, t0.image_card_story_name AS image_card_story_name_39, t0.button_card_story_text AS button_card_story_text_40, t0.button_card_story_url AS button_card_story_url_41, t0.pre_footer_title AS pre_footer_title_42, t0.disclaimer AS disclaimer_43 FROM home_texts t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 17 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.size AS size_4, t0.special_status AS special_status_5, t0.race AS race_6, t0.pet_profile_image AS pet_profile_image_7, t0.birthday AS birthday_8, t0.adopted_at AS adopted_at_9, t0.location AS location_10, t0.adopted_via AS adopted_via_11, t0.description AS description_12, t0.short_description AS short_description_13, t0.delivery AS delivery_14, t0.vaccinated AS vaccinated_15, t0.desparasited AS desparasited_16, t0.healthy AS healthy_17, t0.sterilized AS sterilized_18, t0.identified AS identified_19, t0.chip AS chip_20, t0.passport AS passport_21, t0.dog_compatible AS dog_compatible_22, t0.cat_compatible AS cat_compatible_23, t0.kid_compatible AS kid_compatible_24, t0.adoption_tax AS adoption_tax_25, t0.active AS active_26, t0.images AS images_27, t0.infraction_type AS infraction_type_28, t0.infraction_text AS infraction_text_29, t0.updated_at AS updated_at_30, t0.specie_id AS specie_id_31, t0.shelter_id AS shelter_id_32 FROM pet t0 WHERE t0.special_status = ?
Parameters:
[
"ADOPTED"
]
|
| 18 | 0.74 ms |
SELECT DISTINCT s0_.name AS name_0 FROM pet p1_ INNER JOIN shelter s2_ ON p1_.shelter_id = s2_.id INNER JOIN specie s0_ ON p1_.specie_id = s0_.id WHERE s0_.active = 1 AND p1_.active = 1 AND p1_.active = 1 AND s2_.active = 1
Parameters:
[] |
| 19 | 1.07 ms |
SELECT t0.id AS id_1, t0.title_card_story AS title_card_story_2, t0.subtitle_card_story AS subtitle_card_story_3, t0.image_card_story_file_name AS image_card_story_file_name_4, t0.image_card_story_name AS image_card_story_name_5, t0.button_card_story_text AS button_card_story_text_6, t0.button_card_story_url AS button_card_story_url_7 FROM histories t0 LIMIT 4
Parameters:
[] |
| 20 | 1.29 ms |
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.id AS id_3, t0.slug AS slug_4, t0.name AS name_5, t0.title AS title_6, t0.sub_title AS sub_title_7, t0.text AS text_8, t0.image_legal_file_name AS image_legal_file_name_9, t0.image_legal_name AS image_legal_name_10, t0.button_help_text AS button_help_text_11, t0.button_help_url AS button_help_url_12, t0.priority AS priority_13, t0.active AS active_14 FROM legal_page t0 WHERE t0.active = ? ORDER BY t0.priority DESC
Parameters:
[
1
]
|
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\Pages\MetasText | No errors. |
| App\Entity\Pages\HomeTexts | No errors. |
| App\Entity\Pages\ScriptHead | No errors. |
| App\Entity\Pet | No errors. |
| App\Entity\Specie | No errors. |
| App\Entity\Shelter | No errors. |
| App\Entity\Personality | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ShelterHistory | No errors. |
| App\Entity\Histories | No errors. |
| App\Entity\LegalPage | No errors. |