Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.61 ms
(88.90%)
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
  39059
  47583
  79479
  147400
  180923
  198127
  214109
  233298
  308583
  350700
  382510
  382647
  382677
  384549
  385496
  387197
  391175
  391760
  394190
  395659
  396512
  397166
  397464
  398502
  398564
  398790
  398830
  398947
  400677
  401925
  402971
  403268
  405479
  409077
  409804
  418693
  421802
  422397
  422487
  424296
  425751
  427195
  436845
  443864
  444349
  447111
  447816
  455647
  459354
  461328
  462538
  462738
  467781
  470382
  470816
  473991
  474220
  476532
  481158
  548691
  561536
  589522
  589648
  593714
  600954
  601306
  603712
  604825
  605082
  606252
  606684
  606839
  608683
  612932
  618260
  620994
  632542
  637515
  643190
  644153
  684998
  696688
  698165
  716754
  717115
  726499
  728811
  730769
  733179
  736053
  738955
  741808
  742678
  752213
  752368
  755989
  758414
  763510
  763520
  763529
  763678
  766679
  767330
  767403
  767506
  778411
  778829
  779538
  781045
  790171
  790626
  790729
  790954
  793342
  799246
  806840
  810867
  811653
  811741
  813340
]
10.95 ms
(5.74%)
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
  684998
  696688
  698165
  548691
  561536
  589648
  600954
  606684
  608683
  632542
  637515
  643190
  644153
  589522
  601306
  604825
  593714
  606252
  612932
  620994
  778411
  778829
  793342
  781045
  790729
  790954
  806840
  726499
  730769
  758414
  790171
  790626
  799246
  810867
  811653
  755989
  763510
  736053
  738955
  741808
  742678
  728811
  733179
  752213
  752368
  763520
  763529
  767506
  763678
  766679
  767330
  767403
  603712
  605082
  606839
  618260
  716754
  717115
  779538
  811741
  813340
  47583
  180923
  198127
  308583
  350700
  382510
  382647
  382677
  391760
  396512
  398564
  400677
  402971
  409804
  424296
  444349
  447111
  447816
  470382
  476532
  79479
  395659
  398830
  398947
  421802
  422397
  425751
  436845
  455647
  461328
  467781
  470816
  384549
  385496
  391175
  394190
  398502
  398790
  401925
  403268
  405479
  409077
  418693
  422487
  427195
  443864
  459354
  462538
  462738
  473991
  474220
  481158
  39059
  147400
  214109
  233298
  387197
  397166
  397464
]
2.86 ms
(1.50%)
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
  39059
  47583
  79479
  147400
  180923
  198127
  214109
  233298
  308583
  350700
  382510
  382647
  382677
  384549
  385496
  387197
  391175
  391760
  394190
  395659
  396512
  397166
  397464
  398502
  398564
  398790
  398830
  398947
  400677
  401925
  402971
  403268
  405479
  409077
  409804
  418693
  421802
  422397
  422487
  424296
  425751
  427195
  436845
  443864
  444349
  447111
  447816
  455647
  459354
  461328
  462538
  462738
  467781
  470382
  470816
  473991
  474220
  476532
  481158
  548691
  561536
  589522
  589648
  593714
  600954
  601306
  603712
  604825
  605082
  606252
  606684
  606839
  608683
  612932
  618260
  620994
  632542
  637515
  643190
  644153
  684998
  696688
  698165
  716754
  717115
  726499
  728811
  730769
  733179
  736053
  738955
  741808
  742678
  752213
  752368
  755989
  758414
  763510
  763520
  763529
  763678
  766679
  767330
  767403
  767506
  778411
  778829
  779538
  781045
  790171
  790626
  790729
  790954
  793342
  799246
  806840
  810867
  811653
  811741
  813340
]
2.15 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "отсасыва"
]
2.07 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "отсасывает"
]
1.60 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.81%)
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.