Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.46 ms
(83.78%)
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
  397664
  400497
  417783
  418519
  420565
  423783
  424002
  426238
  426465
  428229
  435027
  438127
  438454
  439274
  439322
  439526
  443085
  444180
  446054
  452373
  454412
  456170
  462236
  462840
  470585
  473515
  478969
  479472
  479746
  485980
  490070
  493300
  493961
  495319
  507217
  507638
  509168
  509566
  509664
  509970
  510425
  513502
  516718
  517261
  518552
  518611
  519354
  520649
  523762
  523884
  524859
  525785
  525884
  526173
  526293
  528143
  528452
  528727
  531599
  532729
  534604
  537051
  537377
  537777
  542090
  549554
  550817
  554210
  554234
  556009
  556015
  556481
  557226
  559777
  561273
  561909
  562878
  563363
  565986
  567548
  571277
  581021
  581225
  581478
  584200
  586385
  586861
  587576
  591275
  594549
  598136
  601862
  605858
  606576
  612171
  613499
  615674
  625127
  643933
  662405
  666133
  672229
  697000
  701904
  711341
  711354
  716915
  716921
  727692
  733446
  760443
  775271
  784593
  796804
  796881
  797078
  797241
  798763
  810103
  812564
]
14.18 ms
(9.86%)
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
  537051
  525785
  531599
  534604
  537777
  542090
  563363
  565986
  571277
  581021
  581478
  549554
  561909
  662405
  584200
  586861
  601862
  612171
  587576
  598136
  605858
  810103
  797078
  812564
  760443
  733446
  727692
  613499
  784593
  420565
  438454
  438127
  439274
  444180
  473515
  509168
  485980
  520649
  523884
  456170
  495319
  561273
  567548
  526173
  493961
  507638
  525884
  697000
  426465
  439322
  452373
  454412
  532729
  550817
  556481
  562878
  554234
  666133
  581225
  606576
  625127
  796881
  796804
  424002
  462236
  417783
  439526
  470585
  428229
  528143
  493300
  509566
  518552
  519354
  523762
  507217
  537377
  557226
  418519
  509664
  509970
  516718
  672229
  443085
  490070
  526293
  517261
  556015
  559777
  594549
  615674
  586385
  797241
  479472
  400497
  426238
  435027
  510425
  513502
  397664
  711354
  716915
  798763
  479746
  556009
  423783
  518611
  446054
  554210
  591275
  643933
  462840
  478969
  524859
  528727
  716921
  701904
  775271
  711341
  528452
]
2.85 ms
(1.98%)
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
  397664
  400497
  417783
  418519
  420565
  423783
  424002
  426238
  426465
  428229
  435027
  438127
  438454
  439274
  439322
  439526
  443085
  444180
  446054
  452373
  454412
  456170
  462236
  462840
  470585
  473515
  478969
  479472
  479746
  485980
  490070
  493300
  493961
  495319
  507217
  507638
  509168
  509566
  509664
  509970
  510425
  513502
  516718
  517261
  518552
  518611
  519354
  520649
  523762
  523884
  524859
  525785
  525884
  526173
  526293
  528143
  528452
  528727
  531599
  532729
  534604
  537051
  537377
  537777
  542090
  549554
  550817
  554210
  554234
  556009
  556015
  556481
  557226
  559777
  561273
  561909
  562878
  563363
  565986
  567548
  571277
  581021
  581225
  581478
  584200
  586385
  586861
  587576
  591275
  594549
  598136
  601862
  605858
  606576
  612171
  613499
  615674
  625127
  643933
  662405
  666133
  672229
  697000
  701904
  711341
  711354
  716915
  716921
  727692
  733446
  760443
  775271
  784593
  796804
  796881
  797078
  797241
  798763
  810103
  812564
]
1.79 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation home"
]
1.56 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац home"
]
1.49 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мастурбац home"
]
1.45 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.