Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.71 ms
(89.99%)
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
  542912
  545833
  575300
  585161
  651322
  655561
  684681
  710689
  715098
  715484
  717459
  718007
  718017
  718029
  720808
  723124
  723242
  724700
  729802
  730408
  732634
  732789
  732956
  732965
  733452
  734011
  738503
  739298
  739587
  740380
  740747
  742841
  745149
  745601
  746900
  749426
  750511
  750522
  750535
  752354
  754891
  758337
  758382
  760417
  761715
  762130
  762700
  763389
  763390
  763393
  763771
  764858
  765404
  766077
  766241
  769610
  769650
  769985
  771773
  772435
  772510
  773299
  773749
  775241
  776530
  776544
  776546
  777598
  778102
  778673
  778696
  780732
  782374
  782378
  782386
  783973
  784006
  784013
  784300
  787230
  790144
  790152
  791145
  791966
  792322
  794282
  797015
  797043
  798610
  798876
  799280
  799913
  799924
  804239
  804262
  805036
  805072
  805116
  806613
  807053
  807879
  807972
  808306
  811893
  812247
  812484
  812493
  812816
  814177
  819644
  824683
  824941
  825368
  826237
  826405
  826407
  826611
  826615
  827677
]
13.48 ms
(5.76%)
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
  825368
  782374
  782386
  797043
  792322
  797015
  799924
  805116
  758382
  763393
  790144
  798876
  805036
  732789
  762700
  769610
  733452
  772510
  750535
  758337
  766077
  715484
  776530
  777598
  778673
  780732
  790152
  804239
  807879
  807972
  812247
  812484
  684681
  776544
  542912
  575300
  798610
  738503
  775241
  710689
  717459
  791145
  804262
  732965
  769985
  545833
  585161
  814177
  819644
  826611
  824941
  826405
  826615
  824683
  826109
  826407
  827677
  655561
  718029
  651322
  718007
  715098
  720808
  778102
  784006
  782378
  812816
  729802
  739587
  740380
  742841
  745149
  746900
  760417
  783973
  784013
  784300
  799280
  805072
  806613
  811893
  732634
  732956
  739298
  750522
  762130
  764858
  773299
  724700
  745601
  750511
  752354
  765404
  772435
  730408
  754891
  763389
  763390
  766241
  769650
  771773
  740747
  749426
  761715
  763771
  773749
  718017
  723124
  723242
  776546
  778696
  787230
  794282
  799913
  807053
  826237
  734011
  791966
  808306
  812493
]
3.07 ms
(1.31%)
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
  542912
  545833
  575300
  585161
  651322
  655561
  684681
  710689
  715098
  715484
  717459
  718007
  718017
  718029
  720808
  723124
  723242
  724700
  729802
  730408
  732634
  732789
  732956
  732965
  733452
  734011
  738503
  739298
  739587
  740380
  740747
  742841
  745149
  745601
  746900
  749426
  750511
  750522
  750535
  752354
  754891
  758337
  758382
  760417
  761715
  762130
  762700
  763389
  763390
  763393
  763771
  764858
  765404
  766077
  766241
  769610
  769650
  769985
  771773
  772435
  772510
  773299
  773749
  775241
  776530
  776544
  776546
  777598
  778102
  778673
  778696
  780732
  782374
  782378
  782386
  783973
  784006
  784013
  784300
  787230
  790144
  790152
  791145
  791966
  792322
  794282
  797015
  797043
  798610
  798876
  799280
  799913
  799924
  804239
  804262
  805036
  805072
  805116
  806613
  807053
  807879
  807972
  808306
  811893
  812247
  812484
  812493
  812816
  814177
  819644
  824683
  824941
  825368
  826237
  826405
  826407
  826611
  826615
  827677
]
1.96 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тикток социальн сет сиськ"
]
1.84 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tik tok tits"
]
1.65 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 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.