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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
270.27 ms
(39.16%)
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
  551995
  537671
  575140
  548666
  550763
  720480
  498212
  517012
  701498
  722821
  647964
  544676
  604508
  593850
  628364
  410930
  96048
  403162
  405054
  416820
  445679
  447247
  478779
  487742
  451963
  468046
  516319
  533011
  475848
  551936
  582012
  561815
  566383
  600256
  601559
  609682
  793376
  423267
  436040
  479523
  417897
  470791
  491911
  538190
  451263
  435624
  445728
  531239
  540408
  537196
  527900
  536787
  540053
  512215
  536292
  543609
  569687
  575455
  542591
  551184
  556421
  565390
  545719
  570073
  646920
  650333
  720237
  679821
  687262
  569672
  598699
  621650
  624223
  637047
  593359
  628114
  636274
  640773
  589345
  619410
  636273
  640806
  742143
  700294
  714500
  775819
  373852
  396358
  464703
  475911
  475975
  405093
  409995
  444720
  454736
  478781
  484716
  491915
  511744
  512261
  512265
  495612
  500764
  491369
  421327
  425489
  427467
  435664
  445626
  467583
  467561
  478457
  448097
  474766
  550613
  560616
  562037
  576416
  581738
  550432
]
207.81 ms
(30.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny mmf"
]
203.60 ms
(29.50%)
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
  96048
  373852
  396358
  403162
  405054
  405093
  409995
  410930
  416820
  417897
  421327
  423267
  425489
  427467
  435624
  435664
  436040
  444720
  445626
  445679
  445728
  447247
  448097
  451263
  451963
  454736
  464703
  467561
  467583
  468046
  470791
  474766
  475848
  475911
  475975
  478457
  478779
  478781
  479523
  484716
  487742
  491369
  491911
  491915
  495612
  498212
  500764
  511744
  512215
  512261
  512265
  516319
  517012
  527900
  531239
  533011
  536292
  536787
  537196
  537671
  538190
  540053
  540408
  542591
  543609
  544676
  545719
  548666
  550432
  550613
  550763
  551184
  551936
  551995
  556421
  560616
  561815
  562037
  565390
  566383
  569672
  569687
  570073
  575140
  575455
  576416
  581738
  582012
  589345
  593359
  593850
  598699
  600256
  601559
  604508
  609682
  619410
  621650
  624223
  628114
  628364
  636273
  636274
  637047
  640773
  640806
  646920
  647964
  650333
  679821
  687262
  700294
  701498
  714500
  720237
  720480
  722821
  742143
  775819
  793376
]
3.69 ms
(0.53%)
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
  96048
  373852
  396358
  403162
  405054
  405093
  409995
  410930
  416820
  417897
  421327
  423267
  425489
  427467
  435624
  435664
  436040
  444720
  445626
  445679
  445728
  447247
  448097
  451263
  451963
  454736
  464703
  467561
  467583
  468046
  470791
  474766
  475848
  475911
  475975
  478457
  478779
  478781
  479523
  484716
  487742
  491369
  491911
  491915
  495612
  498212
  500764
  511744
  512215
  512261
  512265
  516319
  517012
  527900
  531239
  533011
  536292
  536787
  537196
  537671
  538190
  540053
  540408
  542591
  543609
  544676
  545719
  548666
  550432
  550613
  550763
  551184
  551936
  551995
  556421
  560616
  561815
  562037
  565390
  566383
  569672
  569687
  570073
  575140
  575455
  576416
  581738
  582012
  589345
  593359
  593850
  598699
  600256
  601559
  604508
  609682
  619410
  621650
  624223
  628114
  628364
  636273
  636274
  637047
  640773
  640806
  646920
  647964
  650333
  679821
  687262
  700294
  701498
  714500
  720237
  720480
  722821
  742143
  775819
  793376
]
1.68 ms
(0.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые мжм секс втро"
]
1.64 ms
(0.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.21%)
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.