GET https://search.jues.net/search/embeds/7?q=teen%20first%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.70 ms
(85.48%)
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
  388434
  395661
  395751
  395756
  399170
  404753
  409615
  410267
  418846
  423464
  423620
  427437
  435022
  439138
  441402
  443555
  445334
  445411
  446099
  447719
  452648
  454101
  457818
  457882
  457893
  459111
  461155
  461704
  461716
  463921
  465790
  477004
  479756
  483814
  490174
  491573
  497371
  497697
  506073
  508962
  511955
  516615
  520777
  523357
  524070
  528282
  529092
  530488
  532940
  533018
  533522
  533576
  534032
  536579
  537206
  540273
  550294
  555571
  555851
  560608
  564039
  565249
  566736
  567335
  568113
  568122
  568123
  568643
  571210
  576114
  576388
  581518
  583592
  588014
  589196
  591259
  593167
  593766
  597260
  597269
  597275
  597907
  627810
  630902
  632626
  632638
  632969
  636987
  637039
  637105
  637141
  637431
  637432
  639787
  640777
  641623
  642691
  647891
  648924
  648937
  649576
  650379
  651620
  657128
  670250
  677364
  680120
  680202
  680203
  696995
  700996
  718675
  733106
  750527
  758226
  759344
  771918
  811944
  814210
  814460
]
16.01 ms
(8.85%)
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
  418846
  457882
  457893
  497697
  550294
  597260
  388434
  477004
  479756
  445411
  447719
  409615
  520777
  483814
  491573
  555571
  632638
  588014
  591259
  636987
  395661
  439138
  423620
  441402
  511955
  404753
  452648
  454101
  465790
  534032
  555851
  564039
  567335
  568122
  657128
  677364
  593766
  593167
  423464
  395756
  435022
  506073
  497371
  524070
  395751
  528282
  461155
  566736
  680203
  642691
  637141
  814210
  446099
  532940
  568113
  648937
  680202
  680120
  597269
  597275
  627810
  589196
  630902
  632626
  811944
  733106
  461716
  410267
  536579
  537206
  565249
  516615
  445334
  814460
  457818
  533018
  523357
  530488
  533576
  540273
  508962
  529092
  533522
  490174
  576388
  581518
  576114
  560608
  571210
  648924
  670250
  700996
  647891
  650379
  696995
  649576
  651620
  568123
  568643
  583592
  597907
  637105
  637431
  637432
  641623
  639787
  637039
  640777
  750527
  759344
  758226
  771918
  632969
  718675
  427437
  461704
  459111
  463921
  399170
  443555
]
3.26 ms
(1.80%)
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
  388434
  395661
  395751
  395756
  399170
  404753
  409615
  410267
  418846
  423464
  423620
  427437
  435022
  439138
  441402
  443555
  445334
  445411
  446099
  447719
  452648
  454101
  457818
  457882
  457893
  459111
  461155
  461704
  461716
  463921
  465790
  477004
  479756
  483814
  490174
  491573
  497371
  497697
  506073
  508962
  511955
  516615
  520777
  523357
  524070
  528282
  529092
  530488
  532940
  533018
  533522
  533576
  534032
  536579
  537206
  540273
  550294
  555571
  555851
  560608
  564039
  565249
  566736
  567335
  568113
  568122
  568123
  568643
  571210
  576114
  576388
  581518
  583592
  588014
  589196
  591259
  593167
  593766
  597260
  597269
  597275
  597907
  627810
  630902
  632626
  632638
  632969
  636987
  637039
  637105
  637141
  637431
  637432
  639787
  640777
  641623
  642691
  647891
  648924
  648937
  649576
  650379
  651620
  657128
  670250
  677364
  680120
  680202
  680203
  696995
  700996
  718675
  733106
  750527
  758226
  759344
  771918
  811944
  814210
  814460
]
2.04 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen first anal"
]
1.90 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen first анал"
]
1.40 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen first анал"
]

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.