Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.99 ms
(84.02%)
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
  130089
  321285
  391989
  392704
  392952
  400728
  407313
  408764
  414277
  418521
  419949
  423426
  424283
  432516
  435830
  436942
  444280
  447094
  456645
  457898
  460168
  469227
  473420
  473523
  474281
  478406
  479582
  493591
  498582
  499806
  499964
  499995
  502378
  505732
  508654
  511693
  516146
  516493
  516501
  520953
  522047
  524255
  528657
  533634
  539599
  548859
  555074
  556704
  562423
  563110
  565011
  575659
  575947
  576090
  576180
  577341
  579178
  582812
  584921
  590123
  592372
  594053
  594246
  596766
  608605
  614942
  615014
  620904
  621457
  624938
  629580
  638191
  645235
  645998
  657177
  660807
  662065
  662222
  670965
  677363
  693635
  698293
  699631
  702038
  703586
  705310
  705825
  706004
  713386
  714927
  722420
  732304
  736289
  736784
  737786
  740732
  742722
  745938
  753150
  755845
  757367
  765863
  777017
  778670
  785698
  789529
  791270
  792638
  794556
  795316
  796465
  805259
  807902
  809078
  810790
  811630
  814242
  815865
  819138
  827054
]
19.04 ms
(10.32%)
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
  755845
  795316
  796465
  432516
  805259
  435830
  677363
  662065
  706004
  713386
  615014
  742722
  577341
  444280
  575659
  736289
  827054
  473523
  703586
  620904
  765863
  714927
  582812
  596766
  516146
  575947
  516501
  392952
  321285
  423426
  460168
  522047
  563110
  576180
  645998
  693635
  722420
  645235
  702038
  608605
  791270
  794556
  753150
  757367
  785698
  789529
  807902
  705825
  792638
  414277
  478406
  511693
  520953
  508654
  408764
  584921
  662222
  594053
  624938
  737786
  732304
  777017
  778670
  811630
  456645
  392704
  457898
  436942
  505732
  391989
  819138
  592372
  576090
  657177
  705310
  638191
  474281
  555074
  447094
  556704
  614942
  528657
  621457
  502378
  670965
  533634
  539599
  579178
  629580
  499964
  562423
  516493
  548859
  745938
  418521
  400728
  419949
  493591
  594246
  736784
  740732
  698293
  407313
  479582
  130089
  524255
  660807
  699631
  565011
  590123
  809078
  810790
  424283
  473420
  499995
  498582
  814242
  499806
  815865
  469227
]
2.72 ms
(1.48%)
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
  130089
  321285
  391989
  392704
  392952
  400728
  407313
  408764
  414277
  418521
  419949
  423426
  424283
  432516
  435830
  436942
  444280
  447094
  456645
  457898
  460168
  469227
  473420
  473523
  474281
  478406
  479582
  493591
  498582
  499806
  499964
  499995
  502378
  505732
  508654
  511693
  516146
  516493
  516501
  520953
  522047
  524255
  528657
  533634
  539599
  548859
  555074
  556704
  562423
  563110
  565011
  575659
  575947
  576090
  576180
  577341
  579178
  582812
  584921
  590123
  592372
  594053
  594246
  596766
  608605
  614942
  615014
  620904
  621457
  624938
  629580
  638191
  645235
  645998
  657177
  660807
  662065
  662222
  670965
  677363
  693635
  698293
  699631
  702038
  703586
  705310
  705825
  706004
  713386
  714927
  722420
  732304
  736289
  736784
  737786
  740732
  742722
  745938
  753150
  755845
  757367
  765863
  777017
  778670
  785698
  789529
  791270
  792638
  794556
  795316
  796465
  805259
  807902
  809078
  810790
  811630
  814242
  815865
  819138
  827054
]
2.14 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.03 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass to pussy"
]
1.81 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп pussy"
]
1.74 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп pussy"
]

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.