Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.05 ms
(82.54%)
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
  385292
  405809
  417940
  418368
  447790
  450630
  451861
  454000
  458914
  465608
  466104
  468012
  473848
  474264
  476375
  476774
  478471
  481364
  482918
  486303
  487172
  488217
  489283
  489417
  490198
  490227
  490250
  494276
  504895
  509746
  513129
  513491
  521798
  522011
  522057
  522441
  524027
  525022
  525597
  526353
  526751
  529567
  534461
  536924
  537400
  544381
  546741
  548046
  551752
  554646
  556489
  562029
  563747
  564596
  567053
  567192
  567350
  569000
  580449
  583592
  584090
  584929
  593729
  597477
  602944
  615029
  617145
  619724
  619972
  636958
  638967
  639235
  644059
  645943
  649861
  650823
  661977
  668710
  670745
  674550
  676486
  676507
  676529
  677055
  677130
  677136
  679632
  682639
  689166
  693629
  702284
  710614
  715680
  719260
  720387
  727605
  729402
  731921
  736319
  740493
  741282
  750289
  750498
  761666
  772061
  778128
  780015
  805341
  813929
  823656
  824387
  825574
  825781
  826184
  828414
]
15.91 ms
(11.13%)
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
  602944
  615029
  466104
  490227
  513129
  478471
  526751
  562029
  597477
  385292
  522057
  489417
  476375
  513491
  447790
  548046
  474264
  522011
  525022
  639235
  465608
  454000
  650823
  522441
  584090
  554646
  468012
  486303
  458914
  481364
  567350
  450630
  494276
  569000
  544381
  504895
  593729
  490198
  670745
  521798
  526353
  488217
  564596
  546741
  584929
  638967
  529567
  567053
  556489
  536924
  719260
  823656
  813929
  617145
  676529
  676507
  727605
  772061
  534461
  702284
  677136
  689166
  761666
  750498
  405809
  476774
  679632
  825781
  674550
  805341
  780015
  677055
  715680
  482918
  677130
  619972
  418368
  826184
  487172
  710614
  729402
  736319
  509746
  740493
  490250
  583592
  417940
  828156
  563747
  525597
  551752
  661977
  524027
  682639
  676486
  580449
  644059
  567192
  693629
  741282
  537400
  636958
  473848
  825574
  731921
  828414
  828624
  668710
  489283
  825504
  824605
  824205
  645943
  451861
  720387
  619724
  750289
  778128
  824387
  649861
]
2.37 ms
(1.66%)
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
  385292
  405809
  417940
  418368
  447790
  450630
  451861
  454000
  458914
  465608
  466104
  468012
  473848
  474264
  476375
  476774
  478471
  481364
  482918
  486303
  487172
  488217
  489283
  489417
  490198
  490227
  490250
  494276
  504895
  509746
  513129
  513491
  521798
  522011
  522057
  522441
  524027
  525022
  525597
  526353
  526751
  529567
  534461
  536924
  537400
  544381
  546741
  548046
  551752
  554646
  556489
  562029
  563747
  564596
  567053
  567192
  567350
  569000
  580449
  583592
  584090
  584929
  593729
  597477
  602944
  615029
  617145
  619724
  619972
  636958
  638967
  639235
  644059
  645943
  649861
  650823
  661977
  668710
  670745
  674550
  676486
  676507
  676529
  677055
  677130
  677136
  679632
  682639
  689166
  693629
  702284
  710614
  715680
  719260
  720387
  727605
  729402
  731921
  736319
  740493
  741282
  750289
  750498
  761666
  772061
  778128
  780015
  805341
  813929
  823656
  824387
  825574
  825781
  826184
  828414
]
1.97 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl fucked"
]
1.82 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк fucked"
]
1.46 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк fucked"
]
1.43 ms
(1.00%)
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.