Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.13 ms
(82.98%)
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
  450539
  459162
  460259
  461260
  462366
  471370
  474551
  478445
  479750
  479837
  482172
  484829
  488883
  497963
  506301
  508162
  509400
  518740
  524955
  530139
  533840
  533856
  536886
  543413
  543416
  552597
  554360
  554751
  554889
  561365
  574166
  583947
  583995
  584717
  584731
  588262
  589146
  589154
  589208
  595722
  595728
  595765
  595772
  595776
  595817
  598903
  599999
  601657
  603151
  603162
  603242
  604633
  605525
  607155
  614407
  618462
  631913
  633508
  634477
  635486
  643725
  644264
  645232
  645235
  646228
  648259
  648554
  649543
  649964
  650603
  660427
  664321
  665455
  666778
  667230
  669391
  670773
  675236
  675921
  675951
  676309
  676342
  676397
  676895
  676896
  679396
  679441
  679444
  679447
  679471
  681087
  681158
  684126
  688351
  692506
  694212
  696355
  699584
  703538
  706644
  708823
  709784
  710216
  712712
  714193
  715096
  715395
  715507
  716373
  717517
  717724
  717731
  718521
  721990
  775751
  820768
  820778
  822011
  822642
  823501
]
16.68 ms
(10.24%)
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
  820768
  820778
  822011
  822642
  823501
  462366
  471370
  479837
  488883
  482172
  484829
  450539
  459162
  460259
  478445
  479750
  497963
  506301
  518740
  524955
  530139
  533840
  509400
  533856
  536886
  508162
  461260
  474551
  543413
  543416
  554360
  574166
  552597
  554751
  584731
  554889
  646228
  648259
  649964
  650603
  664321
  665455
  669391
  670773
  676397
  679444
  679447
  679471
  709784
  712712
  715096
  715395
  717517
  717724
  721990
  645235
  648554
  660427
  667230
  675951
  676309
  676342
  692506
  696355
  699584
  706644
  714193
  716373
  717731
  718521
  645232
  649543
  666778
  675236
  675921
  676895
  676896
  679396
  679441
  681087
  681158
  684126
  688351
  694212
  703538
  708823
  710216
  715507
  561365
  583947
  583995
  584717
  589154
  595728
  598903
  603162
  603242
  604633
  631913
  644264
  588262
  589208
  595722
  595765
  595776
  599999
  634477
  635486
  643725
  589146
  595817
  601657
  603151
  595772
  605525
  607155
  614407
  618462
  633508
  775751
]
2.65 ms
(1.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.61 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
  450539
  459162
  460259
  461260
  462366
  471370
  474551
  478445
  479750
  479837
  482172
  484829
  488883
  497963
  506301
  508162
  509400
  518740
  524955
  530139
  533840
  533856
  536886
  543413
  543416
  552597
  554360
  554751
  554889
  561365
  574166
  583947
  583995
  584717
  584731
  588262
  589146
  589154
  589208
  595722
  595728
  595765
  595772
  595776
  595817
  598903
  599999
  601657
  603151
  603162
  603242
  604633
  605525
  607155
  614407
  618462
  631913
  633508
  634477
  635486
  643725
  644264
  645232
  645235
  646228
  648259
  648554
  649543
  649964
  650603
  660427
  664321
  665455
  666778
  667230
  669391
  670773
  675236
  675921
  675951
  676309
  676342
  676397
  676895
  676896
  679396
  679441
  679444
  679447
  679471
  681087
  681158
  684126
  688351
  692506
  694212
  696355
  699584
  703538
  706644
  708823
  709784
  710216
  712712
  714193
  715096
  715395
  715507
  716373
  717517
  717724
  717731
  718521
  721990
  775751
  820768
  820778
  822011
  822642
  823501
]
2.30 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boobs group"
]
1.79 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boobs group"
]
1.70 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boobs group"
]

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.