Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.38 ms
(83.80%)
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
  117596
  117806
  118359
  118869
  387473
  388364
  400638
  401205
  401508
  414601
  415029
  415964
  416032
  419891
  428223
  431485
  432274
  439052
  439056
  439138
  441110
  442132
  445103
  446407
  446778
  447985
  448791
  451358
  452637
  453585
  453822
  454983
  456229
  456239
  458820
  460716
  461612
  467155
  467196
  467715
  469120
  471682
  480452
  487416
  488752
  492181
  493490
  493734
  497480
  498037
  505661
  506268
  508888
  508924
  510807
  512940
  513639
  514849
  515488
  522112
  527920
  531193
  531869
  534550
  536128
  542124
  544140
  547236
  547468
  547474
  547488
  547847
  548445
  550550
  552819
  553646
  555026
  556876
  561040
  569608
  573204
  575601
  576493
  581121
  582511
  588029
  588514
  591604
  596989
  599834
  605026
  605133
  605219
  615921
  626044
  628094
  634786
  639797
  639960
  641685
  656916
  656933
  663217
  664149
  668645
  669038
  669067
  669080
  671044
  671052
  710709
  713184
  715786
  742279
  788767
  788926
  789529
  796339
  801636
  824340
]
19.38 ms
(10.59%)
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
  796339
  401205
  414601
  487416
  400638
  441110
  432274
  419891
  439052
  428223
  446778
  452637
  467196
  480452
  493490
  492181
  448791
  531193
  515488
  527920
  534550
  547488
  547847
  556876
  573204
  569608
  575601
  547468
  547474
  668645
  669038
  671044
  671052
  664149
  669067
  669080
  715786
  561040
  588029
  599834
  605133
  605219
  628094
  615921
  639797
  605026
  801636
  788926
  742279
  634786
  788767
  439138
  469120
  456229
  460716
  456239
  415964
  416032
  445103
  488752
  497480
  522112
  536128
  512940
  548445
  555026
  596989
  467155
  117596
  387473
  117806
  531869
  789529
  415029
  118359
  508924
  552819
  550550
  581121
  663217
  626044
  591604
  458820
  505661
  498037
  513639
  439056
  446407
  471682
  451358
  453822
  467715
  542124
  553646
  582511
  588514
  641685
  453585
  431485
  442132
  454983
  461612
  514849
  506268
  493734
  510807
  118869
  388364
  401508
  824340
  447985
  508888
  544140
  547236
  576493
  656916
  713184
  656933
  710709
  639960
]
3.38 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
  117596
  117806
  118359
  118869
  387473
  388364
  400638
  401205
  401508
  414601
  415029
  415964
  416032
  419891
  428223
  431485
  432274
  439052
  439056
  439138
  441110
  442132
  445103
  446407
  446778
  447985
  448791
  451358
  452637
  453585
  453822
  454983
  456229
  456239
  458820
  460716
  461612
  467155
  467196
  467715
  469120
  471682
  480452
  487416
  488752
  492181
  493490
  493734
  497480
  498037
  505661
  506268
  508888
  508924
  510807
  512940
  513639
  514849
  515488
  522112
  527920
  531193
  531869
  534550
  536128
  542124
  544140
  547236
  547468
  547474
  547488
  547847
  548445
  550550
  552819
  553646
  555026
  556876
  561040
  569608
  573204
  575601
  576493
  581121
  582511
  588029
  588514
  591604
  596989
  599834
  605026
  605133
  605219
  615921
  626044
  628094
  634786
  639797
  639960
  641685
  656916
  656933
  663217
  664149
  668645
  669038
  669067
  669080
  671044
  671052
  710709
  713184
  715786
  742279
  788767
  788926
  789529
  796339
  801636
  824340
]
1.94 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting vagina"
]
1.80 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг вагин"
]
1.67 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.81%)
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.