Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.89 ms
(82.92%)
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
  188254
  388519
  389571
  393508
  397992
  398353
  422347
  442695
  443518
  450146
  454293
  459896
  460243
  464460
  464561
  465214
  466277
  466801
  467691
  468374
  468798
  468886
  470298
  470639
  470925
  471449
  472867
  473775
  478002
  479024
  479078
  482325
  482391
  482511
  484335
  490917
  490921
  491120
  492458
  493224
  493401
  493478
  494195
  495852
  496186
  498481
  498730
  500230
  500394
  502712
  505251
  509060
  509317
  511535
  511594
  517863
  519339
  526703
  526827
  527158
  534676
  534697
  540119
  541107
  541369
  544489
  545694
  549846
  551756
  555126
  557145
  557732
  558020
  581183
  620220
  626378
  645048
  663505
  664825
  665215
  665240
  665306
  665487
  665850
  669783
  677971
  678777
  681216
  713384
  715116
  718570
  720533
  725345
  725504
  726396
  726419
  726646
  730076
  731090
  736422
  740158
  742235
  746632
  748467
  758414
  759108
  764279
  765640
  777417
  777654
  790976
  796123
  801055
  801319
  802899
  808210
  811494
  816507
  819044
  824062
]
15.27 ms
(9.75%)
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
  665306
  746632
  824062
  677971
  801055
  725345
  726646
  819044
  557145
  811494
  720533
  551756
  534697
  777654
  718570
  764279
  188254
  758414
  726396
  736422
  494195
  541369
  759108
  540119
  388519
  713384
  731090
  478002
  398353
  493478
  541107
  397992
  460243
  730076
  790976
  665240
  777417
  468798
  669783
  495852
  748467
  493401
  664825
  665215
  470639
  681216
  527158
  393508
  389571
  725504
  663505
  450146
  581183
  665487
  470925
  511535
  645048
  473775
  801319
  511594
  500230
  558020
  465214
  468374
  765640
  500394
  665850
  442695
  678777
  545694
  526703
  620220
  464460
  742235
  726419
  808210
  549846
  557732
  626378
  443518
  466801
  468886
  490917
  498481
  509060
  472867
  479024
  471449
  509317
  479078
  496186
  482511
  467691
  796123
  505251
  491120
  519339
  802899
  816507
  459896
  493224
  490921
  482391
  482325
  517863
  422347
  484335
  715116
  534676
  544489
  454293
  502712
  464561
  470298
  526827
  492458
  555126
  498730
  466277
  740158
]
4.05 ms
(2.58%)
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
  188254
  388519
  389571
  393508
  397992
  398353
  422347
  442695
  443518
  450146
  454293
  459896
  460243
  464460
  464561
  465214
  466277
  466801
  467691
  468374
  468798
  468886
  470298
  470639
  470925
  471449
  472867
  473775
  478002
  479024
  479078
  482325
  482391
  482511
  484335
  490917
  490921
  491120
  492458
  493224
  493401
  493478
  494195
  495852
  496186
  498481
  498730
  500230
  500394
  502712
  505251
  509060
  509317
  511535
  511594
  517863
  519339
  526703
  526827
  527158
  534676
  534697
  540119
  541107
  541369
  544489
  545694
  549846
  551756
  555126
  557145
  557732
  558020
  581183
  620220
  626378
  645048
  663505
  664825
  665215
  665240
  665306
  665487
  665850
  669783
  677971
  678777
  681216
  713384
  715116
  718570
  720533
  725345
  725504
  726396
  726419
  726646
  730076
  731090
  736422
  740158
  742235
  746632
  748467
  758414
  759108
  764279
  765640
  777417
  777654
  790976
  796123
  801055
  801319
  802899
  808210
  811494
  816507
  819044
  824062
]
2.05 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большой член и зрелая%…"
]
2.00 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член зрелая женщин"
]
1.71 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие член зрелая женщин"
]
1.66 ms
(1.06%)
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.