Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.06 ms
(83.00%)
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
  437367
  456729
  466985
  532614
  542907
  567779
  604635
  715810
  717795
  723455
  725205
  725244
  730413
  730868
  730872
  732360
  732604
  735859
  738056
  741030
  747044
  747943
  749686
  749964
  750418
  750452
  751786
  751835
  751906
  752051
  753102
  753916
  753981
  754175
  754633
  757889
  757932
  759290
  760384
  761008
  763236
  763247
  765156
  765162
  765347
  765397
  765638
  765699
  765709
  765963
  766943
  768061
  768355
  769306
  772421
  775212
  776232
  778114
  778514
  780633
  780867
  782034
  785048
  785184
  785578
  786177
  787257
  788010
  788778
  789026
  789863
  789864
  789869
  790054
  790089
  791059
  791386
  791706
  791972
  792427
  794249
  795547
  796452
  797099
  798505
  799397
  799798
  804907
  804963
  805412
  806075
  806720
  806994
  807660
  811765
  812844
  812875
  812993
  821797
  824383
  824668
  824783
  825744
  825955
  826342
  826609
  828017
  828106
  828169
  828212
  828240
  828350
  828473
]
13.76 ms
(10.01%)
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
  825744
  725205
  826609
  791386
  788778
  753916
  749686
  749964
  757932
  768355
  751786
  790453
  763236
  765709
  757889
  753981
  824668
  780867
  791973
  804907
  754175
  717795
  828212
  828350
  456729
  428530
  778514
  799798
  789863
  791972
  794249
  805412
  806075
  751906
  772421
  811765
  725244
  765162
  769306
  750418
  765354
  776232
  791059
  796452
  788010
  780633
  466985
  754633
  723455
  799397
  750452
  806720
  812875
  807660
  761008
  766943
  765397
  768061
  759290
  825955
  828106
  765963
  732604
  763247
  567779
  785578
  804963
  752051
  765638
  765699
  826342
  828240
  828169
  797099
  760384
  782034
  787257
  790054
  437367
  532614
  821797
  824783
  778114
  775212
  812844
  785184
  792427
  732360
  751835
  747044
  765347
  738056
  753102
  604635
  786177
  806994
  812993
  542907
  824383
  826420
  825655
  791706
  715810
  789869
  789864
  741030
  789026
  795547
  765156
  747943
  730868
  730872
  735859
  798505
  823785
  828017
  828473
  730413
  785048
  790089
]
3.19 ms
(2.32%)
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
  437367
  456729
  466985
  532614
  542907
  567779
  604635
  715810
  717795
  723455
  725205
  725244
  730413
  730868
  730872
  732360
  732604
  735859
  738056
  741030
  747044
  747943
  749686
  749964
  750418
  750452
  751786
  751835
  751906
  752051
  753102
  753916
  753981
  754175
  754633
  757889
  757932
  759290
  760384
  761008
  763236
  763247
  765156
  765162
  765347
  765397
  765638
  765699
  765709
  765963
  766943
  768061
  768355
  769306
  772421
  775212
  776232
  778114
  778514
  780633
  780867
  782034
  785048
  785184
  785578
  786177
  787257
  788010
  788778
  789026
  789863
  789864
  789869
  790054
  790089
  791059
  791386
  791706
  791972
  792427
  794249
  795547
  796452
  797099
  798505
  799397
  799798
  804907
  804963
  805412
  806075
  806720
  806994
  807660
  811765
  812844
  812875
  812993
  821797
  824383
  824668
  824783
  825744
  825955
  826342
  826609
  828017
  828106
  828169
  828212
  828240
  828350
  828473
]
1.77 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tiktok sex"
]
1.76 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тикток социальн сет секс"
]
1.43 ms
(1.04%)
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.