Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.03 ms
(80.33%)
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
  95915
  96347
  96872
  118234
  154257
  183506
  187786
  196624
  388470
  389623
  390653
  391916
  391994
  395707
  397302
  398426
  415548
  417386
  421604
  424294
  430432
  439071
  441733
  441925
  448887
  458819
  465177
  470126
  474891
  479668
  491114
  494295
  495321
  510264
  513992
  526061
  526653
  526938
  545434
  548465
  580069
  591805
  598115
  601542
  604427
  605172
  606503
  613021
  613825
  614026
  615946
  618267
  619108
  619996
  624197
  626575
  626803
  628113
  628485
  630096
  632663
  639810
  660369
  664166
  668690
  670360
  671008
  672913
  672952
  683284
  695249
  695871
  695887
  699397
  712553
  713508
  716522
  717859
  722388
  724309
  725400
  740844
  742304
  742318
  742320
  749090
  750668
  751609
  752598
  752641
  752651
  752666
  752679
  752697
  757350
  758785
  758786
  759370
  761608
  761719
  762774
  782789
  784308
  791930
  794669
  795404
  795420
  796333
  796675
  796703
  796859
  796905
  799362
  801414
  803243
  806864
  806943
  807597
  809811
  818387
]
22.96 ms
(13.66%)
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
  660369
  670360
  671008
  672952
  716522
  717859
  664166
  668690
  695249
  695871
  695887
  713508
  545434
  548465
  580069
  605172
  606503
  598115
  601542
  613021
  619996
  624197
  591805
  615946
  628113
  628485
  614026
  619108
  795404
  796703
  782789
  794669
  795420
  796333
  807597
  742320
  749090
  752641
  752697
  784308
  806943
  809811
  752679
  758785
  752666
  758786
  724309
  725400
  742304
  742318
  751609
  757350
  761608
  750668
  752598
  752651
  759370
  604427
  613825
  722388
  791930
  796675
  796905
  799362
  95915
  391994
  397302
  417386
  196624
  474891
  154257
  183506
  395707
  96872
  118234
  391916
  441925
  458819
  465177
  470126
  526938
  495321
  510264
  526653
  494295
  526061
  683284
  801414
  740844
  672913
  630096
  415548
  712553
  626575
  626803
  803243
  762774
  761719
  421604
  390653
  398426
  699397
  639810
  632663
  448887
  513992
  479668
  187786
  389623
  491114
  796859
  806864
  618267
  96347
  388470
  439071
  424294
  430432
  441733
  818387
]
2.72 ms
(1.62%)
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
  95915
  96347
  96872
  118234
  154257
  183506
  187786
  196624
  388470
  389623
  390653
  391916
  391994
  395707
  397302
  398426
  415548
  417386
  421604
  424294
  430432
  439071
  441733
  441925
  448887
  458819
  465177
  470126
  474891
  479668
  491114
  494295
  495321
  510264
  513992
  526061
  526653
  526938
  545434
  548465
  580069
  591805
  598115
  601542
  604427
  605172
  606503
  613021
  613825
  614026
  615946
  618267
  619108
  619996
  624197
  626575
  626803
  628113
  628485
  630096
  632663
  639810
  660369
  664166
  668690
  670360
  671008
  672913
  672952
  683284
  695249
  695871
  695887
  699397
  712553
  713508
  716522
  717859
  722388
  724309
  725400
  740844
  742304
  742318
  742320
  749090
  750668
  751609
  752598
  752641
  752651
  752666
  752679
  752697
  757350
  758785
  758786
  759370
  761608
  761719
  762774
  782789
  784308
  791930
  794669
  795404
  795420
  796333
  796675
  796703
  796859
  796905
  799362
  801414
  803243
  806864
  806943
  807597
  809811
  818387
]
2.04 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жесткое с мамкам"
]
2.03 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор мам женщин"
]
1.72 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.95%)
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.