Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.11 ms
(86.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
  13229
  187956
  194216
  381946
  382874
  389848
  390447
  394433
  415780
  421867
  424448
  440942
  448081
  448887
  458001
  464198
  468017
  470201
  471116
  475278
  479074
  479668
  482947
  488619
  502891
  506865
  513738
  516477
  526074
  528339
  529202
  530438
  530688
  531878
  533022
  534621
  535409
  535454
  548081
  555242
  555274
  555425
  555428
  556341
  557522
  564224
  565142
  570972
  584771
  586828
  589551
  589690
  598306
  599572
  605149
  610473
  614881
  616152
  621536
  628112
  629354
  664486
  667701
  667822
  670904
  674770
  695380
  698496
  699390
  705471
  707309
  710523
  715524
  721890
  724302
  725135
  725596
  727737
  727741
  730085
  730759
  733073
  734522
  735880
  737554
  743822
  744193
  747202
  750294
  760841
  761030
  765227
  766663
  770304
  770946
  774147
  790958
  792667
  793529
  796148
  797734
  799011
  799351
  802147
  804252
  806201
  807609
  812505
  815180
  815408
  815459
  815484
  816063
  816886
  817292
  818468
  821187
  822278
  822421
  826046
]
15.88 ms
(8.12%)
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
  770946
  724302
  725596
  743822
  557522
  570972
  761030
  556341
  815459
  815484
  530438
  530688
  531878
  555428
  555242
  699390
  790958
  766663
  770304
  628112
  698496
  382874
  815180
  822278
  816063
  816886
  821187
  822421
  533022
  534621
  695380
  707309
  715524
  674770
  610473
  599572
  793529
  760841
  734522
  744193
  482947
  464198
  564224
  513738
  589551
  390447
  415780
  448887
  488619
  479668
  381946
  424448
  802147
  804252
  440942
  555425
  670904
  710523
  555274
  565142
  797734
  727737
  629354
  528339
  502891
  799011
  799351
  589690
  479074
  796148
  458001
  468017
  584771
  470201
  421867
  535454
  506865
  516477
  526074
  616152
  475278
  817292
  812505
  529202
  598306
  815408
  818468
  664486
  705471
  614881
  806201
  750294
  735880
  737554
  730759
  765227
  792667
  389848
  621536
  727741
  13229
  471116
  725135
  194216
  187956
  394433
  826046
  448081
  535409
  667701
  667822
  721890
  548081
  586828
  605149
  733073
  807609
  774147
  730085
  747202
]
2.60 ms
(1.33%)
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
  13229
  187956
  194216
  381946
  382874
  389848
  390447
  394433
  415780
  421867
  424448
  440942
  448081
  448887
  458001
  464198
  468017
  470201
  471116
  475278
  479074
  479668
  482947
  488619
  502891
  506865
  513738
  516477
  526074
  528339
  529202
  530438
  530688
  531878
  533022
  534621
  535409
  535454
  548081
  555242
  555274
  555425
  555428
  556341
  557522
  564224
  565142
  570972
  584771
  586828
  589551
  589690
  598306
  599572
  605149
  610473
  614881
  616152
  621536
  628112
  629354
  664486
  667701
  667822
  670904
  674770
  695380
  698496
  699390
  705471
  707309
  710523
  715524
  721890
  724302
  725135
  725596
  727737
  727741
  730085
  730759
  733073
  734522
  735880
  737554
  743822
  744193
  747202
  750294
  760841
  761030
  765227
  766663
  770304
  770946
  774147
  790958
  792667
  793529
  796148
  797734
  799011
  799351
  802147
  804252
  806201
  807609
  812505
  815180
  815408
  815459
  815484
  816063
  816886
  817292
  818468
  821187
  822278
  822421
  826046
]
2.34 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.13 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большие задницы зрелые"
]
1.79 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп зрелая женщин"
]
1.66 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.