https://dwadmin-dev.kangarooreview.com/api/ads?token=QEJU%2AYua_Ki9jEC7_Zbg4PnCpfRgKYvrnRhzqhvy_bnuac9-u8&type=desktop

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

Show all queries

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.