Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.80 ms
(87.37%)
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
  4279
  181304
  181612
  383715
  383774
  388887
  389388
  393833
  395174
  409045
  409105
  409933
  410709
  413947
  417384
  421408
  421942
  422043
  423981
  424261
  425947
  426316
  427631
  439668
  450344
  453218
  453805
  454478
  455620
  455885
  456453
  457569
  459022
  460308
  460930
  461060
  463156
  463403
  464159
  464202
  464552
  465351
  465897
  465906
  466281
  466324
  466904
  467525
  468105
  468180
  469565
  471619
  472069
  475377
  476975
  478121
  478163
  478247
  478423
  479023
  482519
  482723
  482763
  482907
  484544
  488023
  488468
  488603
  491138
  491830
  491926
  491975
  491982
  492003
  492013
  492616
  493131
  494943
  496719
  498598
  499194
  499331
  499806
  500377
  501082
  502737
  503491
  503682
  505702
  509234
  512500
  512636
  514844
  515694
  515855
  520490
  520501
  520640
  520819
  521166
  522122
  522578
  522849
  522953
  527362
  528112
  528733
  531278
  531524
  535758
  665042
  675725
  747296
  755462
  762611
  811489
  815683
  815793
  828644
  828845
]
14.70 ms
(7.27%)
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
  466324
  409045
  512636
  496719
  494943
  500377
  463403
  482723
  665042
  383715
  488468
  499331
  460308
  482763
  482907
  478121
  409933
  521166
  475377
  466281
  478163
  515855
  528112
  453805
  476975
  393833
  675725
  491830
  459022
  747296
  413947
  389388
  425947
  464552
  454478
  181304
  181612
  410709
  422043
  426316
  450344
  469565
  455620
  453218
  465897
  488603
  509234
  505702
  466904
  472069
  463156
  465906
  468180
  383774
  456453
  395174
  465351
  468105
  491982
  503682
  491926
  491975
  492013
  520490
  520640
  815683
  815793
  828845
  828644
  514844
  762611
  811489
  755462
  488023
  421408
  484544
  528733
  461060
  4279
  388887
  493131
  520501
  423981
  535758
  421942
  427631
  417384
  457569
  464202
  502737
  515694
  522849
  499806
  478423
  409105
  455885
  478247
  460930
  464159
  479023
  503491
  522953
  522122
  527362
  492616
  501082
  522578
  491138
  492003
  499194
  482519
  531278
  531524
  498598
  512500
  520819
  471619
  424261
  439668
  467525
]
3.32 ms
(1.64%)
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
  4279
  181304
  181612
  383715
  383774
  388887
  389388
  393833
  395174
  409045
  409105
  409933
  410709
  413947
  417384
  421408
  421942
  422043
  423981
  424261
  425947
  426316
  427631
  439668
  450344
  453218
  453805
  454478
  455620
  455885
  456453
  457569
  459022
  460308
  460930
  461060
  463156
  463403
  464159
  464202
  464552
  465351
  465897
  465906
  466281
  466324
  466904
  467525
  468105
  468180
  469565
  471619
  472069
  475377
  476975
  478121
  478163
  478247
  478423
  479023
  482519
  482723
  482763
  482907
  484544
  488023
  488468
  488603
  491138
  491830
  491926
  491975
  491982
  492003
  492013
  492616
  493131
  494943
  496719
  498598
  499194
  499331
  499806
  500377
  501082
  502737
  503491
  503682
  505702
  509234
  512500
  512636
  514844
  515694
  515855
  520490
  520501
  520640
  520819
  521166
  522122
  522578
  522849
  522953
  527362
  528112
  528733
  531278
  531524
  535758
  665042
  675725
  747296
  755462
  762611
  811489
  815683
  815793
  828644
  828845
]
2.10 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white stockings"
]
1.95 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white чулк нижн бел"
]
1.82 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white чулк нижн бел"
]

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.