Query Metrics
3
Database Queries
3
Different statements
4.56 ms
Query time
0
Invalid entities
454
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.73 ms |
SELECT t0.id AS id_1, t0.cartatout_country_id AS cartatout_country_id_2, t0.lang AS lang_3, t0.label AS label_4, t0.code AS code_5, t0.image_url AS image_url_6, t0.center_lat AS center_lat_7, t0.center_lng AS center_lng_8, t0.geojson AS geojson_9, t0.ticketing_url AS ticketing_url_10, t0.ticketing_image_url AS ticketing_image_url_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.updated_at AS updated_at_15 FROM countries t0 WHERE t0.is_active = ? AND t0.lang = ?
Parameters:
[ 1 "fr" ]
|
||||||||||||||||||||||||||||
| 2 | 0.61 ms |
SELECT t0.id AS id_1, t0.cartatout_country_id AS cartatout_country_id_2, t0.lang AS lang_3, t0.label AS label_4, t0.code AS code_5, t0.image_url AS image_url_6, t0.center_lat AS center_lat_7, t0.center_lng AS center_lng_8, t0.geojson AS geojson_9, t0.ticketing_url AS ticketing_url_10, t0.ticketing_image_url AS ticketing_image_url_11, t0.is_active AS is_active_12, t0.payload_hash AS payload_hash_13, t0.last_synced_at AS last_synced_at_14, t0.updated_at AS updated_at_15 FROM countries t0 WHERE t0.cartatout_country_id = ? AND t0.lang = ? LIMIT 1
Parameters:
[ "5" "fr" ]
|
||||||||||||||||||||||||||||
| 3 | 3.22 ms |
SELECT s0_.id AS id_0, s0_.cartatout_shop_id AS cartatout_shop_id_1, s0_.address AS address_2, s0_.city AS city_3, s0_.zip_code AS zip_code_4, s0_.tel AS tel_5, s0_.email AS email_6, s0_.latitude AS latitude_7, s0_.longitude AS longitude_8, s0_.website AS website_9, s0_.zone_geo AS zone_geo_10, s0_.opening_hours AS opening_hours_11, s0_.is_active AS is_active_12, s0_.payload_hash AS payload_hash_13, s0_.last_synced_at AS last_synced_at_14, p1_.id AS id_15, p1_.cartatout_partner_id AS cartatout_partner_id_16, p1_.name AS name_17, p1_.slogan AS slogan_18, p1_.category AS category_19, p1_.discount_percent AS discount_percent_20, p1_.legal_notice AS legal_notice_21, p1_.logo_url AS logo_url_22, p1_.cover_url AS cover_url_23, p1_.presentation AS presentation_24, p1_.region AS region_25, p1_.is_active AS is_active_26, p1_.payload_hash AS payload_hash_27, p1_.last_synced_at AS last_synced_at_28, p1_.created_at AS created_at_29, p1_.updated_at AS updated_at_30, p1_.gallery_urls AS gallery_urls_31, s0_.partner_id AS partner_id_32 FROM shops s0_ INNER JOIN partners p1_ ON s0_.partner_id = p1_.id WHERE s0_.is_active = ? AND p1_.is_active = ? AND s0_.latitude IS NOT NULL AND s0_.longitude IS NOT NULL
Parameters:
[ 1 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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Shop | 257 |
| App\Entity\Partner | 194 |
| App\Entity\Country | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Country | No errors. |
| App\Entity\Shop | No errors. |
| App\Entity\Partner | No errors. |