Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
200.71 ms
(88.94%)
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
  282626
  426734
  426929
  444829
  458718
  464243
  493083
  495206
  501513
  521221
  523071
  524179
  527915
  530143
  532673
  533550
  534466
  535100
  535606
  541090
  541462
  542349
  542370
  544571
  544939
  544975
  545214
  545480
  545944
  546341
  546377
  546827
  547700
  549004
  549406
  549538
  550049
  550574
  551074
  551984
  553810
  554082
  554597
  555826
  555829
  556431
  559089
  559185
  559186
  559233
  561064
  561740
  562214
  565800
  567416
  568479
  569726
  569740
  569744
  569763
  571671
  574421
  585244
  588716
  589928
  593330
  596882
  596976
  597183
  604336
  605446
  614654
  624230
  633077
  637771
  638141
  642212
  651696
  652081
  660694
  660704
  667338
  683054
  687955
  696865
  700272
  700284
  705215
  716635
  717969
  717990
  719981
  720818
  722101
  725524
  729776
  729962
  731384
  740620
  742856
  742898
  745279
  745383
  745502
  745660
  748746
  765742
  780533
  782776
  787634
  787983
  788867
  789801
  808705
  809072
  810465
  810791
  812305
  817144
  827083
]
14.58 ms
(6.46%)
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
  567416
  282626
  544571
  559089
  574421
  571671
  527915
  545480
  546377
  565800
  700284
  729776
  559233
  549406
  596882
  458718
  545944
  556431
  562214
  765742
  544939
  546341
  596976
  745279
  521221
  561740
  667338
  605446
  809072
  808705
  547700
  683054
  717990
  827083
  687955
  740620
  593330
  549538
  780533
  569740
  633077
  722101
  551984
  717969
  787634
  535606
  464243
  810791
  638141
  660704
  660694
  554597
  541462
  568479
  745502
  555826
  731384
  549004
  716635
  589928
  588716
  729962
  545214
  532673
  782776
  651696
  426929
  533550
  559185
  550574
  569763
  817144
  614654
  569726
  555829
  745383
  559186
  720818
  652081
  550049
  501513
  534466
  495206
  569744
  789801
  524179
  787983
  745660
  523071
  542370
  725524
  742898
  426734
  530143
  546827
  544975
  810465
  493083
  642212
  742856
  585244
  624230
  444829
  541090
  554082
  535100
  696865
  597183
  604336
  788867
  812305
  748746
  637771
  542349
  551074
  561064
  700272
  705215
  719981
  553810
]
2.46 ms
(1.09%)
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
  282626
  426734
  426929
  444829
  458718
  464243
  493083
  495206
  501513
  521221
  523071
  524179
  527915
  530143
  532673
  533550
  534466
  535100
  535606
  541090
  541462
  542349
  542370
  544571
  544939
  544975
  545214
  545480
  545944
  546341
  546377
  546827
  547700
  549004
  549406
  549538
  550049
  550574
  551074
  551984
  553810
  554082
  554597
  555826
  555829
  556431
  559089
  559185
  559186
  559233
  561064
  561740
  562214
  565800
  567416
  568479
  569726
  569740
  569744
  569763
  571671
  574421
  585244
  588716
  589928
  593330
  596882
  596976
  597183
  604336
  605446
  614654
  624230
  633077
  637771
  638141
  642212
  651696
  652081
  660694
  660704
  667338
  683054
  687955
  696865
  700272
  700284
  705215
  716635
  717969
  717990
  719981
  720818
  722101
  725524
  729776
  729962
  731384
  740620
  742856
  742898
  745279
  745383
  745502
  745660
  748746
  765742
  780533
  782776
  787634
  787983
  788867
  789801
  808705
  809072
  810465
  810791
  812305
  817144
  827083
]
2.41 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк доминирован"
]
2.02 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl slave"
]
1.79 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.75%)
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.