Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.64 ms
(82.51%)
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
  391009
  396378
  400265
  412220
  412265
  415806
  418135
  418817
  425244
  426298
  435579
  438452
  442236
  444299
  445138
  459574
  459602
  460166
  461400
  462056
  463435
  466470
  466503
  469502
  473786
  474891
  476666
  479328
  480232
  481997
  491505
  492407
  492465
  494665
  497399
  497777
  502994
  504428
  507010
  508845
  509188
  509258
  515550
  519678
  521171
  527448
  530649
  532111
  532225
  532587
  533211
  537165
  537322
  537324
  537354
  539323
  539634
  539644
  540660
  542330
  542433
  544342
  547570
  548489
  549448
  550163
  552731
  553964
  555971
  556325
  559994
  564170
  568233
  568310
  568807
  574358
  575972
  579271
  582153
  583374
  584312
  590456
  590713
  592852
  595981
  598335
  602298
  602332
  603980
  606095
  613224
  630270
  636566
  644436
  672701
  692979
  701221
  715402
  721112
  739820
  745301
  755490
  760681
  760687
  763740
  765818
  765836
  773724
  774994
  783321
  783343
  785899
  790664
  791033
  791059
  798411
  801786
  803635
  808542
  812869
]
16.58 ms
(10.63%)
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
  466503
  509188
  552731
  548489
  564170
  636566
  463435
  476666
  497399
  497777
  559994
  462056
  461400
  426298
  473786
  469502
  537324
  530649
  532111
  533211
  539323
  532587
  550163
  582153
  544342
  574358
  584312
  672701
  701221
  549448
  644436
  812869
  755490
  785899
  790664
  765818
  763740
  745301
  739820
  773724
  602298
  791059
  801786
  481997
  435579
  415806
  507010
  519678
  479328
  539634
  715402
  556325
  492465
  466470
  508845
  540660
  542330
  692979
  613224
  630270
  595981
  783321
  783343
  803635
  808542
  765836
  791033
  412220
  494665
  491505
  568807
  391009
  444299
  575972
  579271
  583374
  553964
  603980
  418817
  492407
  555971
  396378
  438452
  418135
  425244
  442236
  480232
  537322
  539644
  509258
  532225
  537165
  515550
  527448
  537354
  502994
  542433
  568233
  568310
  547570
  592852
  598335
  602332
  606095
  590713
  590456
  774994
  798411
  760687
  760681
  721112
  474891
  459602
  400265
  459574
  412265
  445138
  460166
  504428
  521171
]
3.06 ms
(1.96%)
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
  391009
  396378
  400265
  412220
  412265
  415806
  418135
  418817
  425244
  426298
  435579
  438452
  442236
  444299
  445138
  459574
  459602
  460166
  461400
  462056
  463435
  466470
  466503
  469502
  473786
  474891
  476666
  479328
  480232
  481997
  491505
  492407
  492465
  494665
  497399
  497777
  502994
  504428
  507010
  508845
  509188
  509258
  515550
  519678
  521171
  527448
  530649
  532111
  532225
  532587
  533211
  537165
  537322
  537324
  537354
  539323
  539634
  539644
  540660
  542330
  542433
  544342
  547570
  548489
  549448
  550163
  552731
  553964
  555971
  556325
  559994
  564170
  568233
  568310
  568807
  574358
  575972
  579271
  582153
  583374
  584312
  590456
  590713
  592852
  595981
  598335
  602298
  602332
  603980
  606095
  613224
  630270
  636566
  644436
  672701
  692979
  701221
  715402
  721112
  739820
  745301
  755490
  760681
  760687
  763740
  765818
  765836
  773724
  774994
  783321
  783343
  785899
  790664
  791033
  791059
  798411
  801786
  803635
  808542
  812869
]
2.22 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful wife"
]
1.83 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая жен"
]
1.79 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.14%)
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.