Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.88 ms
(58.57%)
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
  182352
  287540
  287979
  396575
  398053
  413235
  415003
  423539
  433883
  443340
  446331
  446698
  460194
  468592
  476441
  483094
  485249
  489361
  490071
  492125
  496647
  499668
  530063
  536915
  544818
  555814
  558171
  562491
  587959
  596919
  598504
  604995
  606377
  615846
  622682
  623844
  626082
  630621
  638555
  639131
  644307
  649168
  722248
  725408
  733586
  735285
  739089
  740965
  744607
  765810
  784814
  788863
  793151
  821162
  826507
  827553
]
34.78 ms
(27.58%)
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:
[
  "tight pussy black"
  "tight pussy black"
  "tight pussy black"
  20
]
8.58 ms
(6.80%)
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
  826507
  496647
  793151
  784814
  423539
  824677
  287979
  544818
  492125
  827553
  735285
  182352
  722248
  733586
  644307
  489361
  415003
  536915
  623844
  744607
  821162
  638555
  615846
  460194
  396575
  765810
  630621
  433883
  596919
  740965
  562491
  398053
  558171
  649168
  587959
  598504
  739089
  788863
  287540
  499668
  476441
  530063
  639131
  725408
  446698
  555814
  604995
  626082
  443340
  446331
  413235
  622682
  485249
  606377
  483094
  490071
  468592
]
2.66 ms
(2.11%)
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
  182352
  287540
  287979
  396575
  398053
  413235
  415003
  423539
  433883
  443340
  446331
  446698
  460194
  468592
  476441
  483094
  485249
  489361
  490071
  492125
  496647
  499668
  530063
  536915
  544818
  555814
  558171
  562491
  587959
  596919
  598504
  604995
  606377
  615846
  622682
  623844
  626082
  630621
  638555
  639131
  644307
  649168
  722248
  725408
  733586
  735285
  739089
  740965
  744607
  765810
  784814
  788863
  793151
  821162
  826507
  827553
]
1.86 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tight pussy black"
]
1.57 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "tight pussy black"
]
1.49 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "tight pussy black"
]

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.