GET https://search.jues.net/search/embeds/3?q=saggy%20wife%20group

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.72 ms
(82.27%)
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
  418453
  420447
  421250
  424660
  425655
  427251
  440713
  440990
  443660
  443823
  447031
  453494
  453906
  455411
  455912
  456164
  460734
  462305
  462315
  462698
  462700
  464301
  464327
  466056
  466073
  466094
  466097
  466103
  466107
  466111
  466321
  466481
  467009
  467033
  470596
  471723
  474008
  474012
  474024
  474678
  474702
  476251
  476261
  477705
  484381
  484383
  484459
  484463
  484618
  484629
  484636
  484653
  484661
  484665
  484666
  484674
  484687
  484690
  484693
  484696
  484728
  485700
  485703
  485735
  486450
  490831
  492563
  495700
  495703
  495739
  495741
  500363
  500364
  501248
  501500
  504183
  504213
  506047
  509373
  510742
  511023
  518842
  520753
  520771
  521740
  522902
  523309
  525626
  525628
  532893
  540785
  541408
  543771
  546993
  550230
  550232
  550233
  554311
  554392
  554409
  558425
  562361
  562368
  568061
  587681
  598024
  598097
  600030
  605521
  606561
  607100
  612422
  627812
  640136
  647960
  650633
  730798
  756386
  813252
  814865
]
21.02 ms
(11.87%)
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
  484459
  484618
  484674
  484690
  456164
  504213
  427251
  532893
  607100
  813252
  471723
  509373
  523309
  495703
  443660
  440713
  540785
  447031
  453494
  474008
  525626
  495739
  500364
  541408
  546993
  554311
  598097
  587681
  606561
  612422
  476261
  420447
  460734
  462305
  466073
  466107
  466111
  424660
  467033
  477705
  418453
  466056
  466103
  484381
  484629
  484636
  495700
  522902
  484383
  484653
  484661
  501500
  474012
  443823
  462315
  466097
  500363
  486450
  490831
  466481
  550232
  756386
  518842
  484687
  421250
  484693
  455411
  485735
  520771
  484728
  640136
  600030
  440990
  462700
  466094
  466321
  484665
  484666
  485700
  495741
  510742
  650633
  470596
  453906
  562361
  474024
  484463
  562368
  550230
  647960
  730798
  455912
  485703
  511023
  484696
  520753
  568061
  814865
  525628
  558425
  476251
  504183
  598024
  627812
  464327
  506047
  464301
  554409
  550233
  474678
  492563
  425655
  462698
  474702
  501248
  605521
  467009
  543771
  554392
  521740
]
3.43 ms
(1.93%)
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
  418453
  420447
  421250
  424660
  425655
  427251
  440713
  440990
  443660
  443823
  447031
  453494
  453906
  455411
  455912
  456164
  460734
  462305
  462315
  462698
  462700
  464301
  464327
  466056
  466073
  466094
  466097
  466103
  466107
  466111
  466321
  466481
  467009
  467033
  470596
  471723
  474008
  474012
  474024
  474678
  474702
  476251
  476261
  477705
  484381
  484383
  484459
  484463
  484618
  484629
  484636
  484653
  484661
  484665
  484666
  484674
  484687
  484690
  484693
  484696
  484728
  485700
  485703
  485735
  486450
  490831
  492563
  495700
  495703
  495739
  495741
  500363
  500364
  501248
  501500
  504183
  504213
  506047
  509373
  510742
  511023
  518842
  520753
  520771
  521740
  522902
  523309
  525626
  525628
  532893
  540785
  541408
  543771
  546993
  550230
  550232
  550233
  554311
  554392
  554409
  558425
  562361
  562368
  568061
  587681
  598024
  598097
  600030
  605521
  606561
  607100
  612422
  627812
  640136
  647960
  650633
  730798
  756386
  813252
  814865
]
1.99 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "saggy wife group"
]
1.97 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "saggy жен group"
]
1.33 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "saggy жен group"
]

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.