Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.29 ms
(83.29%)
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
  397609
  405742
  416606
  417050
  419739
  433310
  433353
  434530
  435180
  437633
  437738
  439109
  442325
  443627
  444083
  452632
  453900
  454447
  454944
  454992
  456487
  459173
  461259
  461899
  466372
  470348
  476316
  481345
  484123
  485385
  494279
  495057
  496708
  507101
  508486
  509259
  509746
  510121
  510690
  512321
  516404
  517938
  521605
  523763
  527146
  527230
  529445
  535819
  536801
  537100
  539057
  541526
  548844
  549731
  550688
  556885
  560464
  560684
  560968
  561925
  562027
  564696
  568761
  569205
  572326
  574995
  577545
  577690
  580631
  582077
  582728
  584228
  585095
  588405
  590188
  591259
  591667
  591827
  592143
  595278
  595357
  597198
  599320
  600395
  609203
  609630
  616818
  619955
  620180
  621778
  626441
  628622
  634826
  635185
  656904
  670622
  675125
  683504
  687937
  688146
  688423
  695070
  696480
  698015
  698883
  699482
  712771
  714623
  715537
  720291
  739479
  750893
  753963
  756918
  761722
  785148
  785876
  803076
  812661
  812852
]
16.76 ms
(10.63%)
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
  698015
  443627
  437738
  476316
  537100
  699482
  675125
  695070
  696480
  714623
  687937
  715537
  595278
  628622
  591667
  619955
  634826
  785148
  785876
  803076
  750893
  761722
  753963
  419739
  509746
  535819
  512321
  397609
  481345
  452632
  591827
  688423
  739479
  417050
  523763
  536801
  550688
  577545
  541526
  548844
  560684
  582077
  562027
  574995
  670622
  683504
  577690
  600395
  609630
  592143
  433353
  434530
  516404
  459173
  495057
  470348
  456487
  564696
  507101
  509259
  812852
  590188
  496708
  521605
  527146
  561925
  597198
  609203
  588405
  461259
  435180
  484123
  529445
  405742
  485385
  720291
  454447
  560464
  698883
  756918
  437633
  444083
  453900
  580631
  616818
  591259
  442325
  508486
  510121
  510690
  517938
  439109
  585095
  461899
  549731
  656904
  712771
  569205
  572326
  582728
  595357
  599320
  621778
  620180
  812661
  539057
  688146
  494279
  527230
  635185
  454992
  433310
  466372
  626441
  454944
  416606
  568761
  556885
  560968
  584228
]
2.38 ms
(1.51%)
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
  397609
  405742
  416606
  417050
  419739
  433310
  433353
  434530
  435180
  437633
  437738
  439109
  442325
  443627
  444083
  452632
  453900
  454447
  454944
  454992
  456487
  459173
  461259
  461899
  466372
  470348
  476316
  481345
  484123
  485385
  494279
  495057
  496708
  507101
  508486
  509259
  509746
  510121
  510690
  512321
  516404
  517938
  521605
  523763
  527146
  527230
  529445
  535819
  536801
  537100
  539057
  541526
  548844
  549731
  550688
  556885
  560464
  560684
  560968
  561925
  562027
  564696
  568761
  569205
  572326
  574995
  577545
  577690
  580631
  582077
  582728
  584228
  585095
  588405
  590188
  591259
  591667
  591827
  592143
  595278
  595357
  597198
  599320
  600395
  609203
  609630
  616818
  619955
  620180
  621778
  626441
  628622
  634826
  635185
  656904
  670622
  675125
  683504
  687937
  688146
  688423
  695070
  696480
  698015
  698883
  699482
  712771
  714623
  715537
  720291
  739479
  750893
  753963
  756918
  761722
  785148
  785876
  803076
  812661
  812852
]
2.17 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife new dick"
]
1.78 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен new член"
]
1.65 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен new член"
]

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.