Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.91 ms
(86.44%)
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
  469285
  529981
  531013
  541994
  544106
  615906
  678672
  717249
  718086
  718603
  718897
  721899
  721902
  723645
  725078
  727071
  728375
  729367
  729848
  730021
  731497
  731608
  733636
  733676
  737012
  738050
  739093
  739374
  739381
  739730
  741138
  741377
  744949
  746728
  746864
  747267
  748094
  749045
  750574
  750957
  751052
  752074
  752747
  754729
  754981
  755175
  757186
  757193
  757197
  760340
  760388
  762040
  762048
  762161
  762385
  763020
  763824
  764803
  764835
  764911
  765505
  765608
  766125
  766243
  768975
  769622
  769628
  769691
  770529
  773144
  777257
  777771
  778236
  778253
  778389
  778400
  778432
  778439
  778596
  778764
  780693
  782035
  782858
  782886
  783289
  784321
  785045
  785518
  786804
  787644
  788417
  788615
  789568
  789576
  790166
  790273
  791225
  802920
  804148
  805060
  805065
  806605
  807024
  807026
  814187
  814434
  816145
  818570
  821781
  821785
  823902
  824119
  824871
  825335
  825855
  826497
  826510
  827440
  827501
  828587
]
11.07 ms
(7.04%)
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
  748094
  754729
  763824
  764911
  766125
  766243
  768975
  769622
  769691
  717249
  718086
  718603
  721899
  721902
  778236
  778432
  778596
  782035
  789568
  790273
  541994
  824871
  828587
  531013
  544106
  782886
  784321
  807024
  782858
  788417
  749045
  757186
  760340
  791225
  731608
  754981
  762385
  770529
  733636
  739381
  747267
  762161
  764803
  733676
  783289
  807026
  824119
  826510
  821781
  827440
  821785
  529981
  718897
  678672
  615906
  777771
  778764
  780693
  787644
  790166
  778389
  778439
  786804
  805060
  725078
  729367
  729848
  741377
  746864
  750574
  750957
  752074
  760388
  789576
  802920
  804148
  806605
  739730
  755175
  764835
  752747
  762040
  762048
  773144
  730021
  737012
  739093
  739374
  746728
  763020
  765505
  769628
  741138
  744949
  751052
  757193
  757197
  778253
  785045
  788615
  805065
  778400
  785518
  777257
  765608
  727071
  738050
  728375
  731497
  469285
  814434
  723645
  826497
  825855
  825335
  818570
  823902
  827501
  814187
  816145
]
3.64 ms
(2.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
  469285
  529981
  531013
  541994
  544106
  615906
  678672
  717249
  718086
  718603
  718897
  721899
  721902
  723645
  725078
  727071
  728375
  729367
  729848
  730021
  731497
  731608
  733636
  733676
  737012
  738050
  739093
  739374
  739381
  739730
  741138
  741377
  744949
  746728
  746864
  747267
  748094
  749045
  750574
  750957
  751052
  752074
  752747
  754729
  754981
  755175
  757186
  757193
  757197
  760340
  760388
  762040
  762048
  762161
  762385
  763020
  763824
  764803
  764835
  764911
  765505
  765608
  766125
  766243
  768975
  769622
  769628
  769691
  770529
  773144
  777257
  777771
  778236
  778253
  778389
  778400
  778432
  778439
  778596
  778764
  780693
  782035
  782858
  782886
  783289
  784321
  785045
  785518
  786804
  787644
  788417
  788615
  789568
  789576
  790166
  790273
  791225
  802920
  804148
  805060
  805065
  806605
  807024
  807026
  814187
  814434
  816145
  818570
  821781
  821785
  823902
  824119
  824871
  825335
  825855
  826497
  826510
  827440
  827501
  828587
]
1.85 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тикток девушки"
]
1.65 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тикток социальн сет девушк"
]
1.61 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "тикток социальн сет девушк"
]
1.49 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.