GET https://search.jues.net/search/embeds/2?q=sexy%20russian%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.04 ms
(85.61%)
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
  181009
  246506
  391669
  400492
  400509
  400515
  423988
  424254
  436868
  443669
  443997
  448508
  451470
  453505
  454544
  455406
  462193
  462952
  466405
  468088
  468862
  469161
  469173
  472392
  475097
  475819
  477137
  477619
  477794
  483055
  484947
  485367
  488887
  492640
  493042
  493909
  502852
  504175
  506757
  509614
  509650
  510828
  511835
  518600
  518822
  522270
  522956
  528028
  538603
  542938
  544953
  546934
  547274
  547577
  552334
  552338
  553684
  556471
  558610
  561377
  563135
  570954
  572765
  579213
  579542
  584479
  588735
  588862
  590538
  600838
  619903
  625233
  655515
  657804
  659360
  671896
  672821
  672843
  688967
  697513
  705471
  714320
  714443
  714459
  714487
  718876
  725476
  731005
  736382
  741044
  741201
  741700
  741750
  741854
  745834
  746028
  749929
  751613
  758158
  761247
  763729
  763744
  764215
  765868
  777172
  781656
  781713
  782190
  786384
  790180
  790648
  792932
  795702
  798743
  799859
  805129
  808562
  810458
  825560
  825771
]
14.16 ms
(8.66%)
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
  475097
  400492
  455406
  792932
  558610
  714443
  547577
  798743
  714459
  777172
  469173
  655515
  400515
  436868
  492640
  483055
  423988
  477137
  584479
  451470
  475819
  504175
  510828
  528028
  825560
  825771
  553684
  542938
  671896
  705471
  795702
  810458
  741044
  741854
  745834
  782190
  790180
  746028
  741201
  472392
  511835
  488887
  546934
  552338
  579213
  552334
  588735
  477794
  468862
  462952
  443669
  454544
  443997
  509614
  518600
  502852
  484947
  485367
  522270
  522956
  506757
  544953
  672843
  714320
  659360
  563135
  588862
  590538
  781713
  808562
  741750
  749929
  751613
  790648
  799859
  736382
  741700
  731005
  763729
  765868
  697513
  400509
  462193
  570954
  714487
  453505
  477619
  466405
  572765
  556471
  469161
  391669
  518822
  181009
  538603
  468088
  561377
  547274
  672821
  657804
  688967
  579542
  600838
  625233
  781656
  805129
  758158
  763744
  725476
  761247
  764215
  619903
  718876
  786384
  448508
  246506
  509650
  493042
  493909
  424254
]
3.22 ms
(1.97%)
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
  181009
  246506
  391669
  400492
  400509
  400515
  423988
  424254
  436868
  443669
  443997
  448508
  451470
  453505
  454544
  455406
  462193
  462952
  466405
  468088
  468862
  469161
  469173
  472392
  475097
  475819
  477137
  477619
  477794
  483055
  484947
  485367
  488887
  492640
  493042
  493909
  502852
  504175
  506757
  509614
  509650
  510828
  511835
  518600
  518822
  522270
  522956
  528028
  538603
  542938
  544953
  546934
  547274
  547577
  552334
  552338
  553684
  556471
  558610
  561377
  563135
  570954
  572765
  579213
  579542
  584479
  588735
  588862
  590538
  600838
  619903
  625233
  655515
  657804
  659360
  671896
  672821
  672843
  688967
  697513
  705471
  714320
  714443
  714459
  714487
  718876
  725476
  731005
  736382
  741044
  741201
  741700
  741750
  741854
  745834
  746028
  749929
  751613
  758158
  761247
  763729
  763744
  764215
  765868
  777172
  781656
  781713
  782190
  786384
  790180
  790648
  792932
  795702
  798743
  799859
  805129
  808562
  810458
  825560
  825771
]
1.76 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy russian milf"
]
1.65 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy русск milf"
]
1.41 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy русск milf"
]
1.34 ms
(0.82%)
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.