GET https://search.jues.net/search/embeds/9?q=casting%20anal%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.04 ms
(85.34%)
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
  3575
  381830
  384382
  411884
  426196
  428571
  429764
  447115
  447569
  448828
  461011
  463913
  468524
  468671
  468706
  469302
  472248
  472703
  473183
  477109
  477754
  479816
  480062
  487189
  487721
  488746
  497368
  509920
  515476
  519440
  519553
  521587
  522951
  526891
  528282
  529828
  530769
  533724
  536230
  536632
  537882
  537927
  540422
  545197
  545475
  548262
  554287
  569217
  582362
  590506
  591747
  596350
  597987
  600182
  601922
  604562
  609866
  609888
  609900
  612247
  619652
  619808
  620922
  623165
  631168
  632082
  642697
  646014
  649511
  653559
  659448
  668523
  668537
  674049
  674688
  699588
  700993
  701771
  703100
  703970
  704916
  705180
  710903
  713927
  716557
  718690
  718945
  720621
  720673
  720749
  721419
  722231
  722353
  722592
  722594
  722596
  723461
  724170
  724179
  724285
  725148
  727289
  728226
  733873
  733885
  733896
  733904
  733905
  736101
  741518
  741537
  747439
  747459
  752105
  754147
  758986
  759996
  761347
  805721
  817242
]
19.90 ms
(9.54%)
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
  761347
  381830
  472703
  447115
  447569
  468706
  536632
  537882
  519440
  522951
  533724
  537927
  545197
  646014
  545475
  582362
  596350
  623165
  609888
  631168
  632082
  733885
  724179
  747439
  747459
  733905
  759996
  736101
  741537
  642697
  722353
  469302
  461011
  477109
  477754
  515476
  384382
  705180
  716557
  718945
  720621
  612247
  754147
  752105
  704916
  3575
  554287
  468671
  472248
  653559
  429764
  448828
  609866
  817242
  530769
  536230
  569217
  703100
  674049
  609900
  619652
  727289
  733873
  710903
  720673
  700993
  668537
  528282
  497368
  519553
  487721
  548262
  428571
  473183
  733896
  604562
  701771
  540422
  733904
  480062
  468524
  509920
  487189
  411884
  463913
  699588
  526891
  479816
  601922
  488746
  529828
  521587
  426196
  649511
  674688
  703970
  722594
  723461
  659448
  713927
  720749
  722592
  668523
  718690
  721419
  722231
  722596
  597987
  619808
  600182
  620922
  590506
  591747
  805721
  724285
  725148
  758986
  728226
  741518
  724170
]
4.28 ms
(2.05%)
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
  3575
  381830
  384382
  411884
  426196
  428571
  429764
  447115
  447569
  448828
  461011
  463913
  468524
  468671
  468706
  469302
  472248
  472703
  473183
  477109
  477754
  479816
  480062
  487189
  487721
  488746
  497368
  509920
  515476
  519440
  519553
  521587
  522951
  526891
  528282
  529828
  530769
  533724
  536230
  536632
  537882
  537927
  540422
  545197
  545475
  548262
  554287
  569217
  582362
  590506
  591747
  596350
  597987
  600182
  601922
  604562
  609866
  609888
  609900
  612247
  619652
  619808
  620922
  623165
  631168
  632082
  642697
  646014
  649511
  653559
  659448
  668523
  668537
  674049
  674688
  699588
  700993
  701771
  703100
  703970
  704916
  705180
  710903
  713927
  716557
  718690
  718945
  720621
  720673
  720749
  721419
  722231
  722353
  722592
  722594
  722596
  723461
  724170
  724179
  724285
  725148
  727289
  728226
  733873
  733885
  733896
  733904
  733905
  736101
  741518
  741537
  747439
  747459
  752105
  754147
  758986
  759996
  761347
  805721
  817242
]
2.01 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting anal big"
]
1.62 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг анал большие"
]
1.34 ms
(0.64%)
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.