Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.61 ms
(81.78%)
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
  159511
  304300
  385831
  393245
  396635
  398144
  415515
  415905
  416242
  423958
  424014
  424129
  425144
  427972
  429211
  429228
  445868
  448805
  450098
  450251
  450579
  455694
  459617
  459803
  461677
  461957
  462143
  463818
  465501
  465613
  466603
  468603
  468943
  469119
  471696
  474724
  474776
  480450
  484261
  493256
  494665
  496049
  499927
  500100
  503118
  516771
  517038
  517655
  518083
  523623
  526533
  526766
  527490
  527915
  530483
  533644
  534812
  538802
  542216
  544668
  550680
  552021
  552965
  553765
  555389
  555407
  558711
  560065
  561271
  562706
  566901
  568519
  576509
  581933
  586086
  588298
  590262
  590373
  590843
  591995
  594283
  597803
  602948
  604483
  618301
  619376
  624079
  624925
  627442
  637975
  645238
  646450
  648618
  653720
  665259
  679636
  680625
  680928
  683878
  687583
  692714
  695923
  697833
  702336
  705768
  712832
  758832
  766637
  785777
  791537
  792746
  793492
  794895
  801313
  801762
  803628
  805434
  810347
  813558
  815492
]
20.16 ms
(11.98%)
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
  415905
  416242
  474776
  465501
  450251
  463818
  500100
  555389
  680928
  560065
  590843
  590373
  424129
  425144
  468943
  480450
  450098
  459803
  459617
  526766
  468603
  558711
  415515
  517655
  695923
  702336
  683878
  801313
  758832
  791537
  794895
  697833
  792746
  518083
  552965
  591995
  448805
  527915
  553765
  159511
  398144
  493256
  517038
  496049
  555407
  687583
  562706
  590262
  766637
  461677
  423958
  429228
  455694
  618301
  705768
  429211
  461957
  527490
  813558
  484261
  534812
  576509
  653720
  665259
  712832
  679636
  552021
  624079
  594283
  810347
  637975
  793492
  801762
  462143
  393245
  469119
  523623
  526533
  494665
  544668
  445868
  533644
  624925
  396635
  815492
  530483
  538802
  602948
  466603
  516771
  503118
  550680
  542216
  588298
  427972
  465613
  450579
  646450
  568519
  581933
  586086
  424014
  645238
  604483
  385831
  304300
  471696
  474724
  499927
  561271
  648618
  692714
  680625
  566901
  619376
  597803
  627442
  785777
  803628
  805434
]
3.46 ms
(2.06%)
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
  159511
  304300
  385831
  393245
  396635
  398144
  415515
  415905
  416242
  423958
  424014
  424129
  425144
  427972
  429211
  429228
  445868
  448805
  450098
  450251
  450579
  455694
  459617
  459803
  461677
  461957
  462143
  463818
  465501
  465613
  466603
  468603
  468943
  469119
  471696
  474724
  474776
  480450
  484261
  493256
  494665
  496049
  499927
  500100
  503118
  516771
  517038
  517655
  518083
  523623
  526533
  526766
  527490
  527915
  530483
  533644
  534812
  538802
  542216
  544668
  550680
  552021
  552965
  553765
  555389
  555407
  558711
  560065
  561271
  562706
  566901
  568519
  576509
  581933
  586086
  588298
  590262
  590373
  590843
  591995
  594283
  597803
  602948
  604483
  618301
  619376
  624079
  624925
  627442
  637975
  645238
  646450
  648618
  653720
  665259
  679636
  680625
  680928
  683878
  687583
  692714
  695923
  697833
  702336
  705768
  712832
  758832
  766637
  785777
  791537
  792746
  793492
  794895
  801313
  801762
  803628
  805434
  810347
  813558
  815492
]
2.13 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public anal toys"
]
1.86 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц анал toys"
]
1.45 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц анал toys"
]

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.