Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.21 ms
(84.28%)
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
  398634
  418453
  423563
  425118
  443383
  447452
  447810
  451563
  453345
  463105
  465619
  474830
  476107
  479002
  483368
  483487
  492762
  493477
  496100
  496269
  502277
  505132
  509321
  510396
  511812
  514119
  514820
  515972
  516029
  516684
  522157
  522351
  523856
  524850
  524853
  524860
  524878
  525731
  529794
  530275
  530369
  530479
  530805
  531097
  531201
  531251
  531419
  532655
  532680
  532745
  533463
  533557
  533738
  533915
  534988
  534994
  535584
  535597
  536262
  537114
  540339
  540437
  541721
  541848
  541872
  543652
  543858
  543860
  544825
  545437
  546860
  548228
  554392
  556025
  559111
  565247
  568482
  588244
  596082
  597170
  597216
  598057
  599835
  599902
  600011
  604369
  617410
  617418
  630552
  630756
  631163
  631202
  632680
  632694
  632708
  634138
  634185
  634784
  637413
  639706
  639748
  641667
  645016
  647877
  647936
  648241
  648252
  648254
  648257
  648861
  649596
  650127
  651162
  665328
  674943
  677798
  680255
  789665
]
18.22 ms
(10.43%)
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
  535597
  483368
  541872
  546860
  548228
  568482
  645016
  648252
  648861
  651162
  677798
  565247
  634185
  598057
  617418
  639706
  596082
  599902
  604369
  641667
  632694
  443383
  447452
  425118
  523856
  514119
  483487
  423563
  463105
  476107
  492762
  522157
  533738
  531419
  536262
  530805
  535584
  647877
  680255
  650127
  639748
  789665
  617410
  631163
  632708
  451563
  418453
  453345
  511812
  496269
  502277
  509321
  637413
  465619
  474830
  479002
  530479
  540339
  514820
  524850
  530275
  534988
  531251
  531097
  537114
  544825
  559111
  647936
  649596
  648254
  632680
  631202
  634138
  496100
  516029
  493477
  447810
  515972
  524878
  525731
  505132
  510396
  524860
  543652
  543858
  543860
  541848
  630756
  597170
  634784
  532680
  540437
  524853
  532655
  532745
  648241
  674943
  545437
  588244
  599835
  630552
  522351
  516684
  529794
  554392
  531201
  534994
  541721
  648257
  597216
  556025
  533915
  530369
  600011
  398634
  533463
  533557
  665328
]
2.76 ms
(1.58%)
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
  398634
  418453
  423563
  425118
  443383
  447452
  447810
  451563
  453345
  463105
  465619
  474830
  476107
  479002
  483368
  483487
  492762
  493477
  496100
  496269
  502277
  505132
  509321
  510396
  511812
  514119
  514820
  515972
  516029
  516684
  522157
  522351
  523856
  524850
  524853
  524860
  524878
  525731
  529794
  530275
  530369
  530479
  530805
  531097
  531201
  531251
  531419
  532655
  532680
  532745
  533463
  533557
  533738
  533915
  534988
  534994
  535584
  535597
  536262
  537114
  540339
  540437
  541721
  541848
  541872
  543652
  543858
  543860
  544825
  545437
  546860
  548228
  554392
  556025
  559111
  565247
  568482
  588244
  596082
  597170
  597216
  598057
  599835
  599902
  600011
  604369
  617410
  617418
  630552
  630756
  631163
  631202
  632680
  632694
  632708
  634138
  634185
  634784
  637413
  639706
  639748
  641667
  645016
  647877
  647936
  648241
  648252
  648254
  648257
  648861
  649596
  650127
  651162
  665328
  674943
  677798
  680255
  789665
]
1.83 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "групповое наручники"
]
1.64 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "группов бдсм"
]
1.59 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 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.