GET https://search.jues.net/search/embeds/2?q=couple%20sex%20teen

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.57 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.71 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "couple sex teen"
]
3 15.20 ms
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
  510419
  659956
  605401
  604859
  619203
  392465
  496555
  552189
  681343
  767011
  819193
  393284
  822205
  674127
  663882
  723980
  649266
  753423
  590989
  454732
  707233
  717853
  662022
  743197
  754260
  490176
  393833
  813884
  537767
  552184
  660340
  715438
  800975
  776194
  713392
  400096
  427246
  538081
  723264
  750070
  510068
  669737
  654078
  769039
  529159
  552211
  718689
  451540
  410062
  426361
  466193
  426357
  454726
  418027
  507837
  594365
  701051
  769733
  643007
  437635
  552213
  664287
  748151
  707609
  781621
  560625
  665475
  722070
  566889
  598772
  597601
  398994
  466220
  496049
  652526
  546592
  758465
  729894
  749462
  426001
  510496
  510645
  508082
  616046
  470491
  461451
  521890
  487090
  598623
  483220
  418685
  443483
  480737
  575286
  594451
  769746
  385734
  510635
  510647
  510500
  482601
  463636
  657200
  791809
  455456
  463012
  458544
  405000
  510631
  442463
  442039
  426352
  458454
  459201
  552181
  508188
  732930
  682478
  791321
  395879
]
4 2.32 ms
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
  385734
  392465
  393284
  393833
  395879
  398994
  400096
  405000
  410062
  418027
  418685
  426001
  426352
  426357
  426361
  427246
  437635
  442039
  442463
  443483
  451540
  454726
  454732
  455456
  458454
  458544
  459201
  461451
  463012
  463636
  466193
  466220
  470491
  480737
  482601
  483220
  487090
  490176
  496049
  496555
  507837
  508082
  508188
  510068
  510419
  510496
  510500
  510631
  510635
  510645
  510647
  521890
  529159
  537767
  538081
  546592
  552181
  552184
  552189
  552211
  552213
  560625
  566889
  575286
  590989
  594365
  594451
  597601
  598623
  598772
  604859
  605401
  616046
  619203
  643007
  649266
  652526
  654078
  657200
  659956
  660340
  662022
  663882
  664287
  665475
  669737
  674127
  681343
  682478
  701051
  707233
  707609
  713392
  715438
  717853
  718689
  722070
  723264
  723980
  729894
  732930
  743197
  748151
  749462
  750070
  753423
  754260
  758465
  767011
  769039
  769733
  769746
  776194
  781621
  791321
  791809
  800975
  813884
  819193
  822205
]
5 148.65 ms
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
  385734
  392465
  393284
  393833
  395879
  398994
  400096
  405000
  410062
  418027
  418685
  426001
  426352
  426357
  426361
  427246
  437635
  442039
  442463
  443483
  451540
  454726
  454732
  455456
  458454
  458544
  459201
  461451
  463012
  463636
  466193
  466220
  470491
  480737
  482601
  483220
  487090
  490176
  496049
  496555
  507837
  508082
  508188
  510068
  510419
  510496
  510500
  510631
  510635
  510645
  510647
  521890
  529159
  537767
  538081
  546592
  552181
  552184
  552189
  552211
  552213
  560625
  566889
  575286
  590989
  594365
  594451
  597601
  598623
  598772
  604859
  605401
  616046
  619203
  643007
  649266
  652526
  654078
  657200
  659956
  660340
  662022
  663882
  664287
  665475
  669737
  674127
  681343
  682478
  701051
  707233
  707609
  713392
  715438
  717853
  718689
  722070
  723264
  723980
  729894
  732930
  743197
  748151
  749462
  750070
  753423
  754260
  758465
  767011
  769039
  769733
  769746
  776194
  781621
  791321
  791809
  800975
  813884
  819193
  822205
]
6 1.59 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "couple секс teen"
]
7 1.38 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "couple секс teen"
]

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.