Query Metrics

8 Database Queries
8 Different statements
114.70 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
58.35 ms
(50.87%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  395935
  404366
  408644
  420635
  421287
  428970
  439819
  448512
  457204
  471628
  475105
  475508
  477442
  481343
  483223
  489516
  492267
  509429
  512952
  513680
  515840
  518403
  519930
  521832
  525287
  536802
  541611
  559948
  561828
  565105
  565267
  566993
  576112
  587878
  591235
  597491
  597580
  598080
  603981
  612519
  617165
  619794
  620124
  621273
  624847
  625185
  629296
  630537
  703268
  714074
  731279
]
34.27 ms
(29.88%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "sleep teen ass"
  "sleep teen ass"
  "sleep teen ass"
  20
]
12.43 ms
(10.84%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  428970
  475508
  475105
  518403
  559948
  598080
  576112
  629296
  477442
  489516
  513680
  420635
  471628
  519930
  597580
  619794
  536802
  395935
  565267
  566993
  521832
  515840
  714074
  703268
  448512
  421287
  492267
  621273
  630537
  439819
  457204
  561828
  565105
  587878
  603981
  483223
  731279
  612519
  597491
  625185
  624847
  617165
  525287
  408644
  509429
  404366
  481343
  512952
  620124
  591235
  541611
]
2.41 ms
(2.10%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  395935
  404366
  408644
  420635
  421287
  428970
  439819
  448512
  457204
  471628
  475105
  475508
  477442
  481343
  483223
  489516
  492267
  509429
  512952
  513680
  515840
  518403
  519930
  521832
  525287
  536802
  541611
  559948
  561828
  565105
  565267
  566993
  576112
  587878
  591235
  597491
  597580
  598080
  603981
  612519
  617165
  619794
  620124
  621273
  624847
  625185
  629296
  630537
  703268
  714074
  731279
]
1.99 ms
(1.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sleep teen ass"
]
1.71 ms
(1.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спящ teen жоп"
]
1.60 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "спящ teen жоп"
]

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

No loaded entities.