Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.05 ms
(81.26%)
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
  412738
  413785
  445273
  447771
  458627
  462904
  464303
  464424
  464985
  466961
  477721
  489980
  496327
  498237
  498308
  499842
  501569
  503418
  504869
  508441
  510591
  512659
  513189
  514206
  516773
  517708
  518282
  518543
  519644
  520832
  523864
  524296
  524299
  526675
  526874
  527062
  527278
  527818
  529214
  529300
  529347
  537487
  548229
  549706
  549735
  553992
  554545
  556150
  557324
  557443
  558177
  559377
  559691
  560410
  563609
  563898
  563930
  564751
  565468
  565987
  566850
  567213
  568849
  571056
  575194
  577811
  578494
  580340
  580518
  580921
  581809
  583527
  584352
  585060
  585405
  586659
  588633
  588637
  590118
  591036
  591647
  591875
  592715
  593186
  596714
  596887
  597739
  598376
  601350
  602002
  605291
  606076
  607201
  607227
  610669
  610786
  611285
  611898
  612792
  614479
  615421
  615749
  617175
  618575
  620398
  621160
  622378
  624168
  625108
  625239
  650570
  653266
  653512
  656372
  665121
  671371
  676911
  677416
  678787
  683508
]
17.63 ms
(12.03%)
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
  567213
  578494
  585405
  464303
  499842
  564751
  683508
  618575
  575194
  559377
  563930
  526874
  557443
  622378
  583527
  615749
  549706
  514206
  523864
  577811
  624168
  571056
  602002
  445273
  466961
  503418
  611285
  489980
  529347
  498237
  464424
  537487
  588637
  447771
  590118
  592715
  548229
  601350
  512659
  605291
  513189
  621160
  549735
  565987
  607227
  615421
  611898
  518282
  566850
  557324
  584352
  563609
  598376
  586659
  517708
  498308
  625108
  563898
  496327
  520832
  527278
  516773
  665121
  580518
  617175
  413785
  650570
  565468
  610786
  656372
  458627
  559691
  593186
  412738
  529300
  678787
  580921
  508441
  625239
  591036
  501569
  558177
  596887
  612792
  614479
  620398
  677416
  556150
  568849
  610669
  462904
  581809
  529214
  527062
  676911
  591875
  607201
  597739
  524299
  464985
  606076
  580340
  560410
  504869
  519644
  527818
  585060
  524296
  653512
  553992
  518543
  554545
  477721
  510591
  671371
  526675
  588633
  653266
  591647
  596714
]
2.64 ms
(1.80%)
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
  412738
  413785
  445273
  447771
  458627
  462904
  464303
  464424
  464985
  466961
  477721
  489980
  496327
  498237
  498308
  499842
  501569
  503418
  504869
  508441
  510591
  512659
  513189
  514206
  516773
  517708
  518282
  518543
  519644
  520832
  523864
  524296
  524299
  526675
  526874
  527062
  527278
  527818
  529214
  529300
  529347
  537487
  548229
  549706
  549735
  553992
  554545
  556150
  557324
  557443
  558177
  559377
  559691
  560410
  563609
  563898
  563930
  564751
  565468
  565987
  566850
  567213
  568849
  571056
  575194
  577811
  578494
  580340
  580518
  580921
  581809
  583527
  584352
  585060
  585405
  586659
  588633
  588637
  590118
  591036
  591647
  591875
  592715
  593186
  596714
  596887
  597739
  598376
  601350
  602002
  605291
  606076
  607201
  607227
  610669
  610786
  611285
  611898
  612792
  614479
  615421
  615749
  617175
  618575
  620398
  621160
  622378
  624168
  625108
  625239
  650570
  653266
  653512
  656372
  665121
  671371
  676911
  677416
  678787
  683508
]
2.01 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð▓ ÐéÐÇÐâÐüð©ð║ð░Ðà ÐéÐÇð¥ð│ð░ðÁÐé ð┐ð©ÐÔǪ"
]
1.85 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в трусик нижн бел трога вагин"
]
1.60 ms
(1.09%)
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.