Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.09 ms
(51.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пошл домашн любительск молодые"
]
165.09 ms
(39.35%)
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
  428679
  450815
  451175
  460027
  468636
  469601
  469649
  481580
  484958
  485002
  485630
  486229
  488084
  490210
  494072
  500904
  503984
  505015
  506816
  508567
  509135
  512741
  513664
  514125
  515812
  515947
  516119
  518268
  520496
  521074
  521307
  521604
  521624
  521909
  522297
  524512
  525019
  530064
  530948
  543479
  547742
  548012
  553129
  553329
  560006
  561178
  562325
  562740
  564009
  564042
  568720
  568792
  569065
  569159
  570601
  572385
  572774
  572885
  575287
  575979
  582838
  584461
  586431
  589509
  590651
  591141
  593989
  594073
  595243
  597642
  598756
  599030
  599103
  601314
  601947
  602761
  603033
  603850
  603923
  603933
  605586
  605774
  605840
  606016
  606136
  608206
  608820
  609292
  609649
  610628
  613867
  615429
  615623
  616686
  617342
  618177
  618987
  619003
  619565
  619999
  620050
  620686
  620995
  621272
  621327
  621705
  622351
  623108
  624473
  625212
  627632
  636181
  639922
  644023
  653405
  658952
  662378
  663259
  675321
  684440
]
28.18 ms
(6.72%)
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
  485002
  508567
  514125
  506816
  663259
  575979
  605774
  619565
  518268
  525019
  553129
  521074
  481580
  547742
  451175
  623108
  460027
  616686
  590651
  582838
  684440
  591141
  603850
  608820
  627632
  618987
  609292
  620050
  644023
  561178
  619999
  548012
  575287
  639922
  428679
  494072
  513664
  598756
  500904
  569159
  597642
  624473
  610628
  599030
  606136
  521909
  572774
  553329
  568792
  589509
  516119
  503984
  524512
  484958
  515947
  572385
  562325
  515812
  490210
  468636
  509135
  486229
  568720
  636181
  615623
  608206
  613867
  602761
  620995
  485630
  450815
  653405
  593989
  595243
  562740
  572885
  658952
  675321
  586431
  625212
  469601
  469649
  488084
  521307
  522297
  530064
  530948
  521624
  621705
  569065
  621327
  594073
  609649
  505015
  512741
  521604
  543479
  617342
  601314
  570601
  584461
  622351
  599103
  605586
  560006
  564009
  662378
  564042
  603923
  605840
  615429
  619003
  601947
  603033
  606016
  620686
  520496
  603933
  618177
  621272
]
4.35 ms
(1.04%)
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
  428679
  450815
  451175
  460027
  468636
  469601
  469649
  481580
  484958
  485002
  485630
  486229
  488084
  490210
  494072
  500904
  503984
  505015
  506816
  508567
  509135
  512741
  513664
  514125
  515812
  515947
  516119
  518268
  520496
  521074
  521307
  521604
  521624
  521909
  522297
  524512
  525019
  530064
  530948
  543479
  547742
  548012
  553129
  553329
  560006
  561178
  562325
  562740
  564009
  564042
  568720
  568792
  569065
  569159
  570601
  572385
  572774
  572885
  575287
  575979
  582838
  584461
  586431
  589509
  590651
  591141
  593989
  594073
  595243
  597642
  598756
  599030
  599103
  601314
  601947
  602761
  603033
  603850
  603923
  603933
  605586
  605774
  605840
  606016
  606136
  608206
  608820
  609292
  609649
  610628
  613867
  615429
  615623
  616686
  617342
  618177
  618987
  619003
  619565
  619999
  620050
  620686
  620995
  621272
  621327
  621705
  622351
  623108
  624473
  625212
  627632
  636181
  639922
  644023
  653405
  658952
  662378
  663259
  675321
  684440
]
2.47 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пошлая домашка молодых"
]
1.74 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.39%)
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.