Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
221.41 ms
(48.26%)
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
  346210
  382184
  388113
  392277
  394376
  395427
  395556
  395924
  396954
  399518
  400125
  400143
  401225
  401621
  402599
  403600
  407187
  407703
  411038
  411310
  411591
  413110
  416408
  420540
  421854
  422154
  422295
  424276
  428539
  428547
  428904
  433681
  437583
  438199
  443182
  443969
  445709
  446269
  446299
  448707
  448958
  450147
  450161
  454050
  456605
  457187
  458012
  458708
  460273
  460677
  460679
  462110
  464410
  471408
  472166
  474792
  474797
  476336
  476337
  480833
  486896
  490740
  491983
  492302
  496112
  504104
  506136
  506833
  513728
  515022
  519929
  527148
  530409
  531979
  531997
  532063
  532064
  532126
  532825
  546425
  546937
  549719
  550223
  551035
  554897
  561465
  561587
  563443
  563453
  582656
  625493
  625649
  663929
  680702
  688083
  710588
  718558
  724156
  725402
  736379
  736402
  736977
  739965
  743811
  746267
  746685
  751498
  758594
  769490
  777217
  780795
  782626
  789188
  792522
  796214
  798763
  800926
  807453
]
212.37 ms
(46.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
16.02 ms
(3.49%)
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
  510295
  546425
  625649
  782626
  769490
  751498
  697939
  401621
  413110
  420540
  438199
  471408
  394376
  403600
  563443
  400143
  416408
  437583
  519929
  513728
  392277
  388113
  401225
  411038
  458708
  454050
  464410
  492302
  515022
  532126
  532825
  527148
  531997
  532063
  490740
  549719
  561465
  561587
  582656
  625493
  789188
  807453
  777217
  780795
  792522
  798763
  800926
  736977
  796214
  725402
  746267
  758594
  736379
  739965
  428904
  457187
  395924
  395427
  395556
  399518
  400125
  428539
  433681
  443182
  680702
  445709
  446299
  448958
  450147
  460679
  486896
  458012
  460273
  476337
  506136
  462110
  546937
  554897
  550223
  663929
  710588
  688083
  718558
  736402
  746685
  724156
  743811
  422295
  474792
  448707
  424276
  450161
  346210
  474797
  480833
  491983
  421854
  422154
  382184
  407703
  428547
  446269
  472166
  496112
  504104
  563453
  411591
  456605
  506833
  460677
  396954
  402599
  411310
  407187
  443969
  530409
  531979
  532064
  476336
  551035
]
3.72 ms
(0.81%)
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
  346210
  382184
  388113
  392277
  394376
  395427
  395556
  395924
  396954
  399518
  400125
  400143
  401225
  401621
  402599
  403600
  407187
  407703
  411038
  411310
  411591
  413110
  416408
  420540
  421854
  422154
  422295
  424276
  428539
  428547
  428904
  433681
  437583
  438199
  443182
  443969
  445709
  446269
  446299
  448707
  448958
  450147
  450161
  454050
  456605
  457187
  458012
  458708
  460273
  460677
  460679
  462110
  464410
  471408
  472166
  474792
  474797
  476336
  476337
  480833
  486896
  490740
  491983
  492302
  496112
  504104
  506136
  506833
  513728
  515022
  519929
  527148
  530409
  531979
  531997
  532063
  532064
  532126
  532825
  546425
  546937
  549719
  550223
  551035
  554897
  561465
  561587
  563443
  563453
  582656
  625493
  625649
  663929
  680702
  688083
  710588
  718558
  724156
  725402
  736379
  736402
  736977
  739965
  743811
  746267
  746685
  751498
  758594
  769490
  777217
  780795
  782626
  789188
  792522
  796214
  798763
  800926
  807453
]
1.91 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boy son mom"
]
1.87 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен son mom"
]
1.44 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен son mom"
]

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.