GET https://search.jues.net/search/embeds/6?q=russian%20skinny%20blonde

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.18 ms
(85.15%)
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
  282470
  366037
  383244
  393562
  409532
  413949
  415189
  424128
  425519
  426476
  426843
  428972
  434301
  436203
  442550
  443119
  443700
  443701
  445426
  446081
  447447
  447773
  457129
  457406
  462088
  465134
  465992
  468186
  473981
  477913
  479607
  486112
  489584
  490682
  493255
  495629
  496703
  497005
  497049
  498827
  504233
  506420
  507370
  517572
  518165
  521144
  523970
  526298
  532793
  538229
  545725
  548738
  551171
  551188
  551212
  551215
  552086
  552163
  552395
  553254
  553630
  554125
  555910
  556599
  557038
  559017
  559515
  559534
  561353
  561632
  561635
  561653
  561657
  561666
  561707
  561722
  562212
  563804
  564462
  564644
  565194
  565406
  565956
  567733
  568369
  568732
  568952
  569440
  570066
  570103
  570193
  570254
  570566
  570638
  571945
  571964
  573065
  573081
  573121
  573550
  573568
  573766
  573972
  574817
  574901
  575100
  575121
  575510
  579116
  579534
  580641
  581877
  583728
  584793
  588730
  592329
  681958
  699628
  755630
  809260
]
19.15 ms
(9.41%)
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
  579116
  580641
  552163
  554125
  559515
  561632
  561653
  561707
  565406
  570254
  573568
  681958
  551188
  552086
  553254
  556599
  559534
  562212
  563804
  565194
  568369
  570193
  570566
  809260
  755630
  425519
  436203
  443119
  443701
  465992
  479607
  465134
  447447
  409532
  477913
  442550
  446081
  504233
  526298
  486112
  496703
  521144
  489584
  506420
  507370
  538229
  588730
  559017
  445426
  383244
  447773
  584793
  568952
  571945
  545725
  561353
  561635
  564644
  570066
  571964
  557038
  573065
  366037
  413949
  457129
  393562
  415189
  434301
  457406
  282470
  424128
  426476
  443700
  462088
  468186
  473981
  426843
  428972
  518165
  493255
  495629
  532793
  490682
  498827
  517572
  497049
  523970
  497005
  551171
  551215
  555910
  561666
  561722
  564462
  574817
  552395
  553630
  569440
  570103
  573081
  573550
  573766
  575100
  575121
  575510
  581877
  561657
  568732
  570638
  573121
  573972
  574901
  583728
  699628
  548738
  551212
  565956
  567733
  579534
  592329
]
3.44 ms
(1.69%)
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
  282470
  366037
  383244
  393562
  409532
  413949
  415189
  424128
  425519
  426476
  426843
  428972
  434301
  436203
  442550
  443119
  443700
  443701
  445426
  446081
  447447
  447773
  457129
  457406
  462088
  465134
  465992
  468186
  473981
  477913
  479607
  486112
  489584
  490682
  493255
  495629
  496703
  497005
  497049
  498827
  504233
  506420
  507370
  517572
  518165
  521144
  523970
  526298
  532793
  538229
  545725
  548738
  551171
  551188
  551212
  551215
  552086
  552163
  552395
  553254
  553630
  554125
  555910
  556599
  557038
  559017
  559515
  559534
  561353
  561632
  561635
  561653
  561657
  561666
  561707
  561722
  562212
  563804
  564462
  564644
  565194
  565406
  565956
  567733
  568369
  568732
  568952
  569440
  570066
  570103
  570193
  570254
  570566
  570638
  571945
  571964
  573065
  573081
  573121
  573550
  573568
  573766
  573972
  574817
  574901
  575100
  575121
  575510
  579116
  579534
  580641
  581877
  583728
  584793
  588730
  592329
  681958
  699628
  755630
  809260
]
2.08 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian skinny blonde"
]
1.97 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск худые беловолосая"
]
1.76 ms
(0.86%)
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.