GET https://search.jues.net/search/embeds/5?q=%D1%81%D0%BE%D1%81%D0%B5%D1%82%20%D0%B7%D1%80%D0%B5%D0%BB%D0%B0%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.17 ms
(85.08%)
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
  14578
  390212
  440868
  461371
  463778
  465071
  467001
  470420
  474103
  476264
  476379
  477156
  477737
  478003
  478252
  478451
  478667
  481840
  483092
  486807
  490033
  494732
  498626
  500214
  501498
  503830
  504155
  505108
  506068
  507916
  509633
  512965
  516631
  517568
  519938
  520157
  520906
  521529
  522914
  523034
  524778
  525017
  526421
  526891
  529122
  529140
  529232
  532059
  533728
  533997
  535025
  536483
  536884
  540733
  544187
  545943
  546115
  549217
  549715
  550831
  555263
  556654
  557148
  557150
  557180
  558077
  558339
  561096
  562895
  562955
  563619
  565713
  568427
  569415
  570722
  570963
  573230
  574145
  575441
  575890
  576683
  576713
  577361
  579761
  582404
  584643
  585104
  587511
  590377
  591123
  591265
  593047
  593544
  593877
  594353
  595054
  596872
  599550
  600938
  602011
  602747
  603247
  603387
  604164
  606825
  610042
  612868
  620202
  622410
  636475
  644345
  664954
  666404
  666443
  667875
  668730
  699525
  749907
  775569
  809189
]
17.54 ms
(9.09%)
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
  699525
  14578
  749907
  478451
  522914
  498626
  501498
  526891
  478252
  545943
  576713
  562895
  575890
  561096
  550831
  590377
  593877
  594353
  596872
  602011
  602747
  603247
  612868
  478003
  524778
  557148
  477156
  517568
  575441
  664954
  591123
  595054
  600938
  593544
  593047
  599550
  557180
  549217
  591265
  390212
  476379
  507916
  535025
  569415
  668730
  636475
  486807
  503830
  644345
  606825
  555263
  570722
  576683
  582404
  610042
  440868
  476264
  463778
  461371
  465071
  474103
  467001
  477737
  505108
  512965
  520157
  520906
  521529
  529140
  532059
  536884
  523034
  525017
  519938
  526421
  529122
  544187
  557150
  558077
  568427
  579761
  565713
  577361
  546115
  556654
  563619
  570963
  573230
  574145
  584643
  667875
  666404
  666443
  549715
  558339
  562955
  603387
  604164
  622410
  587511
  620202
  809189
  775569
  585104
  478667
  481840
  483092
  470420
  490033
  494732
  506068
  509633
  529232
  500214
  516631
  533728
  533997
  536483
  540733
  504155
]
3.83 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
  14578
  390212
  440868
  461371
  463778
  465071
  467001
  470420
  474103
  476264
  476379
  477156
  477737
  478003
  478252
  478451
  478667
  481840
  483092
  486807
  490033
  494732
  498626
  500214
  501498
  503830
  504155
  505108
  506068
  507916
  509633
  512965
  516631
  517568
  519938
  520157
  520906
  521529
  522914
  523034
  524778
  525017
  526421
  526891
  529122
  529140
  529232
  532059
  533728
  533997
  535025
  536483
  536884
  540733
  544187
  545943
  546115
  549217
  549715
  550831
  555263
  556654
  557148
  557150
  557180
  558077
  558339
  561096
  562895
  562955
  563619
  565713
  568427
  569415
  570722
  570963
  573230
  574145
  575441
  575890
  576683
  576713
  577361
  579761
  582404
  584643
  585104
  587511
  590377
  591123
  591265
  593047
  593544
  593877
  594353
  595054
  596872
  599550
  600938
  602011
  602747
  603247
  603387
  604164
  606825
  610042
  612868
  620202
  622410
  636475
  644345
  664954
  666404
  666443
  667875
  668730
  699525
  749907
  775569
  809189
]
2.31 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сосет зрелая"
]
2.05 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сосет зрелая женщин"
]
1.45 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.