Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.99 ms
(82.50%)
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
  390402
  395563
  395863
  401073
  404311
  404777
  415189
  415801
  420860
  424197
  424895
  426503
  428488
  436719
  440827
  445741
  454813
  457640
  459654
  460697
  461186
  463792
  466693
  468707
  491609
  491947
  493300
  496565
  507500
  509566
  512800
  512818
  513715
  518553
  518621
  519372
  521589
  528071
  529912
  530799
  533690
  540100
  555834
  557572
  558443
  576966
  590192
  591666
  593865
  597726
  602995
  603678
  607023
  620121
  621392
  625521
  632090
  640388
  651276
  652708
  661896
  668559
  682348
  684200
  687362
  688998
  689521
  699398
  703140
  712278
  720198
  720241
  720659
  720878
  722014
  724853
  725601
  726169
  726366
  727799
  729826
  730947
  733572
  735554
  737130
  737465
  738624
  741076
  742685
  744368
  745556
  746213
  758216
  761088
  761591
  761850
  766623
  770888
  774182
  784308
  791578
  792594
  793877
  794296
  794797
  794817
  796143
  800513
  803463
  805502
  806715
  811870
  812092
  814399
  814606
  814844
  815270
  817482
  823275
  827850
]
16.78 ms
(10.41%)
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
  805502
  761591
  741076
  703140
  602995
  794817
  460697
  420860
  814606
  491609
  512800
  513715
  684200
  720198
  722014
  625521
  632090
  724853
  761850
  774182
  712278
  404311
  426503
  459654
  518621
  491947
  512818
  597726
  758216
  761088
  817482
  815270
  468707
  533690
  540100
  461186
  687362
  661896
  558443
  590192
  791578
  793877
  806715
  725601
  770888
  784308
  726366
  738624
  744368
  735554
  737465
  730947
  737130
  742685
  794797
  800513
  457640
  726169
  445741
  496565
  529912
  688998
  593865
  620121
  603678
  621392
  463792
  424197
  493300
  521589
  404777
  415801
  436719
  668559
  814844
  454813
  466693
  689521
  727799
  733572
  812092
  395563
  395863
  440827
  557572
  682348
  591666
  607023
  794296
  401073
  415189
  509566
  507500
  519372
  576966
  827850
  424895
  814399
  823275
  518553
  530799
  555834
  720659
  651276
  652708
  699398
  720878
  640388
  796143
  811870
  746213
  803463
  729826
  745556
  766623
  720241
  792594
  390402
  428488
  528071
]
4.02 ms
(2.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
  390402
  395563
  395863
  401073
  404311
  404777
  415189
  415801
  420860
  424197
  424895
  426503
  428488
  436719
  440827
  445741
  454813
  457640
  459654
  460697
  461186
  463792
  466693
  468707
  491609
  491947
  493300
  496565
  507500
  509566
  512800
  512818
  513715
  518553
  518621
  519372
  521589
  528071
  529912
  530799
  533690
  540100
  555834
  557572
  558443
  576966
  590192
  591666
  593865
  597726
  602995
  603678
  607023
  620121
  621392
  625521
  632090
  640388
  651276
  652708
  661896
  668559
  682348
  684200
  687362
  688998
  689521
  699398
  703140
  712278
  720198
  720241
  720659
  720878
  722014
  724853
  725601
  726169
  726366
  727799
  729826
  730947
  733572
  735554
  737130
  737465
  738624
  741076
  742685
  744368
  745556
  746213
  758216
  761088
  761591
  761850
  766623
  770888
  774182
  784308
  791578
  792594
  793877
  794296
  794797
  794817
  796143
  800513
  803463
  805502
  806715
  811870
  812092
  814399
  814606
  814844
  815270
  817482
  823275
  827850
]
2.11 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "husband anal"
]
1.84 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "husband анал"
]
1.83 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "husband анал"
]

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.