Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.91 ms
(85.96%)
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
  89346
  337704
  387680
  415957
  416539
  416583
  416708
  417491
  421520
  430374
  432771
  434067
  443242
  443247
  443323
  447305
  447668
  448823
  458114
  467889
  476054
  477074
  478442
  478833
  481150
  485233
  485502
  491608
  491614
  497697
  500725
  511240
  512453
  517416
  518470
  523576
  527921
  530624
  530759
  534546
  536242
  537467
  537654
  537904
  541073
  541654
  541674
  541867
  542512
  542705
  544493
  544823
  545190
  545411
  545455
  548723
  549041
  551063
  552064
  552398
  552800
  555109
  556795
  558819
  562377
  565263
  568267
  569533
  573932
  574386
  575154
  576646
  580122
  580189
  583468
  585960
  586423
  597226
  598115
  599958
  600171
  600215
  600334
  606299
  606546
  609920
  612070
  617969
  619552
  620901
  630582
  633747
  633798
  634509
  649140
  652199
  654086
  654898
  660364
  660380
  675815
  680172
  683291
  694554
  722522
  730692
  735524
  740335
  742286
  742459
  745129
  762257
  785606
  799762
  806789
  809308
  811850
  817510
  818377
  819613
]
15.85 ms
(8.68%)
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
  416539
  430374
  447305
  417491
  512453
  500725
  89346
  818377
  819613
  485233
  491608
  478442
  534546
  537467
  527921
  536242
  545411
  580189
  568267
  573932
  552064
  649140
  652199
  654086
  660380
  683291
  660364
  680172
  694554
  675815
  722522
  548723
  555109
  617969
  598115
  597226
  609920
  620901
  630582
  730692
  742286
  785606
  799762
  745129
  762257
  742459
  735524
  612070
  806789
  811850
  387680
  443242
  511240
  541674
  447668
  517416
  541073
  542512
  599958
  606299
  619552
  634509
  809308
  537654
  337704
  421520
  432771
  530759
  544823
  544493
  574386
  600215
  600334
  518470
  443323
  448823
  586423
  633798
  817510
  458114
  481150
  478833
  497697
  537904
  491614
  545455
  558819
  583468
  541867
  545190
  575154
  541654
  542705
  552398
  565263
  576646
  654898
  549041
  551063
  552800
  556795
  562377
  580122
  606546
  740335
  416708
  476054
  467889
  477074
  485502
  530624
  569533
  633747
  585960
  523576
  600171
  415957
  443247
  434067
  416583
]
2.91 ms
(1.60%)
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
  89346
  337704
  387680
  415957
  416539
  416583
  416708
  417491
  421520
  430374
  432771
  434067
  443242
  443247
  443323
  447305
  447668
  448823
  458114
  467889
  476054
  477074
  478442
  478833
  481150
  485233
  485502
  491608
  491614
  497697
  500725
  511240
  512453
  517416
  518470
  523576
  527921
  530624
  530759
  534546
  536242
  537467
  537654
  537904
  541073
  541654
  541674
  541867
  542512
  542705
  544493
  544823
  545190
  545411
  545455
  548723
  549041
  551063
  552064
  552398
  552800
  555109
  556795
  558819
  562377
  565263
  568267
  569533
  573932
  574386
  575154
  576646
  580122
  580189
  583468
  585960
  586423
  597226
  598115
  599958
  600171
  600215
  600334
  606299
  606546
  609920
  612070
  617969
  619552
  620901
  630582
  633747
  633798
  634509
  649140
  652199
  654086
  654898
  660364
  660380
  675815
  680172
  683291
  694554
  722522
  730692
  735524
  740335
  742286
  742459
  745129
  762257
  785606
  799762
  806789
  809308
  811850
  817510
  818377
  819613
]
2.17 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny anal gape"
]
1.89 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые анал большая большие дырк"
]
1.35 ms
(0.74%)
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.