GET https://search.jues.net/search/embeds/7?q=homemade%20passionate

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
187.94 ms
(85.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
  417656
  421206
  423881
  434276
  438364
  439906
  443060
  444859
  444977
  446455
  448260
  448354
  448440
  451466
  452493
  452657
  454141
  454556
  455599
  455844
  456090
  458474
  458662
  459483
  459532
  459961
  460580
  460784
  463083
  467065
  467696
  467993
  469749
  471484
  475189
  478123
  478129
  478337
  479633
  480317
  481939
  481995
  483867
  485576
  485641
  485939
  487572
  488928
  490968
  492088
  492335
  492336
  493951
  494672
  495352
  498174
  499035
  500513
  502239
  502662
  503116
  507010
  507667
  511401
  512375
  512410
  513393
  513404
  515855
  517320
  517330
  518172
  519864
  520482
  521244
  521474
  523329
  523517
  523636
  524477
  525282
  525509
  526523
  526714
  539294
  540617
  546730
  554580
  555127
  555140
  556552
  558581
  559998
  568536
  569256
  569836
  574727
  577926
  580141
  582687
  586493
  587888
  590633
  593991
  598919
  598999
  600411
  602742
  605442
  609540
  622405
  624137
  674495
  682421
  684694
  717182
  721129
  746525
  759946
  797462
]
20.62 ms
(9.41%)
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
  674495
  721129
  546730
  587888
  458662
  455844
  460784
  521244
  490968
  492335
  523517
  525282
  511401
  526714
  417656
  463083
  540617
  471484
  485939
  577926
  568536
  580141
  554580
  582687
  556552
  559998
  586493
  797462
  759946
  475189
  438364
  458474
  467065
  467696
  478123
  481995
  480317
  481939
  478129
  485641
  513404
  515855
  519864
  521474
  507010
  483867
  684694
  520482
  459483
  452657
  746525
  451466
  593991
  494672
  558581
  598919
  602742
  624137
  439906
  444859
  452493
  503116
  448440
  499035
  555127
  555140
  569836
  609540
  605442
  622405
  459961
  423881
  459532
  455599
  517330
  526523
  492088
  518172
  488928
  444977
  523329
  495352
  569256
  574727
  598999
  443060
  454556
  469749
  446455
  460580
  502662
  512375
  512410
  524477
  493951
  502239
  513393
  525509
  487572
  500513
  507667
  517320
  523636
  492336
  479633
  478337
  539294
  467993
  600411
  448354
  498174
  717182
  434276
  454141
  456090
  485576
  421206
  682421
  590633
  448260
]
3.55 ms
(1.62%)
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
  417656
  421206
  423881
  434276
  438364
  439906
  443060
  444859
  444977
  446455
  448260
  448354
  448440
  451466
  452493
  452657
  454141
  454556
  455599
  455844
  456090
  458474
  458662
  459483
  459532
  459961
  460580
  460784
  463083
  467065
  467696
  467993
  469749
  471484
  475189
  478123
  478129
  478337
  479633
  480317
  481939
  481995
  483867
  485576
  485641
  485939
  487572
  488928
  490968
  492088
  492335
  492336
  493951
  494672
  495352
  498174
  499035
  500513
  502239
  502662
  503116
  507010
  507667
  511401
  512375
  512410
  513393
  513404
  515855
  517320
  517330
  518172
  519864
  520482
  521244
  521474
  523329
  523517
  523636
  524477
  525282
  525509
  526523
  526714
  539294
  540617
  546730
  554580
  555127
  555140
  556552
  558581
  559998
  568536
  569256
  569836
  574727
  577926
  580141
  582687
  586493
  587888
  590633
  593991
  598919
  598999
  600411
  602742
  605442
  609540
  622405
  624137
  674495
  682421
  684694
  717182
  721129
  746525
  759946
  797462
]
2.02 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade passionate"
]
1.74 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск passionate"
]
1.68 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск passionate"
]

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.