Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.40 ms
(82.47%)
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
  382681
  389756
  399694
  409163
  410732
  411729
  415525
  419245
  421543
  428335
  431597
  434877
  435411
  437560
  438631
  441160
  443197
  444481
  445315
  448304
  448547
  457765
  458229
  459258
  463132
  466859
  476745
  478809
  487012
  489756
  490468
  490638
  492308
  494572
  494789
  501567
  503749
  504950
  509933
  512960
  513223
  523866
  525165
  526902
  527882
  530728
  531216
  532991
  538260
  544466
  547674
  554243
  555159
  556760
  557097
  560179
  564569
  571586
  574068
  577664
  582316
  583176
  584441
  604641
  606604
  610097
  615147
  615347
  617616
  626545
  626547
  627747
  631173
  638555
  641985
  649559
  660150
  662375
  665940
  668937
  670913
  675183
  696985
  707510
  707546
  711771
  714612
  714889
  716522
  733498
  745962
  746158
  751094
  758190
  761127
  765490
  765706
  776830
  777847
  779073
  779877
  780174
  780297
  782059
  787438
  787556
  788691
  788879
  788885
  790044
  791095
  794672
  796726
  797595
  800895
  802458
  815717
  816270
  816388
  816465
]
17.35 ms
(11.60%)
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
  457765
  476745
  532991
  577664
  649559
  626547
  415525
  410732
  428335
  459258
  448304
  526902
  538260
  466859
  665940
  707510
  617616
  790044
  797595
  765490
  714889
  779073
  780174
  435411
  503749
  494789
  437560
  434877
  445315
  780297
  411729
  816270
  816388
  530728
  571586
  544466
  662375
  668937
  660150
  716522
  733498
  746158
  513223
  711771
  745962
  761127
  631173
  421543
  409163
  444481
  816465
  458229
  490468
  525165
  556760
  557097
  610097
  627747
  626545
  802458
  758190
  751094
  787556
  794672
  431597
  443197
  501567
  494572
  714612
  492308
  448547
  815717
  604641
  796726
  419245
  584441
  707546
  399694
  487012
  504950
  641985
  615347
  765706
  441160
  523866
  512960
  606604
  389756
  438631
  478809
  490638
  527882
  531216
  509933
  574068
  583176
  554243
  564569
  582316
  670913
  675183
  696985
  547674
  555159
  638555
  777847
  788879
  791095
  776830
  787438
  788691
  615147
  779877
  782059
  788885
  800895
  382681
  489756
  463132
  560179
]
2.18 ms
(1.45%)
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
  382681
  389756
  399694
  409163
  410732
  411729
  415525
  419245
  421543
  428335
  431597
  434877
  435411
  437560
  438631
  441160
  443197
  444481
  445315
  448304
  448547
  457765
  458229
  459258
  463132
  466859
  476745
  478809
  487012
  489756
  490468
  490638
  492308
  494572
  494789
  501567
  503749
  504950
  509933
  512960
  513223
  523866
  525165
  526902
  527882
  530728
  531216
  532991
  538260
  544466
  547674
  554243
  555159
  556760
  557097
  560179
  564569
  571586
  574068
  577664
  582316
  583176
  584441
  604641
  606604
  610097
  615147
  615347
  617616
  626545
  626547
  627747
  631173
  638555
  641985
  649559
  660150
  662375
  665940
  668937
  670913
  675183
  696985
  707510
  707546
  711771
  714612
  714889
  716522
  733498
  745962
  746158
  751094
  758190
  761127
  765490
  765706
  776830
  777847
  779073
  779877
  780174
  780297
  782059
  787438
  787556
  788691
  788879
  788885
  790044
  791095
  794672
  796726
  797595
  800895
  802458
  815717
  816270
  816388
  816465
]
1.83 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп мокрые секс"
]
1.74 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass wet sex"
]
1.64 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.00%)
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.