Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.99 ms
(89.31%)
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
  16762
  21397
  61369
  96581
  151180
  161318
  172220
  190903
  307458
  336072
  336704
  360336
  382006
  382252
  383508
  385947
  386316
  391294
  394738
  396953
  397219
  397859
  398461
  398554
  398556
  399009
  400598
  400996
  401157
  401834
  407562
  407708
  409201
  412613
  423975
  437320
  443135
  454466
  456724
  461282
  469955
  491214
  494932
  503069
  523897
  529600
  545924
  546145
  547044
  550636
  560455
  617536
  630654
  634631
  649242
  654167
  660061
  660400
  663459
  664848
  665248
  665270
  665506
  665876
  669652
  669742
  670902
  671223
  681170
  693487
  695108
  710339
  718538
  724492
  724728
  728305
  729076
  729296
  730357
  733495
  733511
  734264
  734265
  736765
  742495
  745354
  745952
  747173
  748366
  748473
  754161
  759688
  781829
  781883
  781896
  787781
  792592
  795088
  796851
  797014
  800924
  801061
  801705
  801796
  801947
  801984
  802352
  802616
  804059
  804127
  814723
  823849
  824283
  824538
  826119
  826165
  826482
  826705
  827963
  827964
]
11.90 ms
(6.56%)
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
  781829
  398556
  681170
  665506
  792592
  802616
  748366
  665248
  665270
  654167
  781883
  796851
  382252
  503069
  494932
  398461
  469955
  161318
  360336
  407562
  397859
  401157
  801705
  742495
  401834
  827963
  787781
  397219
  386316
  523897
  399009
  827964
  529600
  547044
  671223
  729296
  754161
  804059
  724492
  733511
  748473
  710339
  824283
  550636
  545924
  802352
  801947
  728305
  733495
  734264
  734265
  729076
  801796
  804127
  96581
  307458
  61369
  665876
  398554
  826482
  826119
  824538
  823849
  826165
  560455
  546145
  649242
  695108
  801061
  801984
  800924
  747173
  736765
  759688
  724728
  718538
  781896
  797014
  190903
  491214
  664848
  617536
  745952
  336704
  400996
  814723
  669652
  21397
  336072
  383508
  172220
  400598
  663459
  669742
  745354
  391294
  423975
  826705
  660061
  670902
  730357
  456724
  394738
  382006
  16762
  443135
  407708
  409201
  385947
  151180
  412613
  396953
  660400
  461282
  437320
  454466
  693487
  634631
  795088
  630654
]
1.99 ms
(1.10%)
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
  16762
  21397
  61369
  96581
  151180
  161318
  172220
  190903
  307458
  336072
  336704
  360336
  382006
  382252
  383508
  385947
  386316
  391294
  394738
  396953
  397219
  397859
  398461
  398554
  398556
  399009
  400598
  400996
  401157
  401834
  407562
  407708
  409201
  412613
  423975
  437320
  443135
  454466
  456724
  461282
  469955
  491214
  494932
  503069
  523897
  529600
  545924
  546145
  547044
  550636
  560455
  617536
  630654
  634631
  649242
  654167
  660061
  660400
  663459
  664848
  665248
  665270
  665506
  665876
  669652
  669742
  670902
  671223
  681170
  693487
  695108
  710339
  718538
  724492
  724728
  728305
  729076
  729296
  730357
  733495
  733511
  734264
  734265
  736765
  742495
  745354
  745952
  747173
  748366
  748473
  754161
  759688
  781829
  781883
  781896
  787781
  792592
  795088
  796851
  797014
  800924
  801061
  801705
  801796
  801947
  801984
  802352
  802616
  804059
  804127
  814723
  823849
  824283
  824538
  826119
  826165
  826482
  826705
  827963
  827964
]
1.51 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс полная"
]
1.36 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс пышками"
]
1.32 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс полная"
]
1.32 ms
(0.73%)
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.