Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.29 ms
(54.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "длинные девушк"
]
156.93 ms
(40.32%)
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
  435054
  455846
  463889
  486237
  491354
  515398
  515527
  526188
  529555
  530293
  530331
  531669
  533555
  538015
  540148
  544366
  547666
  548362
  549892
  552915
  562407
  562605
  563366
  563371
  572590
  576325
  581362
  586867
  595855
  598651
  600222
  600890
  608013
  610251
  612965
  615754
  648595
  648983
  652959
  655701
  656392
  656403
  656749
  656990
  657298
  657665
  658046
  658047
  658063
  659544
  660315
  660923
  660930
  665116
  665645
  669413
  671088
  671102
  693512
  696257
  700529
  704973
  710144
  713118
  715597
  722402
  725137
  728005
  735991
  735994
  739914
  740478
  740942
  740943
  742231
  743259
  743569
  743700
  744116
  744335
  747594
  749795
  749850
  752093
  752175
  752764
  753142
  754391
  754688
  754739
  763476
  770443
  774484
  778128
  780258
  780629
  780884
  780889
  782741
  782950
  783373
  783835
  785460
  801658
  805488
  816839
  816843
  817187
  817814
  818056
  819121
  820793
  825031
  826355
  827248
  827293
  827681
  828053
  828265
]
11.32 ms
(2.91%)
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
  486237
  526188
  665116
  600222
  455846
  435054
  463889
  491354
  529555
  515527
  600890
  780889
  782950
  783835
  740942
  743259
  725137
  739914
  742231
  740943
  822507
  828265
  655701
  818056
  826355
  816843
  530331
  562605
  572590
  652959
  660923
  669413
  657665
  658046
  658063
  696257
  656990
  657298
  549892
  608013
  778128
  780258
  735994
  752093
  754391
  754739
  770443
  715597
  515398
  576325
  544366
  825031
  817814
  827681
  533555
  530293
  531669
  538015
  562407
  581362
  547666
  563366
  563371
  660315
  704973
  656403
  665645
  648983
  658047
  659544
  710144
  552915
  595855
  598651
  612965
  610251
  586867
  615754
  774484
  782741
  783373
  801658
  805488
  735991
  753142
  785460
  740478
  728005
  744335
  752175
  752764
  763476
  744116
  754688
  743569
  743700
  747594
  749795
  749850
  713118
  722402
  780629
  780884
  820793
  816839
  827248
  827293
  817187
  819121
  828053
  540148
  548362
  648595
  660930
  700529
  656392
  671088
  693512
  656749
  671102
]
3.60 ms
(0.93%)
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
  435054
  455846
  463889
  486237
  491354
  515398
  515527
  526188
  529555
  530293
  530331
  531669
  533555
  538015
  540148
  544366
  547666
  548362
  549892
  552915
  562407
  562605
  563366
  563371
  572590
  576325
  581362
  586867
  595855
  598651
  600222
  600890
  608013
  610251
  612965
  615754
  648595
  648983
  652959
  655701
  656392
  656403
  656749
  656990
  657298
  657665
  658046
  658047
  658063
  659544
  660315
  660923
  660930
  665116
  665645
  669413
  671088
  671102
  693512
  696257
  700529
  704973
  710144
  713118
  715597
  722402
  725137
  728005
  735991
  735994
  739914
  740478
  740942
  740943
  742231
  743259
  743569
  743700
  744116
  744335
  747594
  749795
  749850
  752093
  752175
  752764
  753142
  754391
  754688
  754739
  763476
  770443
  774484
  778128
  780258
  780629
  780884
  780889
  782741
  782950
  783373
  783835
  785460
  801658
  805488
  816839
  816843
  817187
  817814
  818056
  819121
  820793
  825031
  826355
  827248
  827293
  827681
  828053
  828265
]
2.37 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "long girls"
]
1.87 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.