Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.34 ms
(85.10%)
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
  95673
  188269
  382355
  387544
  387550
  389899
  391941
  403010
  405054
  411638
  413263
  414184
  416765
  420547
  426607
  428334
  428523
  430704
  434724
  443113
  443453
  444046
  445037
  445363
  446165
  446330
  447124
  448810
  448887
  450515
  451266
  451963
  452956
  453512
  457089
  457983
  458592
  458992
  459395
  463162
  464326
  464506
  464513
  467839
  468721
  470389
  470561
  470641
  470792
  471412
  471792
  472125
  472792
  474461
  475115
  475630
  477941
  479064
  479523
  480941
  481151
  482317
  482946
  483037
  483375
  484092
  490511
  491938
  492040
  493304
  496863
  500571
  501154
  503336
  503965
  509448
  509481
  510589
  510592
  512436
  515224
  516241
  516635
  517749
  518759
  519949
  521836
  526133
  545318
  546106
  546940
  560188
  561137
  561898
  564172
  566297
  567146
  567457
  574364
  577356
  579592
  581738
  586623
  587263
  593125
  596809
  598198
  607924
  609196
  611986
  613857
  616994
  624110
  644959
  653523
  656158
  659347
  720885
  748950
  807927
]
17.40 ms
(9.53%)
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
  517749
  577356
  464326
  387544
  458992
  446330
  480941
  391941
  403010
  470641
  510592
  434724
  564172
  607924
  748950
  444046
  509448
  472125
  586623
  428523
  450515
  574364
  464506
  464513
  445037
  516241
  496863
  493304
  593125
  579592
  475630
  428334
  448887
  521836
  598198
  445363
  470792
  644959
  566297
  561898
  656158
  457089
  659347
  561137
  413263
  448810
  510589
  387550
  416765
  500571
  405054
  411638
  451963
  653523
  807927
  479523
  482317
  484092
  611986
  389899
  483375
  457983
  567146
  567457
  587263
  613857
  472792
  188269
  453512
  503965
  483037
  515224
  609196
  616994
  95673
  443453
  459395
  471412
  581738
  545318
  624110
  414184
  382355
  426607
  447124
  475115
  470561
  519949
  516635
  443113
  430704
  452956
  458592
  467839
  470389
  518759
  546106
  451266
  560188
  446165
  720885
  596809
  492040
  526133
  490511
  481151
  463162
  468721
  477941
  491938
  482946
  512436
  474461
  479064
  509481
  546940
  503336
  420547
  471792
  501154
]
2.79 ms
(1.53%)
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
  95673
  188269
  382355
  387544
  387550
  389899
  391941
  403010
  405054
  411638
  413263
  414184
  416765
  420547
  426607
  428334
  428523
  430704
  434724
  443113
  443453
  444046
  445037
  445363
  446165
  446330
  447124
  448810
  448887
  450515
  451266
  451963
  452956
  453512
  457089
  457983
  458592
  458992
  459395
  463162
  464326
  464506
  464513
  467839
  468721
  470389
  470561
  470641
  470792
  471412
  471792
  472125
  472792
  474461
  475115
  475630
  477941
  479064
  479523
  480941
  481151
  482317
  482946
  483037
  483375
  484092
  490511
  491938
  492040
  493304
  496863
  500571
  501154
  503336
  503965
  509448
  509481
  510589
  510592
  512436
  515224
  516241
  516635
  517749
  518759
  519949
  521836
  526133
  545318
  546106
  546940
  560188
  561137
  561898
  564172
  566297
  567146
  567457
  574364
  577356
  579592
  581738
  586623
  587263
  593125
  596809
  598198
  607924
  609196
  611986
  613857
  616994
  624110
  644959
  653523
  656158
  659347
  720885
  748950
  807927
]
1.91 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс два мужчин"
]
1.78 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс два мужчин"
]
1.72 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс два мужика"
]
1.59 ms
(0.87%)
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.