Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.11 ms
(86.84%)
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
  382205
  382918
  383238
  384917
  386497
  401546
  401642
  415870
  418467
  438646
  438650
  443248
  445010
  447381
  449001
  450264
  454083
  461083
  468209
  470044
  471050
  476475
  476657
  479949
  492842
  494399
  500779
  502447
  508578
  513206
  514276
  521202
  546241
  568266
  580206
  589700
  589824
  590454
  591993
  596263
  596657
  598985
  603282
  605033
  606940
  607263
  610199
  615899
  618302
  620026
  621051
  621174
  623936
  627311
  629535
  631325
  637156
  640285
  672896
  687306
  690625
  709651
  713424
  736021
  736038
  738919
  739155
  740545
  740556
  742402
  745915
  748285
  749237
  750296
  750601
  750996
  751433
  752094
  752822
  754480
  755488
  757219
  765490
  765638
  769382
  770544
  772557
  777924
  780553
  782651
  783745
  784744
  784862
  787215
  790635
  791911
  794206
  794236
  797081
  797280
  798601
  798818
  801825
  804259
  806144
  806529
  806635
  806973
  807243
  807611
  808161
  808542
  808623
  809542
  810455
  810482
  810527
  812273
  812738
  813199
]
13.33 ms
(7.10%)
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
  672896
  687306
  690625
  713424
  546241
  568266
  580206
  596263
  603282
  589700
  598985
  629535
  590454
  596657
  606940
  607263
  610199
  618302
  620026
  623936
  640285
  589824
  591993
  621051
  621174
  777924
  790635
  798818
  806144
  808623
  809542
  780553
  787215
  791911
  797280
  801825
  804259
  806529
  806973
  810482
  810527
  812273
  736021
  736038
  740556
  765490
  772557
  784862
  797081
  798601
  807611
  808161
  808542
  813199
  738919
  740545
  748285
  757219
  750296
  752822
  739155
  742402
  745915
  749237
  750996
  751433
  752094
  755488
  765638
  770544
  750601
  754480
  769382
  605033
  615899
  627311
  631325
  637156
  709651
  782651
  783745
  784744
  794206
  794236
  806635
  807243
  810455
  812738
  382205
  401642
  438646
  449001
  476657
  443248
  471050
  386497
  401546
  415870
  445010
  476475
  479949
  418467
  438650
  454083
  470044
  447381
  450264
  461083
  468209
  513206
  500779
  502447
  508578
  521202
  492842
  494399
  514276
  384917
  382918
  383238
]
4.01 ms
(2.13%)
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
  382205
  382918
  383238
  384917
  386497
  401546
  401642
  415870
  418467
  438646
  438650
  443248
  445010
  447381
  449001
  450264
  454083
  461083
  468209
  470044
  471050
  476475
  476657
  479949
  492842
  494399
  500779
  502447
  508578
  513206
  514276
  521202
  546241
  568266
  580206
  589700
  589824
  590454
  591993
  596263
  596657
  598985
  603282
  605033
  606940
  607263
  610199
  615899
  618302
  620026
  621051
  621174
  623936
  627311
  629535
  631325
  637156
  640285
  672896
  687306
  690625
  709651
  713424
  736021
  736038
  738919
  739155
  740545
  740556
  742402
  745915
  748285
  749237
  750296
  750601
  750996
  751433
  752094
  752822
  754480
  755488
  757219
  765490
  765638
  769382
  770544
  772557
  777924
  780553
  782651
  783745
  784744
  784862
  787215
  790635
  791911
  794206
  794236
  797081
  797280
  798601
  798818
  801825
  804259
  806144
  806529
  806635
  806973
  807243
  807611
  808161
  808542
  808623
  809542
  810455
  810482
  810527
  812273
  812738
  813199
]
2.06 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot solo"
]
1.88 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot соло"
]
1.73 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot соло"
]
1.71 ms
(0.91%)
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.