Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.80 ms
(82.02%)
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
  177261
  240689
  373875
  389738
  395587
  407823
  409814
  411684
  421835
  421885
  422181
  423816
  425037
  425113
  432663
  436138
  438597
  439802
  440445
  440746
  440944
  442118
  447745
  451456
  454722
  465532
  465773
  467907
  467952
  468395
  469372
  474743
  478652
  481206
  486219
  486702
  487363
  489323
  493992
  494967
  499428
  502796
  505978
  508942
  511271
  513626
  514245
  514931
  516724
  521138
  521241
  531698
  536457
  557244
  558982
  563643
  564039
  566771
  573405
  576920
  579799
  583428
  584474
  591714
  592518
  592561
  603084
  620172
  622233
  628471
  632146
  632397
  641879
  650614
  653549
  655238
  655297
  674492
  674531
  675482
  677698
  684754
  691856
  701448
  704705
  706656
  708512
  711651
  720225
  725121
  730046
  733340
  735951
  750315
  755369
  755457
  756230
  756810
  759975
  761300
  766719
  770130
  770864
  776227
  789685
  795658
  796661
  798207
  801249
  802467
  809661
  814267
  814520
  815806
  815862
  817729
  817787
  818477
  820118
  822271
]
16.80 ms
(11.22%)
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
  583428
  440445
  513626
  177261
  409814
  451456
  467952
  486219
  487363
  514931
  511271
  516724
  468395
  557244
  564039
  579799
  573405
  558982
  576920
  653549
  684754
  563643
  592561
  591714
  422181
  454722
  421885
  425113
  439802
  465773
  481206
  421835
  425037
  469372
  474743
  478652
  438597
  536457
  486702
  494967
  502796
  411684
  432663
  756230
  447745
  436138
  815862
  818477
  817787
  814267
  531698
  655238
  701448
  708512
  706656
  720225
  655297
  674492
  675482
  691856
  704705
  592518
  620172
  628471
  641879
  789685
  776227
  798207
  801249
  725121
  733340
  759975
  802467
  755369
  766719
  770130
  770864
  730046
  761300
  750315
  755457
  756810
  632146
  632397
  711651
  795658
  796661
  809661
  395587
  489323
  566771
  622233
  603084
  467907
  521138
  440746
  389738
  677698
  521241
  674531
  373875
  407823
  505978
  584474
  650614
  508942
  735951
  440944
  493992
  423816
  442118
  240689
  817729
  814520
  815806
  820118
  822271
  499428
  514245
  465532
]
2.76 ms
(1.84%)
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
  177261
  240689
  373875
  389738
  395587
  407823
  409814
  411684
  421835
  421885
  422181
  423816
  425037
  425113
  432663
  436138
  438597
  439802
  440445
  440746
  440944
  442118
  447745
  451456
  454722
  465532
  465773
  467907
  467952
  468395
  469372
  474743
  478652
  481206
  486219
  486702
  487363
  489323
  493992
  494967
  499428
  502796
  505978
  508942
  511271
  513626
  514245
  514931
  516724
  521138
  521241
  531698
  536457
  557244
  558982
  563643
  564039
  566771
  573405
  576920
  579799
  583428
  584474
  591714
  592518
  592561
  603084
  620172
  622233
  628471
  632146
  632397
  641879
  650614
  653549
  655238
  655297
  674492
  674531
  675482
  677698
  684754
  691856
  701448
  704705
  706656
  708512
  711651
  720225
  725121
  730046
  733340
  735951
  750315
  755369
  755457
  756230
  756810
  759975
  761300
  766719
  770130
  770864
  776227
  789685
  795658
  796661
  798207
  801249
  802467
  809661
  814267
  814520
  815806
  815862
  817729
  817787
  818477
  820118
  822271
]
2.21 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal no panties"
]
1.93 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал трусик нижн бел"
]
1.66 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал трусик нижн бел"
]
1.55 ms
(1.03%)
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.