GET https://search.jues.net/search/embeds/9?q=threesome%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.12 ms
(59.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome amateur"
]
120.45 ms
(34.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
  384138
  386200
  392967
  394543
  398700
  401522
  401969
  410090
  410911
  419120
  422019
  453856
  466002
  477633
  495182
  501394
  516307
  517184
  528867
  531393
  536219
  538141
  540479
  543721
  544749
  544751
  544757
  545106
  545585
  545589
  547939
  547961
  559614
  559644
  562754
  563387
  566415
  574410
  577112
  577454
  579541
  579598
  584369
  587254
  590857
  592884
  593075
  593833
  593840
  597507
  600955
  603572
  603632
  610811
  613815
  616368
  617590
  622105
  623346
  624819
  630668
  632423
  635794
  636267
  640727
  649226
  651310
  652857
  653165
  653343
  653384
  653807
  653829
  653912
  663328
  673533
  674515
  676851
  677578
  685521
  691616
  694322
  705520
  708134
  709295
  712470
  712636
  712651
  714086
  714128
  715089
  719243
  720215
  720965
  724410
  729216
  729258
  729276
  736664
  748436
  751026
  773947
  774293
  776566
  782755
  787757
  788669
  796457
  803348
  805705
  806068
  807471
  807914
  808359
  809409
  809468
  812293
  817445
  819180
  820523
]
14.84 ms
(4.25%)
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
  817445
  708134
  603632
  809409
  807471
  653165
  384138
  819180
  577112
  782755
  805705
  544751
  544749
  796457
  545585
  559644
  712470
  774293
  709295
  538141
  685521
  653807
  544757
  593075
  603572
  803348
  677578
  410090
  477633
  547939
  517184
  536219
  691616
  630668
  636267
  597507
  392967
  584369
  422019
  676851
  712636
  776566
  806068
  729276
  453856
  466002
  501394
  401522
  540479
  651310
  652857
  610811
  622105
  715089
  714086
  590857
  566415
  579598
  812293
  787757
  616368
  719243
  559614
  587254
  419120
  547961
  820523
  531393
  720965
  577454
  593840
  724410
  751026
  495182
  649226
  712651
  663328
  635794
  729258
  640727
  401969
  624819
  736664
  528867
  574410
  386200
  592884
  593833
  807914
  809468
  579541
  613815
  705520
  410911
  563387
  714128
  545106
  545589
  808359
  773947
  748436
  720215
  788669
  394543
  398700
  617590
  543721
  562754
  653343
  653384
  694322
  653829
  653912
  674515
  673533
  600955
  623346
  729216
  632423
  516307
]
2.41 ms
(0.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
  384138
  386200
  392967
  394543
  398700
  401522
  401969
  410090
  410911
  419120
  422019
  453856
  466002
  477633
  495182
  501394
  516307
  517184
  528867
  531393
  536219
  538141
  540479
  543721
  544749
  544751
  544757
  545106
  545585
  545589
  547939
  547961
  559614
  559644
  562754
  563387
  566415
  574410
  577112
  577454
  579541
  579598
  584369
  587254
  590857
  592884
  593075
  593833
  593840
  597507
  600955
  603572
  603632
  610811
  613815
  616368
  617590
  622105
  623346
  624819
  630668
  632423
  635794
  636267
  640727
  649226
  651310
  652857
  653165
  653343
  653384
  653807
  653829
  653912
  663328
  673533
  674515
  676851
  677578
  685521
  691616
  694322
  705520
  708134
  709295
  712470
  712636
  712651
  714086
  714128
  715089
  719243
  720215
  720965
  724410
  729216
  729258
  729276
  736664
  748436
  751026
  773947
  774293
  776566
  782755
  787757
  788669
  796457
  803348
  805705
  806068
  807471
  807914
  808359
  809409
  809468
  812293
  817445
  819180
  820523
]
1.91 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро любительск"
]
1.72 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро любительск"
]
1.35 ms
(0.39%)
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.