GET https://search.jues.net/search/embeds/4?q=sex%20with%20college

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
202.83 ms
(88.68%)
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
  12411
  94669
  226028
  387871
  388464
  389506
  392508
  396079
  398269
  399924
  417879
  470014
  485156
  506843
  510739
  521366
  523303
  530553
  541547
  549626
  550283
  552049
  563961
  565104
  569267
  570688
  576774
  580493
  585168
  590278
  592892
  593281
  594894
  601629
  603567
  603572
  608729
  616592
  617496
  617859
  619365
  619585
  625646
  626307
  631793
  637970
  648099
  649715
  650602
  650852
  652424
  667983
  671357
  674938
  678304
  690528
  697325
  703697
  703710
  705102
  712481
  714956
  715235
  715409
  720061
  721889
  722055
  724080
  724656
  725748
  727773
  730402
  732953
  734797
  736117
  736826
  736962
  738684
  739106
  741494
  743100
  744845
  750084
  754366
  755766
  761663
  762483
  764438
  765950
  766568
  768846
  773388
  777979
  778294
  778450
  779216
  780502
  782387
  785171
  785230
  785728
  788726
  790245
  791413
  796093
  797620
  799096
  799172
  801602
  804967
  806843
  810098
  810624
  811043
  814068
  815291
  815323
  821484
  822741
  824864
]
15.48 ms
(6.77%)
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
  722055
  523303
  565104
  550283
  697325
  720061
  671357
  569267
  626307
  608729
  732953
  762483
  736962
  750084
  797620
  799172
  392508
  485156
  530553
  563961
  703710
  652424
  690528
  617496
  778450
  785171
  788726
  799096
  736117
  761663
  755766
  736826
  764438
  637970
  804967
  549626
  715409
  590278
  593281
  785230
  724656
  739106
  724080
  725748
  806843
  470014
  388464
  815291
  822741
  576774
  648099
  667983
  703697
  705102
  585168
  625646
  631793
  594894
  617859
  603567
  785728
  779216
  730402
  744845
  754366
  765950
  773388
  738684
  782387
  810098
  399924
  226028
  506843
  650852
  766568
  417879
  821484
  619585
  603572
  94669
  398269
  824864
  541547
  712481
  801602
  743100
  387871
  396079
  815323
  570688
  552049
  714956
  592892
  768846
  796093
  734797
  780502
  790245
  791413
  810624
  389506
  814068
  649715
  721889
  715235
  616592
  777979
  778294
  811043
  727773
  741494
  601629
  619365
  12411
  521366
  510739
  580493
  650602
  674938
  678304
]
2.58 ms
(1.13%)
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
  12411
  94669
  226028
  387871
  388464
  389506
  392508
  396079
  398269
  399924
  417879
  470014
  485156
  506843
  510739
  521366
  523303
  530553
  541547
  549626
  550283
  552049
  563961
  565104
  569267
  570688
  576774
  580493
  585168
  590278
  592892
  593281
  594894
  601629
  603567
  603572
  608729
  616592
  617496
  617859
  619365
  619585
  625646
  626307
  631793
  637970
  648099
  649715
  650602
  650852
  652424
  667983
  671357
  674938
  678304
  690528
  697325
  703697
  703710
  705102
  712481
  714956
  715235
  715409
  720061
  721889
  722055
  724080
  724656
  725748
  727773
  730402
  732953
  734797
  736117
  736826
  736962
  738684
  739106
  741494
  743100
  744845
  750084
  754366
  755766
  761663
  762483
  764438
  765950
  766568
  768846
  773388
  777979
  778294
  778450
  779216
  780502
  782387
  785171
  785230
  785728
  788726
  790245
  791413
  796093
  797620
  799096
  799172
  801602
  804967
  806843
  810098
  810624
  811043
  814068
  815291
  815323
  821484
  822741
  824864
]
2.28 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс college"
]
1.98 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex with college"
]
1.84 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс college"
]
1.73 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.