Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.91 ms
(85.12%)
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
  42536
  154187
  387996
  424294
  441120
  441849
  442511
  443198
  445397
  445745
  446533
  448795
  450572
  450697
  451022
  457483
  459203
  460533
  461704
  466475
  467715
  468823
  468946
  469220
  477149
  481904
  482190
  483738
  488713
  488820
  493730
  495737
  505387
  510532
  510812
  517272
  517928
  525603
  526179
  526504
  527926
  534567
  534586
  536091
  540680
  540924
  543941
  546171
  547467
  548157
  548445
  550550
  550659
  550807
  550890
  552819
  553789
  554997
  555026
  556339
  556888
  556902
  556909
  558158
  560570
  562575
  568252
  568254
  576444
  576552
  576848
  578003
  578308
  584362
  585251
  590255
  592362
  593230
  597160
  609071
  610280
  618297
  619322
  626044
  628604
  630382
  634317
  634734
  634735
  653602
  665796
  666053
  679173
  704167
  704641
  705005
  710545
  713505
  722385
  725755
  733734
  734276
  735136
  745681
  752541
  758164
  780650
  792272
  792734
  794305
  794323
  796833
  796843
  796849
  797284
  800279
  800289
  802347
  803542
  803576
]
17.29 ms
(9.21%)
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
  536091
  543941
  560570
  568252
  550659
  553789
  568254
  556902
  710545
  722385
  546171
  630382
  794323
  733734
  734276
  796849
  725755
  735136
  794305
  556909
  460533
  578308
  441120
  610280
  448795
  488713
  534567
  547467
  445745
  510532
  467715
  459203
  42536
  540924
  550807
  550890
  576552
  618297
  634734
  797284
  800289
  800279
  802347
  803576
  745681
  752541
  792272
  792734
  803542
  653602
  666053
  679173
  634317
  634735
  704167
  443198
  424294
  442511
  451022
  446533
  457483
  468823
  468946
  483738
  540680
  526504
  534586
  505387
  525603
  526179
  495737
  527926
  548445
  552819
  555026
  556339
  556888
  548157
  550550
  558158
  578003
  576444
  584362
  705005
  665796
  713505
  554997
  576848
  597160
  593230
  609071
  619322
  592362
  626044
  780650
  796843
  796833
  758164
  628604
  445397
  469220
  466475
  477149
  441849
  450572
  450697
  493730
  517272
  488820
  387996
  562575
  482190
  510812
  585251
  461704
  154187
  704641
  481904
  517928
  590255
]
3.35 ms
(1.79%)
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
  42536
  154187
  387996
  424294
  441120
  441849
  442511
  443198
  445397
  445745
  446533
  448795
  450572
  450697
  451022
  457483
  459203
  460533
  461704
  466475
  467715
  468823
  468946
  469220
  477149
  481904
  482190
  483738
  488713
  488820
  493730
  495737
  505387
  510532
  510812
  517272
  517928
  525603
  526179
  526504
  527926
  534567
  534586
  536091
  540680
  540924
  543941
  546171
  547467
  548157
  548445
  550550
  550659
  550807
  550890
  552819
  553789
  554997
  555026
  556339
  556888
  556902
  556909
  558158
  560570
  562575
  568252
  568254
  576444
  576552
  576848
  578003
  578308
  584362
  585251
  590255
  592362
  593230
  597160
  609071
  610280
  618297
  619322
  626044
  628604
  630382
  634317
  634734
  634735
  653602
  665796
  666053
  679173
  704167
  704641
  705005
  710545
  713505
  722385
  725755
  733734
  734276
  735136
  745681
  752541
  758164
  780650
  792272
  792734
  794305
  794323
  796833
  796843
  796849
  797284
  800279
  800289
  802347
  803542
  803576
]
1.92 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг жен любительск"
]
1.91 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting wife amateur"
]
1.79 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.89%)
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.