GET https://search.jues.net/search/embeds/10?q=threesome%20blonde

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
232.71 ms
(86.69%)
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
  6591
  55966
  58701
  70659
  80709
  95586
  115206
  142993
  179780
  192968
  213057
  285875
  341753
  383327
  384033
  385197
  385636
  386226
  388020
  388591
  388887
  389418
  390363
  391202
  394243
  395632
  395919
  396576
  397373
  398307
  399700
  400171
  400642
  400935
  401134
  401820
  401959
  403312
  403900
  404371
  405525
  406917
  406973
  411222
  412593
  413471
  413795
  416982
  417303
  417328
  417877
  421025
  425684
  425975
  433231
  437521
  443457
  444147
  445565
  447808
  448816
  449405
  451896
  451957
  452084
  463176
  463756
  464297
  465191
  466640
  466931
  466969
  467773
  467955
  472956
  474581
  477039
  477398
  482504
  483627
  488555
  490684
  499894
  511802
  512466
  514314
  518593
  524628
  532363
  551186
  556795
  558020
  561666
  566690
  576050
  587185
  596054
  606910
  607091
  608048
  633022
  644379
  682517
  683424
  687270
  699577
  699628
  717944
  724230
  748133
  757364
  802691
  808134
  814839
  815357
  816507
  816594
  820337
  821849
  827932
]
23.48 ms
(8.75%)
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
  403312
  403900
  444147
  596054
  388887
  472956
  412593
  518593
  483627
  827932
  388020
  417328
  524628
  608048
  115206
  406973
  411222
  724230
  70659
  395632
  451957
  587185
  416982
  433231
  385636
  384033
  58701
  396576
  400642
  404371
  451896
  465191
  717944
  425684
  401134
  391202
  488555
  452084
  425975
  511802
  386226
  142993
  390363
  417877
  816507
  814839
  466931
  499894
  682517
  699628
  607091
  748133
  179780
  399700
  213057
  55966
  398307
  413471
  443457
  406917
  437521
  821849
  816594
  474581
  447808
  512466
  558020
  683424
  699577
  556795
  644379
  808134
  757364
  388591
  192968
  466640
  401820
  401959
  413795
  467773
  285875
  448816
  341753
  80709
  400935
  417303
  815357
  820337
  449405
  466969
  532363
  464297
  482504
  551186
  576050
  566690
  802691
  463176
  477398
  394243
  6591
  467955
  561666
  687270
  606910
  633022
  385197
  445565
  477039
  95586
  383327
  395919
  400171
  514314
  490684
  397373
  405525
  421025
  463756
  389418
]
4.38 ms
(1.63%)
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
  6591
  55966
  58701
  70659
  80709
  95586
  115206
  142993
  179780
  192968
  213057
  285875
  341753
  383327
  384033
  385197
  385636
  386226
  388020
  388591
  388887
  389418
  390363
  391202
  394243
  395632
  395919
  396576
  397373
  398307
  399700
  400171
  400642
  400935
  401134
  401820
  401959
  403312
  403900
  404371
  405525
  406917
  406973
  411222
  412593
  413471
  413795
  416982
  417303
  417328
  417877
  421025
  425684
  425975
  433231
  437521
  443457
  444147
  445565
  447808
  448816
  449405
  451896
  451957
  452084
  463176
  463756
  464297
  465191
  466640
  466931
  466969
  467773
  467955
  472956
  474581
  477039
  477398
  482504
  483627
  488555
  490684
  499894
  511802
  512466
  514314
  518593
  524628
  532363
  551186
  556795
  558020
  561666
  566690
  576050
  587185
  596054
  606910
  607091
  608048
  633022
  644379
  682517
  683424
  687270
  699577
  699628
  717944
  724230
  748133
  757364
  802691
  808134
  814839
  815357
  816507
  816594
  820337
  821849
  827932
]
2.20 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome blonde"
]
2.04 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро беловолосая"
]
1.95 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.63%)
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.