Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.61 ms
(86.26%)
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
  428530
  456729
  487852
  544009
  567779
  567798
  587719
  604505
  611152
  713872
  716403
  718933
  722317
  723228
  724054
  724916
  725205
  725754
  729339
  732543
  734998
  736938
  737224
  738051
  743149
  744460
  745527
  748093
  749686
  749964
  751636
  751786
  752836
  753916
  753939
  757183
  757191
  757932
  762315
  765285
  765348
  767011
  767939
  768061
  768355
  774067
  775211
  776115
  778423
  778434
  778460
  778514
  778636
  780867
  783301
  783327
  784984
  786344
  787275
  788778
  789770
  789857
  789863
  790049
  791376
  791386
  791450
  791696
  791972
  793375
  794249
  795434
  796944
  797203
  799201
  799798
  802258
  803207
  803992
  804182
  805412
  806075
  806720
  806730
  812875
  813487
  816721
  816725
  817395
  818108
  824668
  825524
  825703
  825724
  825744
  825746
  825776
  826399
  826511
  826514
  826609
  826617
  826657
  826989
  828010
  828205
  828212
  828217
  828350
  828357
]
13.58 ms
(7.62%)
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
  825375
  826311
  828239
  487852
  544009
  604505
  825958
  825703
  825776
  825524
  825724
  826399
  826617
  828205
  828357
  725754
  826511
  826514
  826609
  816721
  825746
  817395
  713872
  716403
  722317
  587719
  776115
  778636
  791386
  791450
  796944
  799201
  802258
  804182
  778460
  788778
  789770
  793375
  803992
  813487
  753916
  753939
  757191
  762315
  774027
  783327
  784984
  787275
  789857
  790049
  797203
  744460
  749686
  749964
  757932
  767939
  724054
  765348
  767011
  768355
  737224
  751636
  751786
  752836
  724916
  732543
  734998
  736938
  757183
  765285
  774067
  718933
  775211
  778434
  791696
  806730
  456729
  818108
  824599
  826657
  825744
  824820
  828010
  828344
  828212
  828350
  803207
  748093
  725205
  567779
  567798
  428530
  745527
  768061
  816725
  826989
  828217
  824668
  723228
  611152
  778514
  790453
  791376
  795434
  799798
  806720
  812875
  778423
  780867
  783301
  786344
  789863
  791972
  791973
  794249
  805412
  806075
  729339
  738051
  743149
]
3.53 ms
(1.98%)
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
  428530
  456729
  487852
  544009
  567779
  567798
  587719
  604505
  611152
  713872
  716403
  718933
  722317
  723228
  724054
  724916
  725205
  725754
  729339
  732543
  734998
  736938
  737224
  738051
  743149
  744460
  745527
  748093
  749686
  749964
  751636
  751786
  752836
  753916
  753939
  757183
  757191
  757932
  762315
  765285
  765348
  767011
  767939
  768061
  768355
  774067
  775211
  776115
  778423
  778434
  778460
  778514
  778636
  780867
  783301
  783327
  784984
  786344
  787275
  788778
  789770
  789857
  789863
  790049
  791376
  791386
  791450
  791696
  791972
  793375
  794249
  795434
  796944
  797203
  799201
  799798
  802258
  803207
  803992
  804182
  805412
  806075
  806720
  806730
  812875
  813487
  816721
  816725
  817395
  818108
  824668
  825524
  825703
  825724
  825744
  825746
  825776
  826399
  826511
  826514
  826609
  826617
  826657
  826989
  828010
  828205
  828212
  828217
  828350
  828357
]
2.07 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tiktok порно"
]
1.89 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тикток социальн сет порн"
]
1.72 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.93%)
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.