Query Metrics
3
Database Queries
3
Different statements
1.81 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.71 ms (39.50%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.url AS url_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.show_deals AS show_deals_8, t0.sticky_spots AS sticky_spots_9, t0.report_emails AS report_emails_10, t0.tag_deal AS tag_deal_11, t0.tag_store AS tag_store_12, t0.color AS color_13, t0.code AS code_14, t0.hide_paid_placement AS hide_paid_placement_15, t0.hide_paid_placement_sticky AS hide_paid_placement_sticky_16, t0.token AS token_17, t0.weight AS weight_18, t0.image_cdn AS image_cdn_19, t0.fields AS fields_20, t0.append_price_newsletter_title AS append_price_newsletter_title_21, t0.custom_html AS custom_html_22, t0.use_default AS use_default_23 FROM site t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"QEJU*Yua_Ki9jEC7_Zbg4PnCpfRgKYvrnRhzqhvy_bnuac9-u8"
]
|
0.58 ms (31.83%) |
1 |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.uid AS uid_2, a0_.slug AS slug_3, a0_.position AS position_4, a0_.code AS code_5, a0_.type AS type_6, a0_.priority AS priority_7, a0_.is_disabled AS is_disabled_8, a0_.site_id AS site_id_9 FROM ads a0_ INNER JOIN site s1_ ON a0_.site_id = s1_.id WHERE s1_.id IN (?) AND a0_.type IN (?, ?) AND (a0_.is_disabled <> 1 OR a0_.is_disabled IS NULL) ORDER BY a0_.priority ASC LIMIT 50
Parameters:
[ 2 "desktop" "all" ] |
0.52 ms (28.67%) |
1 |
SELECT count(a0_.id) AS sclr_0 FROM ads a0_ INNER JOIN site s1_ ON a0_.site_id = s1_.id WHERE s1_.id IN (?) AND a0_.type IN (?, ?) AND (a0_.is_disabled <> 1 OR a0_.is_disabled IS NULL) ORDER BY a0_.priority ASC
Parameters:
[ 2 "desktop" "all" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Log | No errors. |
App\Entity\Site | No errors. |
App\Entity\Permission | No errors. |
App\Entity\Ads | No errors. |
App\Entity\Store | No errors. |
App\Entity\Deal | No errors. |