Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
180.28 ms
(87.43%)
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
  96109
  382747
  388878
  389418
  390402
  396983
  403230
  403294
  405324
  405360
  405921
  407177
  407494
  410366
  416928
  417634
  425336
  425809
  426236
  432172
  433477
  433703
  433808
  435443
  445565
  451302
  453159
  453178
  459263
  460954
  466640
  467612
  467773
  469300
  470244
  470604
  471323
  474094
  478484
  481348
  483392
  485229
  486516
  496784
  512069
  512217
  517849
  526162
  531493
  532158
  534275
  534300
  544318
  544485
  549411
  553257
  559864
  563903
  564767
  564800
  575338
  581354
  586372
  587470
  592500
  598185
  604984
  606745
  607637
  618483
  619406
  624260
  630309
  631930
  633045
  633132
  633133
  637664
  640696
  666695
  667486
  667859
  671763
  682129
  683906
  684030
  684200
  692315
  697266
  699053
  703039
  705988
  706286
  715676
  716244
  721090
  727744
  730098
  732029
  742484
  766605
  769971
  784247
  799180
  807707
  814112
  814912
  815347
  815367
  815755
  816541
  816547
  816882
  816958
  817865
  818229
  820335
  820388
  820529
  821409
]
16.48 ms
(7.99%)
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
  606745
  618483
  766605
  727744
  703039
  706286
  390402
  459263
  388878
  405324
  405360
  466640
  467773
  512069
  633045
  607637
  640696
  382747
  403230
  416928
  815367
  820388
  815755
  821409
  814912
  816541
  816547
  820335
  815347
  460954
  469300
  471323
  534275
  474094
  478484
  544318
  559864
  549411
  563903
  564767
  666695
  671763
  684200
  697266
  705988
  716244
  683906
  684030
  692315
  564800
  592500
  633132
  586372
  637664
  784247
  799180
  732029
  769971
  715676
  483392
  396983
  407177
  410366
  817865
  818229
  814112
  526162
  534300
  544485
  667859
  682129
  699053
  721090
  575338
  581354
  587470
  598185
  619406
  624260
  630309
  742484
  730098
  470244
  445565
  96109
  816958
  467612
  553257
  604984
  417634
  389418
  453159
  407494
  433477
  631930
  481348
  496784
  486516
  425336
  425809
  470604
  433703
  435443
  816882
  453178
  451302
  532158
  512217
  485229
  667486
  633133
  807707
  432172
  426236
  403294
  517849
  433808
  820529
  531493
  405921
]
3.35 ms
(1.63%)
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
  96109
  382747
  388878
  389418
  390402
  396983
  403230
  403294
  405324
  405360
  405921
  407177
  407494
  410366
  416928
  417634
  425336
  425809
  426236
  432172
  433477
  433703
  433808
  435443
  445565
  451302
  453159
  453178
  459263
  460954
  466640
  467612
  467773
  469300
  470244
  470604
  471323
  474094
  478484
  481348
  483392
  485229
  486516
  496784
  512069
  512217
  517849
  526162
  531493
  532158
  534275
  534300
  544318
  544485
  549411
  553257
  559864
  563903
  564767
  564800
  575338
  581354
  586372
  587470
  592500
  598185
  604984
  606745
  607637
  618483
  619406
  624260
  630309
  631930
  633045
  633132
  633133
  637664
  640696
  666695
  667486
  667859
  671763
  682129
  683906
  684030
  684200
  692315
  697266
  699053
  703039
  705988
  706286
  715676
  716244
  721090
  727744
  730098
  732029
  742484
  766605
  769971
  784247
  799180
  807707
  814112
  814912
  815347
  815367
  815755
  816541
  816547
  816882
  816958
  817865
  818229
  820335
  820388
  820529
  821409
]
1.71 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая секс втро"
]
1.63 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy threesome"
]
1.50 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.26 ms
(0.61%)
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.