Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.85 ms
(83.32%)
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
  382061
  392987
  392989
  401398
  419839
  426006
  441646
  447337
  449327
  449333
  454332
  454855
  456807
  467880
  474864
  482636
  483925
  490060
  495639
  496108
  496854
  503342
  507013
  507947
  513092
  513682
  517385
  539548
  548085
  548879
  553240
  555076
  556844
  556871
  559301
  562758
  564461
  566833
  572508
  573286
  576290
  577594
  585950
  586266
  593915
  601602
  603294
  605207
  613263
  614805
  616733
  623512
  627063
  650514
  666418
  666432
  672878
  675148
  676927
  677899
  684489
  689937
  696865
  716247
  724609
  726468
  726503
  726582
  730249
  730396
  730806
  733274
  734345
  734466
  736402
  739938
  740611
  744140
  744169
  744829
  746367
  750469
  757285
  757973
  759738
  762884
  764153
  767957
  775068
  775587
  776503
  785672
  785722
  788811
  788877
  791095
  792348
  792892
  794736
  795045
  795078
  800148
  800185
  803451
  804360
  806090
  814289
  814376
  816188
  818455
  818521
  820149
  820317
  820489
  822295
  824601
  825054
  826350
  827083
  827377
]
15.99 ms
(9.81%)
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
  788877
  775587
  757285
  739938
  827083
  795045
  795078
  800148
  740611
  507013
  447337
  483925
  496854
  562758
  382061
  818521
  820489
  744169
  744829
  746367
  806090
  696865
  764153
  401398
  454855
  490060
  613263
  827377
  816188
  792348
  785672
  744140
  804360
  392987
  820317
  820149
  824601
  826350
  539548
  800185
  814376
  449333
  566833
  392989
  419839
  441646
  426006
  818455
  684489
  822295
  825054
  814289
  482636
  449327
  454332
  456807
  467880
  474864
  507947
  517385
  503342
  513682
  495639
  496108
  513092
  559301
  572508
  576290
  573286
  564461
  577594
  650514
  666418
  675148
  677899
  689937
  716247
  676927
  666432
  672878
  548085
  548879
  553240
  555076
  556844
  556871
  593915
  601602
  605207
  586266
  603294
  616733
  585950
  614805
  623512
  627063
  775068
  791095
  776503
  792892
  803451
  724609
  726503
  733274
  734345
  734466
  785722
  788811
  794736
  730249
  730806
  736402
  750469
  757973
  759738
  762884
  767957
  726468
  726582
  730396
]
3.02 ms
(1.85%)
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
  382061
  392987
  392989
  401398
  419839
  426006
  441646
  447337
  449327
  449333
  454332
  454855
  456807
  467880
  474864
  482636
  483925
  490060
  495639
  496108
  496854
  503342
  507013
  507947
  513092
  513682
  517385
  539548
  548085
  548879
  553240
  555076
  556844
  556871
  559301
  562758
  564461
  566833
  572508
  573286
  576290
  577594
  585950
  586266
  593915
  601602
  603294
  605207
  613263
  614805
  616733
  623512
  627063
  650514
  666418
  666432
  672878
  675148
  676927
  677899
  684489
  689937
  696865
  716247
  724609
  726468
  726503
  726582
  730249
  730396
  730806
  733274
  734345
  734466
  736402
  739938
  740611
  744140
  744169
  744829
  746367
  750469
  757285
  757973
  759738
  762884
  764153
  767957
  775068
  775587
  776503
  785672
  785722
  788811
  788877
  791095
  792348
  792892
  794736
  795045
  795078
  800148
  800185
  803451
  804360
  806090
  814289
  814376
  816188
  818455
  818521
  820149
  820317
  820489
  822295
  824601
  825054
  826350
  827083
  827377
]
2.70 ms
(1.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза pussy"
]
2.08 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "licking-pussy"
]
1.78 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза pussy"
]

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.