Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.72 ms
(86.65%)
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
  271293
  285321
  382278
  383722
  385476
  385710
  386062
  388115
  396042
  408249
  411688
  411710
  414135
  421550
  423609
  423630
  426301
  428966
  429479
  434325
  442198
  444776
  448350
  453114
  453992
  457498
  460156
  460960
  464022
  464598
  468927
  469759
  482231
  483978
  484117
  484803
  490107
  491487
  493156
  496479
  500815
  504937
  507243
  508206
  512813
  512956
  514920
  521374
  524178
  524813
  529164
  540176
  551951
  552913
  555153
  562109
  562904
  562959
  565062
  565931
  568332
  570382
  585155
  585198
  585318
  593878
  596134
  597058
  598783
  602448
  604106
  605661
  605765
  607385
  614789
  617552
  618404
  620912
  639140
  660426
  663561
  670663
  670904
  681182
  681286
  686069
  688554
  695913
  696115
  706467
  708886
  710061
  715632
  718829
  719128
  721230
  730111
  733178
  734789
  737113
  738749
  742480
  748142
  750110
  750195
  755108
  755388
  768878
  773226
  782398
  782404
  790813
  796027
  796543
  801206
  811560
  811950
  814178
  817878
  823940
]
15.82 ms
(7.98%)
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
  715632
  663561
  710061
  605765
  617552
  585198
  614789
  782398
  796027
  801206
  773226
  734789
  738749
  750110
  755388
  750195
  444776
  448350
  453992
  504937
  524813
  507243
  570382
  396042
  434325
  464598
  493156
  490107
  811560
  565931
  607385
  285321
  817878
  823940
  469759
  484803
  529164
  496479
  514920
  555153
  670663
  706467
  719128
  670904
  602448
  639140
  585318
  596134
  585155
  597058
  620912
  730111
  733178
  742480
  737113
  768878
  782404
  796543
  428966
  483978
  468927
  605661
  411688
  414135
  429479
  491487
  562109
  562904
  593878
  442198
  426301
  457498
  484117
  524178
  386062
  383722
  382278
  540176
  512956
  521374
  551951
  568332
  562959
  565062
  681286
  686069
  688554
  708886
  695913
  718829
  660426
  681182
  696115
  721230
  552913
  598783
  618404
  604106
  790813
  811950
  748142
  755108
  385710
  385476
  271293
  388115
  408249
  423609
  423630
  411710
  421550
  814178
  453114
  460156
  460960
  464022
  482231
  512813
  508206
  500815
]
2.94 ms
(1.49%)
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
  271293
  285321
  382278
  383722
  385476
  385710
  386062
  388115
  396042
  408249
  411688
  411710
  414135
  421550
  423609
  423630
  426301
  428966
  429479
  434325
  442198
  444776
  448350
  453114
  453992
  457498
  460156
  460960
  464022
  464598
  468927
  469759
  482231
  483978
  484117
  484803
  490107
  491487
  493156
  496479
  500815
  504937
  507243
  508206
  512813
  512956
  514920
  521374
  524178
  524813
  529164
  540176
  551951
  552913
  555153
  562109
  562904
  562959
  565062
  565931
  568332
  570382
  585155
  585198
  585318
  593878
  596134
  597058
  598783
  602448
  604106
  605661
  605765
  607385
  614789
  617552
  618404
  620912
  639140
  660426
  663561
  670663
  670904
  681182
  681286
  686069
  688554
  695913
  696115
  706467
  708886
  710061
  715632
  718829
  719128
  721230
  730111
  733178
  734789
  737113
  738749
  742480
  748142
  750110
  750195
  755108
  755388
  768878
  773226
  782398
  782404
  790813
  796027
  796543
  801206
  811560
  811950
  814178
  817878
  823940
]
2.16 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard hairy"
]
1.98 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard волосатая"
]
1.89 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard волосатая"
]

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.