Query Metrics
15
Database Queries
11
Different statements
427.05 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
418.94 ms (98.10%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.browser_key AS browser_key_4, t0.data AS data_5, t0.id_http_user_agent AS id_http_user_agent_6, t0.id_ip_address AS id_ip_address_7 FROM user_cookie t0 WHERE t0.value = ? LIMIT 1
Parameters:
[
"0129594d5925fc03f0407e1206acaf1c"
]
|
|
2.20 ms (0.51%) |
2 |
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.country AS country_3, t0.is_forbidden AS is_forbidden_4 FROM ip_address t0 WHERE t0.ip = ? LIMIT 1
Parameters:
[
"195.178.110.132"
]
|
|
1.56 ms (0.37%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"test_tinady_db"
]
|
|
1.02 ms (0.24%) |
1 |
SELECT t0.id AS id_1, t0.browser_key AS browser_key_2, t0.time_at AS time_at_3, t0.user_agent AS user_agent_4, t0.is_bot AS is_bot_5, t0.bot_key AS bot_key_6, t0.contry AS contry_7, t0.ip_address AS ip_address_8 FROM http_user_agent t0 WHERE t0.user_agent = ? LIMIT 1
Parameters:
[
"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36"
]
|
|
0.97 ms (0.23%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.58 ms (0.14%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
0.54 ms (0.13%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"aws.config.js"
]
|
|
0.39 ms (0.09%) |
1 |
UPDATE user_cookie SET id_http_user_agent = ?, id_ip_address = ? WHERE id = ?
Parameters:
[ 1059 2526 673671 ] |
|
0.33 ms (0.08%) |
1 |
INSERT INTO user_cookie (value, created_at, browser_key, data, id_http_user_agent, id_ip_address) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ "0129594d5925fc03f0407e1206acaf1c" "2026-01-13 06:10:16" 1 "[]" null null ] |
|
0.28 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug_tech = ? LIMIT 1
Parameters:
[
"aws.config.js"
]
|
|
0.25 ms (0.06%) |
2 |
"START TRANSACTION"
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\Vitrine | No errors. |
| App\Entity\User |
|
| App\Entity\Media | No errors. |
| App\Entity\VitrineConfig | No errors. |
| App\Entity\OfferBatch | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\VitrineUser | No errors. |
| App\Entity\UserCompany | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\UserEnterprise | No errors. |
| App\Entity\Profile | No errors. |
| App\Entity\Mailing | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\UserFollow | No errors. |
| App\Entity\PostShort | No errors. |
| App\Entity\Contact |
|
| App\Entity\Discussion | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\OrganizationUser | No errors. |
| App\Entity\ContactMessage | No errors. |
| App\Entity\MailingHistory |
|
| App\Entity\JobProfile |
|
| App\Entity\UserCookie | No errors. |
| App\Entity\HttpUserAgent | No errors. |
| App\Entity\IpAddress | No errors. |