Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
332.64 ms
(94.29%)
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
  193462
  398683
  403027
  407165
  420829
  427053
  438682
  441118
  448497
  449181
  458277
  460245
  472571
  481119
  488900
  488908
  496004
  497013
  497629
  529691
  537166
  537171
  540590
  574020
  609081
  636477
  692733
  697217
  701235
  704943
  710189
  712146
  713153
  714563
  714794
  718017
  722125
  728464
  728556
  730526
  730835
  732984
  733425
  734439
  736326
  740573
  741319
  741683
  741853
  742133
  742657
  743860
  744154
  751004
  751345
  754978
  756975
  757237
  761728
  767519
  767547
  768049
  768719
  768876
  769495
  771903
  772606
  773054
  773291
  773351
  775590
  775624
  775647
  780028
  780323
  783707
  790447
  792940
  794756
  794908
  795070
  795370
  795825
  795889
  796589
  798769
  801018
  801614
  801842
  804405
  804411
  804699
  809715
  810174
  810311
  810324
  810372
  810381
  812140
  812147
  813359
  813991
  816152
  818722
  819891
  820011
  820020
  823580
  823719
  824554
  824642
  826832
  827011
  827048
  827394
  827439
  827494
  827578
  827627
  827711
]
10.37 ms
(2.94%)
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
  773351
  728464
  730526
  730835
  734439
  736326
  740573
  741853
  744154
  751345
  754978
  761728
  767519
  768049
  768719
  728556
  733425
  741319
  741683
  742133
  743860
  756975
  767547
  769495
  771903
  773054
  773291
  701235
  712146
  713153
  714794
  718017
  722125
  775590
  775624
  775647
  780028
  780323
  783707
  790447
  792940
  794756
  794908
  795070
  795370
  796589
  798769
  801614
  801842
  804699
  809715
  810174
  810311
  810372
  810381
  812140
  813359
  403027
  398683
  697217
  801018
  193462
  827578
  827711
  537166
  574020
  714563
  609081
  772606
  810324
  751004
  420829
  449181
  804411
  757237
  812147
  732984
  742657
  768876
  704943
  710189
  804405
  427053
  496004
  692733
  795825
  636477
  795889
  407165
  438682
  441118
  818722
  813991
  820011
  824554
  826832
  827011
  827439
  827627
  827394
  827494
  816152
  819891
  820020
  823719
  823580
  824642
  827048
  472571
  458277
  460245
  481119
  488900
  448497
  488908
  497013
  497629
  529691
  537171
  540590
]
2.88 ms
(0.82%)
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
  193462
  398683
  403027
  407165
  420829
  427053
  438682
  441118
  448497
  449181
  458277
  460245
  472571
  481119
  488900
  488908
  496004
  497013
  497629
  529691
  537166
  537171
  540590
  574020
  609081
  636477
  692733
  697217
  701235
  704943
  710189
  712146
  713153
  714563
  714794
  718017
  722125
  728464
  728556
  730526
  730835
  732984
  733425
  734439
  736326
  740573
  741319
  741683
  741853
  742133
  742657
  743860
  744154
  751004
  751345
  754978
  756975
  757237
  761728
  767519
  767547
  768049
  768719
  768876
  769495
  771903
  772606
  773054
  773291
  773351
  775590
  775624
  775647
  780028
  780323
  783707
  790447
  792940
  794756
  794908
  795070
  795370
  795825
  795889
  796589
  798769
  801018
  801614
  801842
  804405
  804411
  804699
  809715
  810174
  810311
  810324
  810372
  810381
  812140
  812147
  813359
  813991
  816152
  818722
  819891
  820011
  820020
  823580
  823719
  824554
  824642
  826832
  827011
  827048
  827394
  827439
  827494
  827578
  827627
  827711
]
2.01 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "orgasm wife"
]
1.77 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "orgasm жен"
]
1.56 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.