Query Metrics

7 Database Queries
7 Different statements
183.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
150.89 ms
(82.31%)
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
  61399
  89135
  154451
  154535
  154844
  154972
  155198
  256821
  311892
  340567
  340635
  352189
  369221
  382404
  382578
  383514
  383924
  385390
  387941
  388110
  388642
  388729
  389602
  390150
  391915
  391961
  411454
  413006
  414077
  414268
  419604
  421967
  425948
  432674
  439031
  443340
  444052
  444537
  445727
  454688
  467557
  469691
  471127
  476651
  476656
  480671
  487008
  492000
  492906
  495827
  505093
  506105
  509168
  512442
  514847
  525279
  535159
  535363
  536182
  541484
  542614
  551646
  552704
  554405
  576848
  589549
  590129
  592745
  602203
  605566
  608076
  608516
  623300
  624399
  626492
  638744
  655598
  660043
  660380
  680562
  688166
  691259
  697958
  706359
  706717
  707432
  709674
  739125
  739131
  739799
  747308
  750423
  750568
  752799
  754532
  755422
  760097
  769125
  774179
  777670
  780303
  781251
  782079
  782321
  783008
  783034
  785877
  786416
  791020
  791026
  793136
  796647
  796650
  796696
  799896
  801627
  807582
  808580
  808968
  811048
]
22.25 ms
(12.14%)
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
  383514
  777670
  774179
  590129
  369221
  760097
  781251
  747308
  807582
  154844
  754532
  89135
  796647
  61399
  421967
  811048
  752799
  389602
  154451
  793136
  688166
  154972
  340635
  439031
  382578
  476651
  769125
  552704
  413006
  506105
  589549
  785877
  554405
  382404
  480671
  388110
  783034
  750423
  311892
  445727
  387941
  706717
  444537
  154535
  492906
  592745
  791020
  419604
  155198
  425948
  388729
  411454
  691259
  626492
  608516
  791026
  432674
  443340
  352189
  608076
  492000
  414268
  680562
  796696
  808580
  385390
  623300
  469691
  514847
  660380
  602203
  340567
  390150
  535363
  780303
  525279
  541484
  476656
  750568
  624399
  796650
  414077
  391915
  706359
  256821
  801627
  799896
  808968
  505093
  388642
  551646
  454688
  391961
  383924
  536182
  739131
  576848
  755422
  605566
  487008
  655598
  660043
  697958
  782321
  512442
  444052
  495827
  542614
  739799
  471127
  467557
  709674
  638744
  739125
  707432
  535159
  786416
  782079
  783008
  509168
]
2.50 ms
(1.37%)
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
  61399
  89135
  154451
  154535
  154844
  154972
  155198
  256821
  311892
  340567
  340635
  352189
  369221
  382404
  382578
  383514
  383924
  385390
  387941
  388110
  388642
  388729
  389602
  390150
  391915
  391961
  411454
  413006
  414077
  414268
  419604
  421967
  425948
  432674
  439031
  443340
  444052
  444537
  445727
  454688
  467557
  469691
  471127
  476651
  476656
  480671
  487008
  492000
  492906
  495827
  505093
  506105
  509168
  512442
  514847
  525279
  535159
  535363
  536182
  541484
  542614
  551646
  552704
  554405
  576848
  589549
  590129
  592745
  602203
  605566
  608076
  608516
  623300
  624399
  626492
  638744
  655598
  660043
  660380
  680562
  688166
  691259
  697958
  706359
  706717
  707432
  709674
  739125
  739131
  739799
  747308
  750423
  750568
  752799
  754532
  755422
  760097
  769125
  774179
  777670
  780303
  781251
  782079
  782321
  783008
  783034
  785877
  786416
  791020
  791026
  793136
  796647
  796650
  796696
  799896
  801627
  807582
  808580
  808968
  811048
]
2.33 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "девушки в чулках дилд%…"
]
1.85 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк чулк нижн бел дилд"
]
1.82 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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

No loaded entities.