Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
418.72 ms
(65.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск вперв"
]
179.59 ms
(28.24%)
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
  427044
  427166
  430374
  439927
  441168
  446543
  447412
  447523
  447615
  451497
  454238
  455096
  455912
  456179
  456362
  456452
  461454
  461456
  463305
  463927
  467508
  468910
  471402
  473781
  475388
  479190
  484372
  484581
  485246
  487325
  489097
  490657
  495259
  495937
  497240
  498192
  498656
  500870
  500978
  503385
  505614
  508870
  510392
  512583
  513061
  517945
  518133
  518521
  522221
  523322
  523333
  523871
  524712
  526524
  528262
  530249
  533760
  542218
  542765
  545730
  545755
  546465
  547620
  552978
  553631
  554577
  558566
  560396
  560845
  560858
  561821
  563446
  576096
  577966
  588801
  591216
  593372
  595498
  595891
  596645
  597013
  598067
  598464
  598494
  598510
  598524
  599404
  599512
  601314
  601906
  601917
  601924
  601959
  601976
  602017
  604289
  605416
  606011
  606014
  607363
  608200
  610695
  617006
  617039
  619965
  622423
  622778
  626617
  634230
  637002
  637243
  651938
  652907
  653238
  653267
  654552
  655087
  655615
  657438
  676989
]
29.82 ms
(4.69%)
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
  560396
  560858
  479190
  447412
  498192
  487325
  576096
  490657
  495937
  552978
  558566
  561821
  542765
  560845
  554577
  546465
  553631
  427044
  471402
  456179
  463927
  468910
  430374
  455096
  463305
  441168
  447523
  461454
  475388
  523333
  517945
  497240
  498656
  500978
  510392
  518133
  523322
  495259
  524712
  528262
  530249
  588801
  637243
  595498
  595891
  598494
  655087
  653267
  598464
  598510
  622423
  451497
  593372
  533760
  503385
  545730
  598067
  456452
  454238
  447615
  473781
  427166
  508870
  513061
  526524
  489097
  505614
  484581
  652907
  446543
  500870
  523871
  439927
  542218
  676989
  601959
  461456
  512583
  485246
  655615
  604289
  597013
  455912
  651938
  608200
  591216
  637002
  598524
  599404
  619965
  617039
  601976
  518521
  484372
  547620
  577966
  626617
  467508
  522221
  456362
  634230
  545755
  654552
  602017
  617006
  601906
  653238
  606014
  599512
  622778
  563446
  605416
  601917
  606011
  601924
  596645
  610695
  657438
  601314
  607363
]
2.95 ms
(0.46%)
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
  427044
  427166
  430374
  439927
  441168
  446543
  447412
  447523
  447615
  451497
  454238
  455096
  455912
  456179
  456362
  456452
  461454
  461456
  463305
  463927
  467508
  468910
  471402
  473781
  475388
  479190
  484372
  484581
  485246
  487325
  489097
  490657
  495259
  495937
  497240
  498192
  498656
  500870
  500978
  503385
  505614
  508870
  510392
  512583
  513061
  517945
  518133
  518521
  522221
  523322
  523333
  523871
  524712
  526524
  528262
  530249
  533760
  542218
  542765
  545730
  545755
  546465
  547620
  552978
  553631
  554577
  558566
  560396
  560845
  560858
  561821
  563446
  576096
  577966
  588801
  591216
  593372
  595498
  595891
  596645
  597013
  598067
  598464
  598494
  598510
  598524
  599404
  599512
  601314
  601906
  601917
  601924
  601959
  601976
  602017
  604289
  605416
  606011
  606014
  607363
  608200
  610695
  617006
  617039
  619965
  622423
  622778
  626617
  634230
  637002
  637243
  651938
  652907
  653238
  653267
  654552
  655087
  655615
  657438
  676989
]
1.74 ms
(0.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское первый раз"
]
1.60 ms
(0.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.