GET https://search.jues.net/search/embeds/7?q=dildo%20oil

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.58 ms
(81.98%)
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
  383112
  409035
  410702
  412814
  415957
  416009
  416523
  416539
  416607
  416611
  416682
  416708
  416712
  420864
  421856
  423787
  424606
  425452
  427745
  434346
  435407
  435529
  439130
  441050
  445968
  448063
  448108
  448351
  448604
  452800
  452809
  454004
  458203
  463435
  464951
  465454
  466427
  468943
  469194
  470479
  471989
  473213
  475425
  477761
  479204
  483730
  483736
  493688
  500263
  500342
  502789
  511413
  518884
  519350
  525431
  526167
  526291
  529296
  529632
  537138
  561036
  562536
  575941
  576590
  577340
  583694
  586995
  588514
  589229
  597190
  601095
  602109
  625780
  658819
  660411
  660412
  660419
  669056
  669071
  671018
  680252
  695868
  709674
  709786
  712153
  713501
  716001
  716241
  738515
  739125
  739145
  739156
  739821
  742421
  751044
  756776
  758101
  760538
  763739
  770262
  770849
  774703
  774850
  777642
  779720
  782847
  783008
  791538
  793280
  794041
  796640
  802071
  803509
  806812
  806822
  807166
  807590
  808265
  808968
  810776
]
16.68 ms
(10.98%)
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
  448108
  511413
  529296
  529632
  562536
  576590
  601095
  808968
  810776
  751044
  758101
  738515
  739821
  774850
  777642
  793280
  807166
  712153
  577340
  526167
  525431
  415957
  409035
  412814
  416611
  424606
  416607
  416682
  470479
  448351
  483736
  561036
  669071
  695868
  709674
  660412
  660419
  669056
  660411
  671018
  597190
  796640
  807590
  808265
  739125
  739145
  763739
  416708
  423787
  434346
  468943
  416523
  441050
  518884
  427745
  410702
  420864
  493688
  452809
  465454
  473213
  475425
  502789
  500263
  537138
  464951
  583694
  709786
  588514
  586995
  463435
  435529
  448604
  458203
  791538
  416712
  452800
  483730
  477761
  383112
  466427
  716001
  680252
  713501
  575941
  589229
  774703
  803509
  794041
  760538
  770262
  770849
  739156
  756776
  742421
  602109
  716241
  779720
  783008
  802071
  806822
  806812
  625780
  416539
  425452
  448063
  421856
  479204
  416009
  500342
  782847
  469194
  435407
  454004
  471989
  439130
  526291
  519350
  445968
  658819
]
3.09 ms
(2.04%)
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
  383112
  409035
  410702
  412814
  415957
  416009
  416523
  416539
  416607
  416611
  416682
  416708
  416712
  420864
  421856
  423787
  424606
  425452
  427745
  434346
  435407
  435529
  439130
  441050
  445968
  448063
  448108
  448351
  448604
  452800
  452809
  454004
  458203
  463435
  464951
  465454
  466427
  468943
  469194
  470479
  471989
  473213
  475425
  477761
  479204
  483730
  483736
  493688
  500263
  500342
  502789
  511413
  518884
  519350
  525431
  526167
  526291
  529296
  529632
  537138
  561036
  562536
  575941
  576590
  577340
  583694
  586995
  588514
  589229
  597190
  601095
  602109
  625780
  658819
  660411
  660412
  660419
  669056
  669071
  671018
  680252
  695868
  709674
  709786
  712153
  713501
  716001
  716241
  738515
  739125
  739145
  739156
  739821
  742421
  751044
  756776
  758101
  760538
  763739
  770262
  770849
  774703
  774850
  777642
  779720
  782847
  783008
  791538
  793280
  794041
  796640
  802071
  803509
  806812
  806822
  807166
  807590
  808265
  808968
  810776
]
2.19 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo oil"
]
1.95 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд масл"
]
1.95 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.00%)
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.