GET https://search.jues.net/search/embeds/10?q=skinny%20mmf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
233.80 ms
(88.30%)
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
  390001
  391715
  393590
  406299
  408601
  413818
  413950
  414184
  414357
  416365
  418873
  421323
  423645
  424470
  424523
  428703
  431446
  431730
  432823
  445896
  445971
  446105
  447124
  451588
  462515
  463864
  465509
  468622
  469911
  469918
  469924
  471792
  473735
  476248
  478787
  484609
  485507
  486589
  487713
  491394
  491905
  496792
  497560
  498102
  498194
  500596
  502249
  504268
  505134
  507312
  508839
  512561
  513768
  515193
  516449
  516635
  519261
  520215
  522361
  535028
  540912
  541605
  543817
  543919
  544833
  548258
  548609
  550669
  550670
  550764
  550781
  551991
  552030
  552703
  553494
  554743
  558129
  558447
  559918
  560445
  561103
  561412
  565355
  565371
  565373
  566439
  566502
  567067
  568309
  570074
  574566
  574823
  576082
  576412
  577699
  580256
  582227
  583724
  590429
  593835
  596192
  598386
  599963
  600330
  603628
  605355
  605650
  607237
  617408
  619409
  628365
  632001
  635234
  646937
  648836
  661253
  675034
  678967
  714109
  722689
]
19.72 ms
(7.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
  583724
  552030
  558129
  565373
  574823
  678967
  714109
  544833
  561103
  590429
  599963
  603628
  390001
  414184
  476248
  424470
  432823
  447124
  469911
  478787
  413818
  516635
  484609
  491394
  500596
  508839
  513768
  516449
  498194
  540912
  445896
  485507
  491905
  498102
  505134
  550764
  568309
  565371
  550781
  646937
  722689
  648836
  553494
  559918
  565355
  605355
  607237
  617408
  619409
  635234
  497560
  520215
  522361
  504268
  486589
  515193
  552703
  661253
  391715
  550669
  550670
  431446
  421323
  543919
  580256
  445971
  570074
  451588
  598386
  414357
  507312
  632001
  473735
  428703
  446105
  566502
  577699
  487713
  576412
  512561
  431730
  582227
  566439
  558447
  469918
  519261
  496792
  408601
  413950
  423645
  502249
  468622
  567067
  574566
  576082
  548609
  593835
  600330
  605650
  406299
  462515
  465509
  424523
  469924
  471792
  393590
  416365
  418873
  463864
  535028
  548258
  560445
  541605
  543817
  561412
  675034
  551991
  554743
  596192
  628365
]
3.50 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые мжм секс втро"
]
2.42 ms
(0.91%)
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
  390001
  391715
  393590
  406299
  408601
  413818
  413950
  414184
  414357
  416365
  418873
  421323
  423645
  424470
  424523
  428703
  431446
  431730
  432823
  445896
  445971
  446105
  447124
  451588
  462515
  463864
  465509
  468622
  469911
  469918
  469924
  471792
  473735
  476248
  478787
  484609
  485507
  486589
  487713
  491394
  491905
  496792
  497560
  498102
  498194
  500596
  502249
  504268
  505134
  507312
  508839
  512561
  513768
  515193
  516449
  516635
  519261
  520215
  522361
  535028
  540912
  541605
  543817
  543919
  544833
  548258
  548609
  550669
  550670
  550764
  550781
  551991
  552030
  552703
  553494
  554743
  558129
  558447
  559918
  560445
  561103
  561412
  565355
  565371
  565373
  566439
  566502
  567067
  568309
  570074
  574566
  574823
  576082
  576412
  577699
  580256
  582227
  583724
  590429
  593835
  596192
  598386
  599963
  600330
  603628
  605355
  605650
  607237
  617408
  619409
  628365
  632001
  635234
  646937
  648836
  661253
  675034
  678967
  714109
  722689
]
2.14 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny mmf"
]
1.80 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.53%)
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.