Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.70 ms
(85.16%)
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
  398447
  420696
  420734
  420862
  420879
  434163
  435016
  437137
  437296
  439516
  440257
  440747
  447225
  449046
  450861
  451660
  454966
  455645
  456126
  456816
  457129
  457349
  459332
  460349
  462292
  463614
  463705
  463913
  464305
  464582
  464750
  469648
  471759
  473915
  475000
  476485
  477156
  480011
  480079
  486134
  487650
  488858
  488905
  489652
  489702
  490198
  491372
  493310
  493933
  495324
  503009
  506898
  507107
  512996
  516538
  517324
  517625
  523653
  525950
  526330
  526353
  527931
  529522
  534568
  534571
  534913
  537278
  537287
  540247
  540553
  540916
  546756
  548023
  552369
  555698
  557548
  557744
  561894
  561927
  569655
  572683
  577679
  578261
  583770
  586427
  587444
  589391
  590689
  594380
  600736
  603704
  609723
  609759
  614209
  614611
  617026
  618239
  624013
  625436
  628256
  630328
  632020
  635627
  644764
  645270
  651836
  663347
  710259
  728087
  773582
  780201
  807326
]
16.54 ms
(9.28%)
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
  586427
  435016
  451660
  529522
  516538
  489702
  710259
  569655
  480011
  609723
  471759
  534568
  557744
  495324
  555698
  594380
  469648
  493933
  455645
  540916
  590689
  420862
  780201
  557548
  503009
  487650
  475000
  420734
  525950
  457349
  517625
  464582
  506898
  488905
  583770
  589391
  488858
  454966
  587444
  440257
  456126
  464750
  534571
  491372
  456816
  457129
  523653
  398447
  440747
  561894
  773582
  728087
  420696
  460349
  537287
  651836
  644764
  577679
  609759
  439516
  464305
  486134
  572683
  434163
  617026
  517324
  537278
  450861
  462292
  578261
  540553
  630328
  447225
  561927
  614209
  807326
  420879
  527931
  437296
  526330
  463913
  628256
  463705
  476485
  540247
  490198
  489652
  473915
  437137
  546756
  477156
  507107
  512996
  548023
  625436
  480079
  645270
  624013
  603704
  449046
  552369
  526353
  463614
  534913
  635627
  618239
  459332
  493310
  632020
  614611
  600736
  663347
]
2.72 ms
(1.53%)
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
  398447
  420696
  420734
  420862
  420879
  434163
  435016
  437137
  437296
  439516
  440257
  440747
  447225
  449046
  450861
  451660
  454966
  455645
  456126
  456816
  457129
  457349
  459332
  460349
  462292
  463614
  463705
  463913
  464305
  464582
  464750
  469648
  471759
  473915
  475000
  476485
  477156
  480011
  480079
  486134
  487650
  488858
  488905
  489652
  489702
  490198
  491372
  493310
  493933
  495324
  503009
  506898
  507107
  512996
  516538
  517324
  517625
  523653
  525950
  526330
  526353
  527931
  529522
  534568
  534571
  534913
  537278
  537287
  540247
  540553
  540916
  546756
  548023
  552369
  555698
  557548
  557744
  561894
  561927
  569655
  572683
  577679
  578261
  583770
  586427
  587444
  589391
  590689
  594380
  600736
  603704
  609723
  609759
  614209
  614611
  617026
  618239
  624013
  625436
  628256
  630328
  632020
  635627
  644764
  645270
  651836
  663347
  710259
  728087
  773582
  780201
  807326
]
1.92 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "risky blowjob"
]
1.85 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "risky минет оральн секс"
]
1.73 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "risky минет оральн секс"
]
1.69 ms
(0.95%)
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.