Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.70 ms
(85.62%)
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
  532577
  540764
  542001
  542039
  542138
  684806
  723541
  731598
  731602
  731650
  732945
  733667
  733682
  733702
  733709
  733721
  733722
  735253
  735264
  735309
  737020
  737039
  737045
  739231
  739255
  739276
  739313
  739333
  739379
  739384
  739447
  740049
  740656
  741366
  741373
  743452
  743535
  743572
  743609
  743620
  745776
  745801
  745846
  747035
  747787
  747914
  749806
  749826
  749828
  749843
  749898
  750338
  751820
  751918
  751957
  753997
  754006
  754024
  754028
  754059
  754068
  754088
  763633
  763752
  764461
  764760
  777333
  780142
  787859
  799926
  801919
  816151
  816174
  817277
  818052
  818105
  818312
  819755
  819875
  819885
  820132
  820381
  821790
  821805
  821824
  823158
  824117
  824576
  824739
  824756
  824907
  825031
  825244
  825330
  825372
  825374
  825408
  825473
  825520
  825632
  825654
  825930
  826076
  826088
  826256
  826403
  826451
  826658
  826699
  826717
  827199
  827267
  827351
  827503
  827600
]
13.96 ms
(8.26%)
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
  743609
  745776
  750338
  731650
  732945
  740049
  740656
  743620
  747035
  763633
  763752
  764461
  764760
  777333
  778520
  780142
  799926
  801919
  532577
  540764
  542039
  542001
  542138
  684806
  787859
  733667
  733702
  733722
  737020
  739255
  739379
  749843
  751957
  754068
  754088
  733721
  735253
  737045
  739313
  741373
  745801
  747787
  749826
  749828
  749898
  754028
  731598
  733682
  733709
  735264
  739231
  739384
  743452
  745846
  751918
  754006
  739276
  739333
  739447
  741366
  743572
  751820
  754024
  731602
  735309
  737039
  743535
  747914
  749806
  753997
  754059
  816151
  816174
  818105
  819755
  819875
  819885
  820132
  821805
  823717
  824117
  825031
  825930
  825983
  826403
  826658
  723541
  826451
  826699
  825520
  826717
  817277
  818312
  821790
  825178
  825408
  825654
  826076
  827199
  827267
  827351
  827600
  827503
  818052
  820381
  821824
  824576
  825244
  825372
  825374
  825632
  826088
  826256
  823158
  824739
  824756
  824907
  825330
  825336
  825473
]
3.04 ms
(1.80%)
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
  532577
  540764
  542001
  542039
  542138
  684806
  723541
  731598
  731602
  731650
  732945
  733667
  733682
  733702
  733709
  733721
  733722
  735253
  735264
  735309
  737020
  737039
  737045
  739231
  739255
  739276
  739313
  739333
  739379
  739384
  739447
  740049
  740656
  741366
  741373
  743452
  743535
  743572
  743609
  743620
  745776
  745801
  745846
  747035
  747787
  747914
  749806
  749826
  749828
  749843
  749898
  750338
  751820
  751918
  751957
  753997
  754006
  754024
  754028
  754059
  754068
  754088
  763633
  763752
  764461
  764760
  777333
  780142
  787859
  799926
  801919
  816151
  816174
  817277
  818052
  818105
  818312
  819755
  819875
  819885
  820132
  820381
  821790
  821805
  821824
  823158
  824117
  824576
  824739
  824756
  824907
  825031
  825244
  825330
  825372
  825374
  825408
  825473
  825520
  825632
  825654
  825930
  826076
  826088
  826256
  826403
  826451
  826658
  826699
  826717
  827199
  827267
  827351
  827503
  827600
]
2.09 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tik tok xxx"
]
1.83 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тикток социальн сет xxx"
]
1.77 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "тикток социальн сет xxx"
]

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.