Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.32 ms
(85.24%)
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
  395463
  402238
  420600
  424074
  427230
  443367
  446634
  454250
  455114
  455708
  456193
  458739
  458777
  459751
  462523
  462540
  463169
  464580
  469874
  469905
  470251
  470731
  470737
  470792
  473239
  475453
  475962
  476381
  476742
  479314
  491198
  494369
  495845
  499506
  507370
  511591
  511691
  518316
  519725
  533514
  545528
  545914
  546001
  546627
  548064
  548092
  549774
  556845
  561901
  562148
  570469
  574808
  575685
  576292
  595465
  597077
  597135
  597195
  598013
  598032
  598804
  600894
  611700
  611890
  621288
  641749
  654438
  659858
  660272
  678607
  678783
  679381
  684588
  694114
  694160
  694533
  694585
  695804
  715083
  717745
  717810
  721368
  721439
  721496
  721556
  721574
  722332
  722596
  723439
  725638
  731035
  735524
  735821
  744698
  747558
  752685
  754141
  758986
  762414
  763349
  768691
  779798
  780141
  781708
  787930
  789182
  790876
  798992
  800000
  800365
  802596
  804903
  804972
  805162
  807333
  810844
  813549
  816661
  823359
  825499
]
14.93 ms
(9.69%)
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
  575685
  721556
  717745
  641749
  597077
  780141
  800365
  763349
  731035
  747558
  762414
  545914
  598013
  476742
  462523
  463169
  519725
  562148
  598804
  473239
  455114
  470737
  443367
  455708
  464580
  475962
  494369
  816661
  717810
  659858
  779798
  545528
  546627
  548092
  598032
  462540
  470792
  499506
  721574
  823359
  825499
  660272
  678783
  723439
  694160
  722332
  595465
  597135
  611890
  790876
  758986
  802596
  804972
  725638
  744698
  715083
  402238
  469874
  518316
  574808
  549774
  556845
  576292
  597195
  424074
  458739
  459751
  454250
  456193
  476381
  470731
  511591
  491198
  533514
  600894
  546001
  470251
  813549
  570469
  561901
  654438
  679381
  684588
  694585
  694533
  721439
  722596
  548064
  621288
  800000
  810844
  787930
  798992
  735821
  754141
  789182
  395463
  469905
  611700
  427230
  458777
  475453
  420600
  495845
  511691
  721496
  807333
  781708
  805162
  479314
  678607
  768691
  804903
  446634
  752685
  735524
  507370
  695804
  721368
  694114
]
2.30 ms
(1.49%)
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
  395463
  402238
  420600
  424074
  427230
  443367
  446634
  454250
  455114
  455708
  456193
  458739
  458777
  459751
  462523
  462540
  463169
  464580
  469874
  469905
  470251
  470731
  470737
  470792
  473239
  475453
  475962
  476381
  476742
  479314
  491198
  494369
  495845
  499506
  507370
  511591
  511691
  518316
  519725
  533514
  545528
  545914
  546001
  546627
  548064
  548092
  549774
  556845
  561901
  562148
  570469
  574808
  575685
  576292
  595465
  597077
  597135
  597195
  598013
  598032
  598804
  600894
  611700
  611890
  621288
  641749
  654438
  659858
  660272
  678607
  678783
  679381
  684588
  694114
  694160
  694533
  694585
  695804
  715083
  717745
  717810
  721368
  721439
  721496
  721556
  721574
  722332
  722596
  723439
  725638
  731035
  735524
  735821
  744698
  747558
  752685
  754141
  758986
  762414
  763349
  768691
  779798
  780141
  781708
  787930
  789182
  790876
  798992
  800000
  800365
  802596
  804903
  804972
  805162
  807333
  810844
  813549
  816661
  823359
  825499
]
1.54 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐÇÐâÐüÐüð║ð░ÐÅ ð┤ðÁð▓ÐâÐêð║ð░ Ðü ð┤ðÁð┤ÐÔǪ"
]
1.51 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск девушк старый"
]
1.26 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск девушк старый"
]
1.21 ms
(0.78%)
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.