Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.22 ms
(84.57%)
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
  199188
  397883
  397912
  397918
  397919
  407802
  421849
  422261
  422821
  426940
  428073
  432650
  437314
  438562
  439560
  439715
  442932
  443747
  444171
  448975
  449702
  450181
  450812
  452320
  455788
  456000
  458554
  459947
  460744
  460745
  460748
  463481
  463700
  465388
  468355
  471419
  476271
  477981
  478377
  479027
  479493
  486539
  488073
  492333
  498321
  502326
  504927
  506044
  507829
  510074
  512017
  514042
  518851
  520683
  521401
  521634
  523902
  531997
  532063
  532064
  532126
  549661
  551035
  553433
  559083
  567074
  567218
  571254
  577598
  582656
  587677
  609422
  661913
  661991
  677862
  694105
  696567
  714297
  716584
  723744
  726593
  726753
  730904
  736379
  739965
  742022
  743463
  746207
  746267
  746497
  755695
  757070
  757201
  757288
  758171
  758594
  764309
  769550
  773403
  775889
  777217
  777739
  779347
  779902
  789188
  789276
  792287
  792522
  794403
  796197
  796208
  796214
  800934
  802075
  803363
  809791
  811314
  827842
]
17.91 ms
(9.82%)
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
  532063
  694105
  661913
  609422
  757201
  521634
  521401
  397912
  397919
  458554
  796208
  792287
  796197
  802075
  757288
  803363
  811314
  746207
  764309
  726593
  779347
  794403
  809791
  199188
  407802
  437314
  421849
  439560
  465388
  506044
  518851
  438562
  531997
  559083
  587677
  452320
  439715
  488073
  520683
  567218
  486539
  730904
  769550
  460744
  502326
  696567
  697943
  397918
  428073
  422261
  432650
  450181
  450812
  459947
  449702
  471419
  571254
  726753
  397883
  443747
  456000
  422821
  426940
  448975
  460748
  463481
  478377
  468355
  512017
  498321
  523902
  507829
  479493
  532126
  582656
  716584
  775889
  789188
  777217
  792522
  773403
  796214
  723744
  746267
  758594
  736379
  739965
  742022
  757070
  758171
  777739
  779902
  800934
  455788
  460745
  442932
  476271
  479027
  477981
  567074
  510074
  444171
  514042
  492333
  504927
  549661
  755695
  789276
  743463
  736517
  746497
  827842
  463700
  532064
  551035
  577598
  553433
  677862
  714297
  661991
]
3.00 ms
(1.65%)
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
  199188
  397883
  397912
  397918
  397919
  407802
  421849
  422261
  422821
  426940
  428073
  432650
  437314
  438562
  439560
  439715
  442932
  443747
  444171
  448975
  449702
  450181
  450812
  452320
  455788
  456000
  458554
  459947
  460744
  460745
  460748
  463481
  463700
  465388
  468355
  471419
  476271
  477981
  478377
  479027
  479493
  486539
  488073
  492333
  498321
  502326
  504927
  506044
  507829
  510074
  512017
  514042
  518851
  520683
  521401
  521634
  523902
  531997
  532063
  532064
  532126
  549661
  551035
  553433
  559083
  567074
  567218
  571254
  577598
  582656
  587677
  609422
  661913
  661991
  677862
  694105
  696567
  714297
  716584
  723744
  726593
  726753
  730904
  736379
  739965
  742022
  743463
  746207
  746267
  746497
  755695
  757070
  757201
  757288
  758171
  758594
  764309
  769550
  773403
  775889
  777217
  777739
  779347
  779902
  789188
  789276
  792287
  792522
  794403
  796197
  796208
  796214
  800934
  802075
  803363
  809791
  811314
  827842
]
2.01 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade mom boy"
]
1.98 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск mom парен"
]
1.47 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск mom парен"
]

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.