Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
373.57 ms
(93.95%)
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
  182110
  209216
  384588
  398124
  403850
  410356
  418132
  423861
  433418
  434885
  437950
  444081
  444430
  444485
  446579
  449297
  450874
  452997
  478992
  498554
  521799
  523751
  525293
  537166
  540590
  541043
  551600
  554693
  561052
  565834
  574125
  577023
  581930
  583727
  589545
  602023
  627414
  631246
  636493
  642999
  646074
  648931
  655452
  659429
  664181
  665076
  666981
  669320
  669858
  671559
  676555
  680597
  683257
  689057
  689871
  692914
  693267
  693695
  695549
  701235
  702639
  704587
  704629
  710092
  712303
  713750
  717145
  719422
  734251
  739908
  749564
  760093
  760170
  768725
  773291
  773747
  775624
  775647
  780028
  780080
  780099
  782535
  783707
  784125
  786500
  788874
  789236
  792940
  795012
  795370
  795889
  796375
  796589
  798769
  801842
  803026
  803385
  804699
  809715
  809731
  809917
  810174
  810182
  810372
  810381
  812296
  812695
  813359
  813643
  818722
  819842
  819891
  820011
  820020
  823719
  824554
  826832
  827394
  827439
  827578
]
15.25 ms
(3.84%)
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
  773291
  602023
  642999
  701235
  775624
  775647
  780028
  783707
  786500
  789236
  792940
  795370
  796589
  798769
  801842
  804699
  809715
  809731
  810174
  810182
  810372
  810381
  812695
  813359
  209216
  565834
  444081
  437950
  418132
  452997
  449297
  384588
  182110
  398124
  410356
  444485
  819842
  525293
  574125
  780080
  795012
  796375
  803026
  803385
  739908
  749564
  760170
  704587
  712303
  717145
  782535
  784125
  809917
  423861
  433418
  434885
  444430
  446579
  450874
  478992
  523751
  521799
  683257
  664181
  666981
  627414
  636493
  631246
  780099
  795889
  812296
  734251
  760093
  768725
  773747
  788874
  403850
  813643
  818722
  820011
  824554
  826832
  827439
  827578
  827394
  819891
  820020
  823719
  540590
  498554
  537166
  551600
  577023
  581930
  541043
  554693
  561052
  655452
  665076
  671559
  680597
  693267
  702639
  713750
  646074
  669320
  669858
  689057
  692914
  693695
  704629
  710092
  648931
  659429
  676555
  689871
  695549
  719422
  583727
  589545
]
2.36 ms
(0.59%)
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
  182110
  209216
  384588
  398124
  403850
  410356
  418132
  423861
  433418
  434885
  437950
  444081
  444430
  444485
  446579
  449297
  450874
  452997
  478992
  498554
  521799
  523751
  525293
  537166
  540590
  541043
  551600
  554693
  561052
  565834
  574125
  577023
  581930
  583727
  589545
  602023
  627414
  631246
  636493
  642999
  646074
  648931
  655452
  659429
  664181
  665076
  666981
  669320
  669858
  671559
  676555
  680597
  683257
  689057
  689871
  692914
  693267
  693695
  695549
  701235
  702639
  704587
  704629
  710092
  712303
  713750
  717145
  719422
  734251
  739908
  749564
  760093
  760170
  768725
  773291
  773747
  775624
  775647
  780028
  780080
  780099
  782535
  783707
  784125
  786500
  788874
  789236
  792940
  795012
  795370
  795889
  796375
  796589
  798769
  801842
  803026
  803385
  804699
  809715
  809731
  809917
  810174
  810182
  810372
  810381
  812296
  812695
  813359
  813643
  818722
  819842
  819891
  820011
  820020
  823719
  824554
  826832
  827394
  827439
  827578
]
1.86 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam masturbation orgasm"
]
1.66 ms
(0.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер мастурбац orgasm"
]
1.41 ms
(0.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер мастурбац orgasm"
]

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.