GET https://search.jues.net/search/embeds/5?q=big%20tits%20facial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.08 ms
(85.53%)
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
  3671
  382163
  382450
  387437
  398011
  408832
  417046
  423788
  427314
  428764
  429294
  437638
  440840
  440946
  443049
  450738
  450982
  453128
  453292
  455604
  456825
  466781
  466957
  470525
  474382
  474742
  474844
  483365
  487553
  489270
  489272
  493433
  494781
  502450
  504233
  505631
  506036
  507315
  509411
  511596
  512067
  515875
  515997
  521152
  524247
  527169
  528054
  528786
  552115
  552246
  555066
  555161
  557077
  560099
  561303
  561640
  561707
  562249
  563638
  566690
  568372
  569543
  569545
  574940
  578234
  579137
  579941
  579944
  580982
  583947
  586986
  587489
  590327
  593051
  595512
  601871
  603032
  604635
  604789
  610120
  617648
  621865
  626331
  631207
  636396
  636674
  643084
  643489
  652179
  653216
  653248
  653272
  654269
  662374
  670234
  672329
  673472
  695836
  704952
  711569
  714498
  718236
  722912
  727728
  728458
  744909
  763121
  795143
  803444
  804864
  806836
  807919
  809271
  810614
  811410
  811681
  816957
  817903
  819151
]
17.94 ms
(9.30%)
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
  595512
  807919
  474742
  456825
  504233
  515875
  528786
  440840
  507315
  562249
  568372
  718236
  653248
  670234
  382163
  552246
  579941
  604789
  804864
  643489
  527169
  483365
  489272
  509411
  429294
  427314
  489270
  586986
  631207
  382450
  423788
  819151
  817903
  466957
  528054
  579137
  673472
  574940
  636396
  587489
  626331
  806836
  744909
  502450
  811681
  440946
  561303
  590327
  580982
  487553
  453292
  474382
  578234
  387437
  466781
  443049
  474844
  512067
  408832
  470525
  506036
  494781
  505631
  569545
  704952
  722912
  566690
  593051
  728458
  763121
  455604
  437638
  493433
  511596
  515997
  521152
  3671
  555161
  398011
  601871
  795143
  803444
  604635
  810614
  811410
  610120
  809271
  552115
  555066
  560099
  561640
  579944
  563638
  569543
  561707
  653216
  695836
  652179
  653272
  714498
  727728
  428764
  557077
  662374
  711569
  621865
  617648
  643084
  450738
  524247
  816957
  453128
  654269
  583947
  603032
  636674
  417046
  450982
  672329
  557804
]
2.95 ms
(1.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
  3671
  382163
  382450
  387437
  398011
  408832
  417046
  423788
  427314
  428764
  429294
  437638
  440840
  440946
  443049
  450738
  450982
  453128
  453292
  455604
  456825
  466781
  466957
  470525
  474382
  474742
  474844
  483365
  487553
  489270
  489272
  493433
  494781
  502450
  504233
  505631
  506036
  507315
  509411
  511596
  512067
  515875
  515997
  521152
  524247
  527169
  528054
  528786
  552115
  552246
  555066
  555161
  557077
  560099
  561303
  561640
  561707
  562249
  563638
  566690
  568372
  569543
  569545
  574940
  578234
  579137
  579941
  579944
  580982
  583947
  586986
  587489
  590327
  593051
  595512
  601871
  603032
  604635
  604789
  610120
  617648
  621865
  626331
  631207
  636396
  636674
  643084
  643489
  652179
  653216
  653248
  653272
  654269
  662374
  670234
  672329
  673472
  695836
  704952
  711569
  714498
  718236
  722912
  727728
  728458
  744909
  763121
  795143
  803444
  804864
  806836
  807919
  809271
  810614
  811410
  811681
  816957
  817903
  819151
]
1.96 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits facial"
]
1.84 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ facial"
]
1.69 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ facial"
]

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.