GET https://search.jues.net/search/embeds/3?q=%D0%B4%D0%BE%D0%B9%D0%BA%D0%B8%20%D0%BF%D0%BE%D1%80%D0%BD%D0%BE

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.36 ms
(88.28%)
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
  387173
  387925
  391528
  398749
  401382
  419649
  443561
  445785
  460167
  466763
  467978
  470055
  474868
  476305
  480232
  491862
  492417
  492421
  498759
  499874
  502207
  502835
  506310
  507751
  511286
  515012
  517693
  518544
  518601
  518784
  520401
  520742
  523037
  524482
  524485
  525666
  528255
  528871
  528885
  530127
  532295
  532392
  534162
  534373
  536565
  537044
  537871
  541411
  547027
  548473
  551522
  552094
  553440
  556576
  556813
  558165
  561496
  562506
  563965
  564759
  566559
  566669
  567121
  568127
  568337
  569246
  569392
  574722
  577395
  577946
  578432
  579992
  580532
  580837
  580872
  580915
  580920
  582435
  582465
  584038
  587209
  592510
  592930
  601746
  604921
  604941
  605134
  607177
  610185
  618632
  619628
  626651
  630013
  633021
  636456
  646166
  648766
  658991
  670226
  710491
  712120
  714161
  715268
  715428
  715478
  723082
  728649
  740153
  741547
  745298
  747975
  748605
  757539
  796262
  796438
  796439
  798846
  805615
  808058
  812950
]
15.42 ms
(6.66%)
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
  587209
  604941
  626651
  798846
  580532
  523037
  670226
  419649
  443561
  470055
  445785
  492421
  507751
  525666
  511286
  499874
  520742
  528255
  537871
  502207
  551522
  562506
  566559
  580837
  582435
  558165
  566669
  541411
  568127
  574722
  577946
  601746
  604921
  592510
  610185
  618632
  605134
  757539
  745298
  548473
  564759
  567121
  569392
  563965
  648766
  715428
  714161
  712120
  619628
  630013
  636456
  805615
  796262
  808058
  728649
  740153
  796438
  796439
  747975
  748605
  607177
  710491
  723082
  812950
  387925
  391528
  387173
  398749
  401382
  532392
  528885
  532295
  466763
  474868
  476305
  561496
  568337
  646166
  658991
  715268
  715478
  577395
  633021
  741547
  592930
  491862
  467978
  480232
  492417
  506310
  515012
  517693
  528871
  534162
  534373
  518601
  518784
  537044
  502835
  530127
  498759
  518544
  520401
  524482
  524485
  536565
  460167
  552094
  579992
  580915
  584038
  547027
  556813
  569246
  578432
  580872
  580920
  582465
  553440
  556576
]
3.77 ms
(1.63%)
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
  387173
  387925
  391528
  398749
  401382
  419649
  443561
  445785
  460167
  466763
  467978
  470055
  474868
  476305
  480232
  491862
  492417
  492421
  498759
  499874
  502207
  502835
  506310
  507751
  511286
  515012
  517693
  518544
  518601
  518784
  520401
  520742
  523037
  524482
  524485
  525666
  528255
  528871
  528885
  530127
  532295
  532392
  534162
  534373
  536565
  537044
  537871
  541411
  547027
  548473
  551522
  552094
  553440
  556576
  556813
  558165
  561496
  562506
  563965
  564759
  566559
  566669
  567121
  568127
  568337
  569246
  569392
  574722
  577395
  577946
  578432
  579992
  580532
  580837
  580872
  580915
  580920
  582435
  582465
  584038
  587209
  592510
  592930
  601746
  604921
  604941
  605134
  607177
  610185
  618632
  619628
  626651
  630013
  633021
  636456
  646166
  648766
  658991
  670226
  710491
  712120
  714161
  715268
  715428
  715478
  723082
  728649
  740153
  741547
  745298
  747975
  748605
  757539
  796262
  796438
  796439
  798846
  805615
  808058
  812950
]
2.27 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ порн"
]
1.91 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дойки порно"
]
1.86 ms
(0.81%)
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.