Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.33 ms
(87.53%)
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
  12775
  58408
  121824
  387604
  390049
  390717
  392415
  396037
  397985
  401552
  401555
  401865
  403061
  403560
  403759
  411834
  414116
  420082
  425824
  432737
  441245
  441844
  441864
  445554
  445582
  446697
  450840
  455929
  466658
  472274
  475482
  490168
  501137
  505061
  531882
  536427
  540021
  547136
  551756
  563237
  563326
  577514
  588446
  589137
  590121
  592902
  593149
  595561
  600543
  606950
  626376
  628642
  629194
  630259
  630679
  632048
  632108
  635124
  636673
  637309
  643264
  643777
  649776
  654257
  655184
  666730
  676327
  676381
  677189
  678959
  681936
  687908
  693593
  696514
  710689
  724444
  727474
  750727
  758476
  759384
  760739
  761066
  764344
  766666
  769502
  773791
  774293
  784144
  784337
  784933
  787104
  787742
  790801
  793727
  796607
  799467
  801010
  804283
  804596
  804979
  807995
  810214
  810215
  810262
  810894
  810993
  814958
  818577
  818853
  819081
  820342
  821142
  821153
  821627
  821643
  822608
  822951
  823050
  823324
  828172
]
12.66 ms
(6.59%)
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
  810215
  804283
  724444
  630259
  796607
  810993
  401555
  818577
  446697
  676381
  790801
  774293
  761066
  769502
  445554
  390049
  727474
  632108
  455929
  600543
  635124
  588446
  807995
  750727
  766666
  629194
  403560
  760739
  472274
  121824
  822951
  818853
  823324
  821643
  773791
  414116
  531882
  441864
  505061
  441245
  432737
  466658
  403061
  821627
  823050
  501137
  547136
  563237
  551756
  563326
  654257
  655184
  710689
  649776
  676327
  693593
  632048
  606950
  643777
  595561
  628642
  636673
  637309
  643264
  593149
  804596
  810262
  758476
  784144
  784933
  810894
  764344
  759384
  804979
  397985
  828172
  687908
  401865
  403759
  799467
  58408
  450840
  540021
  666730
  677189
  696514
  787742
  810214
  445582
  390717
  475482
  401552
  425824
  12775
  490168
  577514
  592902
  590121
  411834
  678959
  681936
  589137
  793727
  784337
  441844
  396037
  821142
  821153
  822608
  820342
  819081
  630679
  801010
  787104
  420082
  387604
  814958
  536427
  626376
  392415
]
3.78 ms
(1.96%)
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
  12775
  58408
  121824
  387604
  390049
  390717
  392415
  396037
  397985
  401552
  401555
  401865
  403061
  403560
  403759
  411834
  414116
  420082
  425824
  432737
  441245
  441844
  441864
  445554
  445582
  446697
  450840
  455929
  466658
  472274
  475482
  490168
  501137
  505061
  531882
  536427
  540021
  547136
  551756
  563237
  563326
  577514
  588446
  589137
  590121
  592902
  593149
  595561
  600543
  606950
  626376
  628642
  629194
  630259
  630679
  632048
  632108
  635124
  636673
  637309
  643264
  643777
  649776
  654257
  655184
  666730
  676327
  676381
  677189
  678959
  681936
  687908
  693593
  696514
  710689
  724444
  727474
  750727
  758476
  759384
  760739
  761066
  764344
  766666
  769502
  773791
  774293
  784144
  784337
  784933
  787104
  787742
  790801
  793727
  796607
  799467
  801010
  804283
  804596
  804979
  807995
  810214
  810215
  810262
  810894
  810993
  814958
  818577
  818853
  819081
  820342
  821142
  821153
  821627
  821643
  822608
  822951
  823050
  823324
  828172
]
2.06 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina big ass"
]
1.94 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская большая большие жоп"
]
1.67 ms
(0.87%)
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.