Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.00 ms
(87.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
  69842
  330409
  385243
  529389
  531651
  533208
  551090
  555197
  555735
  576766
  585283
  590275
  600664
  612781
  626664
  629618
  633230
  633640
  636500
  639871
  655503
  657748
  660348
  665077
  670914
  676671
  694409
  698723
  698917
  699538
  712573
  716417
  717117
  719152
  719309
  722167
  723701
  725201
  726043
  726444
  727914
  728148
  728871
  728951
  728953
  729050
  734421
  734491
  734657
  736158
  736739
  740541
  748002
  749615
  757887
  758996
  761394
  766964
  768081
  769913
  772371
  775512
  778477
  779692
  780084
  780281
  781516
  781562
  782084
  782897
  784426
  785739
  786528
  787588
  790131
  791814
  792327
  792439
  792941
  794577
  795344
  795805
  795975
  796025
  796660
  797258
  797723
  800039
  800173
  801207
  801501
  802268
  802309
  803439
  804857
  809869
  810351
  810394
  812441
  813903
  817032
  818736
  819133
  819313
  819414
  819728
  823255
  823862
  823876
  825892
  826004
  826006
  826224
  826236
  826583
  826677
  828342
  828540
]
10.66 ms
(6.71%)
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
  810351
  69842
  795975
  551090
  826006
  795805
  790131
  728953
  728871
  736158
  781562
  726043
  748002
  787588
  796025
  385243
  330409
  819728
  823255
  826004
  826224
  826677
  826583
  823876
  813903
  817032
  819414
  819313
  825892
  826236
  818736
  819133
  823862
  828342
  828540
  529389
  533208
  531651
  555197
  555735
  576766
  712573
  717117
  719152
  719309
  655503
  676671
  694409
  698917
  716417
  657748
  660348
  665077
  670914
  674797
  698723
  699538
  722167
  585283
  590275
  629618
  600664
  612781
  633230
  633640
  636500
  639871
  626664
  775512
  778477
  782084
  782897
  786528
  791814
  792439
  794577
  795344
  802268
  802309
  779692
  780084
  780281
  781516
  784426
  785739
  792941
  796660
  797258
  797723
  801501
  803439
  809869
  810394
  812441
  723701
  725201
  734657
  740541
  749615
  757887
  758996
  761394
  766964
  767890
  768081
  769913
  772371
  792327
  800039
  800173
  801207
  804857
  726444
  727914
  728148
  728951
  729050
  734421
  734491
  736739
]
2.86 ms
(1.80%)
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
  69842
  330409
  385243
  529389
  531651
  533208
  551090
  555197
  555735
  576766
  585283
  590275
  600664
  612781
  626664
  629618
  633230
  633640
  636500
  639871
  655503
  657748
  660348
  665077
  670914
  676671
  694409
  698723
  698917
  699538
  712573
  716417
  717117
  719152
  719309
  722167
  723701
  725201
  726043
  726444
  727914
  728148
  728871
  728951
  728953
  729050
  734421
  734491
  734657
  736158
  736739
  740541
  748002
  749615
  757887
  758996
  761394
  766964
  768081
  769913
  772371
  775512
  778477
  779692
  780084
  780281
  781516
  781562
  782084
  782897
  784426
  785739
  786528
  787588
  790131
  791814
  792327
  792439
  792941
  794577
  795344
  795805
  795975
  796025
  796660
  797258
  797723
  800039
  800173
  801207
  801501
  802268
  802309
  803439
  804857
  809869
  810351
  810394
  812441
  813903
  817032
  818736
  819133
  819313
  819414
  819728
  823255
  823862
  823876
  825892
  826004
  826006
  826224
  826236
  826583
  826677
  828342
  828540
]
1.86 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife cumshot"
]
1.72 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен cumshot"
]
1.23 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен cumshot"
]

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.