Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.46 ms
(85.30%)
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
  305328
  386345
  389629
  393505
  404470
  413097
  435188
  438414
  443814
  443921
  445688
  453775
  454862
  456621
  459658
  466900
  467646
  473262
  476001
  479334
  482993
  485432
  487674
  489265
  504263
  509390
  510297
  513171
  514424
  516824
  517003
  519260
  524335
  526742
  528394
  534305
  543437
  549148
  550317
  550635
  552062
  555182
  557194
  557292
  558006
  563919
  564258
  572599
  579196
  579221
  579347
  581520
  581825
  582135
  585168
  586672
  587976
  593873
  596913
  608350
  610831
  611039
  614089
  615580
  620983
  627626
  631632
  631961
  635178
  636629
  637740
  652278
  667013
  673187
  674063
  679144
  695298
  697892
  701167
  705880
  712619
  726523
  726561
  726706
  726777
  726846
  728009
  734609
  734740
  736265
  737209
  742811
  743365
  744240
  748689
  755453
  758895
  765023
  765850
  770704
  771742
  775771
  778326
  778329
  784762
  787040
  787149
  792754
  798121
  800816
  802892
  805101
  805704
  806357
  810140
  811117
  811549
  812020
  813775
  825201
]
17.11 ms
(9.09%)
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
  564258
  579196
  579221
  636629
  443814
  489265
  517003
  393505
  443921
  813775
  453775
  456621
  516824
  524335
  519260
  534305
  454862
  305328
  825201
  459658
  482993
  509390
  563919
  652278
  673187
  705880
  674063
  679144
  701167
  585168
  615580
  596913
  614089
  810140
  811549
  737209
  765850
  770704
  792754
  805704
  806357
  743365
  734609
  748689
  800816
  404470
  510297
  413097
  466900
  526742
  552062
  557194
  558006
  581825
  695298
  697892
  667013
  550317
  581520
  635178
  620983
  631632
  587976
  726706
  726846
  728009
  726777
  608350
  631961
  528394
  758895
  438414
  487674
  555182
  514424
  386345
  549148
  557292
  550635
  712619
  637740
  611039
  775771
  805101
  778326
  778329
  798121
  811117
  744240
  784762
  787149
  802892
  734740
  771742
  787040
  389629
  572599
  435188
  445688
  485432
  513171
  543437
  582135
  579347
  627626
  586672
  593873
  726523
  736265
  755453
  765023
  726561
  742811
  610831
  812020
  479334
  467646
  473262
  476001
  504263
]
2.62 ms
(1.39%)
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
  305328
  386345
  389629
  393505
  404470
  413097
  435188
  438414
  443814
  443921
  445688
  453775
  454862
  456621
  459658
  466900
  467646
  473262
  476001
  479334
  482993
  485432
  487674
  489265
  504263
  509390
  510297
  513171
  514424
  516824
  517003
  519260
  524335
  526742
  528394
  534305
  543437
  549148
  550317
  550635
  552062
  555182
  557194
  557292
  558006
  563919
  564258
  572599
  579196
  579221
  579347
  581520
  581825
  582135
  585168
  586672
  587976
  593873
  596913
  608350
  610831
  611039
  614089
  615580
  620983
  627626
  631632
  631961
  635178
  636629
  637740
  652278
  667013
  673187
  674063
  679144
  695298
  697892
  701167
  705880
  712619
  726523
  726561
  726706
  726777
  726846
  728009
  734609
  734740
  736265
  737209
  742811
  743365
  744240
  748689
  755453
  758895
  765023
  765850
  770704
  771742
  775771
  778326
  778329
  784762
  787040
  787149
  792754
  798121
  800816
  802892
  805101
  805704
  806357
  810140
  811117
  811549
  812020
  813775
  825201
]
2.18 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спящ большие сиськ"
]
2.17 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "спящ большие сиськ"
]
1.91 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "спящие большая грудь"
]
1.68 ms
(0.89%)
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.