Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.06 ms
(87.72%)
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
  387489
  395367
  453210
  475615
  486869
  496865
  502816
  506277
  527140
  529764
  531984
  532048
  535003
  540075
  540127
  540174
  540707
  542211
  542427
  546617
  547406
  548895
  550511
  553155
  553545
  553753
  554698
  554708
  554735
  555301
  557766
  558894
  559970
  560414
  560912
  561044
  563971
  563977
  574077
  575868
  583755
  584864
  586615
  592118
  595306
  600668
  601648
  602964
  605632
  606992
  632471
  634363
  636726
  641298
  653691
  654006
  660442
  661028
  668733
  673935
  687778
  694420
  695495
  696287
  697878
  700818
  703689
  708320
  711695
  713423
  714594
  715133
  715621
  716148
  718908
  724754
  735183
  737998
  738891
  745335
  746057
  748627
  764104
  766929
  767718
  769197
  786136
  786320
  787392
  790712
  792425
  793563
  793602
  795108
  796971
  798745
  800436
  811541
  816666
  817214
  817277
  818109
  818128
  818750
  819112
  819527
  819811
  819940
  820026
  823725
  823888
  824274
  825035
  825191
  825824
  825904
  825925
  826321
  826544
  827547
]
11.83 ms
(6.17%)
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
  703689
  560912
  636726
  786320
  738891
  767718
  746057
  715133
  793563
  823888
  823725
  820026
  825191
  819112
  824274
  529764
  540174
  506277
  532048
  546617
  557766
  584864
  560414
  668733
  711695
  563971
  634363
  601648
  793602
  737998
  748627
  766929
  745335
  769197
  724754
  735183
  764104
  632471
  387489
  475615
  502816
  527140
  558894
  550511
  553545
  586615
  602964
  496865
  486869
  660442
  700818
  654006
  694420
  605632
  595306
  395367
  825925
  826544
  825904
  816666
  817214
  817277
  818109
  818128
  819940
  827547
  819811
  825824
  818750
  819527
  825035
  826321
  453210
  540707
  540127
  531984
  540075
  535003
  542211
  554698
  554735
  575868
  542427
  553753
  561044
  574077
  583755
  548895
  553155
  554708
  563977
  653691
  697878
  718908
  661028
  687778
  714594
  716148
  673935
  695495
  696287
  708320
  713423
  715621
  547406
  555301
  559970
  600668
  641298
  592118
  606992
  787392
  792425
  798745
  800436
  811541
  786136
  790712
  795108
  796971
]
3.79 ms
(1.98%)
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
  387489
  395367
  453210
  475615
  486869
  496865
  502816
  506277
  527140
  529764
  531984
  532048
  535003
  540075
  540127
  540174
  540707
  542211
  542427
  546617
  547406
  548895
  550511
  553155
  553545
  553753
  554698
  554708
  554735
  555301
  557766
  558894
  559970
  560414
  560912
  561044
  563971
  563977
  574077
  575868
  583755
  584864
  586615
  592118
  595306
  600668
  601648
  602964
  605632
  606992
  632471
  634363
  636726
  641298
  653691
  654006
  660442
  661028
  668733
  673935
  687778
  694420
  695495
  696287
  697878
  700818
  703689
  708320
  711695
  713423
  714594
  715133
  715621
  716148
  718908
  724754
  735183
  737998
  738891
  745335
  746057
  748627
  764104
  766929
  767718
  769197
  786136
  786320
  787392
  790712
  792425
  793563
  793602
  795108
  796971
  798745
  800436
  811541
  816666
  817214
  817277
  818109
  818128
  818750
  819112
  819527
  819811
  819940
  820026
  823725
  823888
  824274
  825035
  825191
  825824
  825904
  825925
  826321
  826544
  827547
]
2.18 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен туалет"
]
2.00 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жену в туалет"
]
1.93 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.94%)
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.