GET https://search.jues.net/search/embeds/10?q=spandex%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
274.43 ms
(56.45%)
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
  428754
  233459
  400298
  418565
  823557
  528056
  533533
  504687
  660694
  720495
  777404
  799817
  725009
  782423
  803098
  727981
  710498
  796689
  444617
  467995
  439731
  439764
  398433
  591990
  526989
  736519
  421742
  425538
  438410
  426522
  433898
  416870
  423313
  453376
  447818
  450793
  491105
  452216
  454720
  477568
  540618
  496075
  507693
  463540
  569241
  582503
  542065
  551491
  562472
  564967
  647461
  556052
  592597
  424032
  447507
  464833
  478362
  427318
  428090
  460359
  423941
  429555
  449245
  473061
  427738
  478643
  481267
  457204
  466368
  501957
  516489
  520114
  489621
  500033
  486610
  514423
  515481
  522313
  528303
  518004
  168977
  442645
  442101
  416795
  424753
  443180
  825481
  458657
  466707
  452929
  457995
  463537
  490475
  495623
  527801
  498966
  499012
  463536
  472160
  480359
  493045
  549511
  552700
  546754
  552507
  565015
  576505
  653504
  653513
  604082
  587731
  624002
  779122
  444755
  472176
  415837
  426671
  415822
  439300
  499961
]
200.26 ms
(41.20%)
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
  168977
  233459
  398433
  400298
  415822
  415837
  416795
  416870
  418565
  421742
  423313
  423941
  424032
  424753
  425538
  426522
  426671
  427318
  427738
  428090
  428754
  429555
  433898
  438410
  439300
  439731
  439764
  442101
  442645
  443180
  444617
  444755
  447507
  447818
  449245
  450793
  452216
  452929
  453376
  454720
  457204
  457995
  458657
  460359
  463536
  463537
  463540
  464833
  466368
  466707
  467995
  472160
  472176
  473061
  477568
  478362
  478643
  480359
  481267
  486610
  489621
  490475
  491105
  493045
  495623
  496075
  498966
  499012
  499961
  500033
  501957
  504687
  507693
  514423
  515481
  516489
  518004
  520114
  522313
  526989
  527801
  528056
  528303
  533533
  542065
  546754
  549511
  551491
  552507
  552700
  556052
  562472
  564967
  565015
  569241
  576505
  582503
  587731
  591990
  592597
  604082
  624002
  647461
  653504
  653513
  660694
  710498
  720495
  725009
  727981
  736519
  777404
  779122
  782423
  796689
  799817
  803098
  823557
  825481
]
3.23 ms
(0.67%)
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
  168977
  233459
  398433
  400298
  415822
  415837
  416795
  416870
  418565
  421742
  423313
  423941
  424032
  424753
  425538
  426522
  426671
  427318
  427738
  428090
  428754
  429555
  433898
  438410
  439300
  439731
  439764
  442101
  442645
  443180
  444617
  444755
  447507
  447818
  449245
  450793
  452216
  452929
  453376
  454720
  457204
  457995
  458657
  460359
  463536
  463537
  463540
  464833
  466368
  466707
  467995
  472160
  472176
  473061
  477568
  478362
  478643
  480359
  481267
  486610
  489621
  490475
  491105
  493045
  495623
  496075
  498966
  499012
  499961
  500033
  501957
  504687
  507693
  514423
  515481
  516489
  518004
  520114
  522313
  526989
  527801
  528056
  528303
  533533
  542065
  546754
  549511
  551491
  552507
  552700
  556052
  562472
  564967
  565015
  569241
  576505
  582503
  587731
  591990
  592597
  604082
  624002
  647461
  653504
  653513
  660694
  710498
  720495
  725009
  727981
  736519
  777404
  779122
  782423
  796689
  799817
  803098
  823557
  825481
]
2.26 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лосин жоп"
]
2.06 ms
(0.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.03 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "spandex ass"
]
1.83 ms
(0.38%)
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.