GET https://search.jues.net/search/embeds/2?q=latina%20threesome

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.47 ms
(87.05%)
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
  309449
  382049
  382060
  384998
  397481
  399926
  401842
  406312
  411838
  412183
  414729
  426085
  430476
  445542
  447143
  449060
  452648
  459192
  476138
  476578
  486674
  492247
  519688
  527231
  527464
  530836
  531085
  532166
  535045
  536640
  537673
  541434
  542859
  559091
  580647
  580765
  585135
  585753
  587729
  602443
  603220
  607403
  608441
  608629
  610284
  617408
  620160
  623869
  626838
  627018
  628114
  629304
  634770
  637085
  642556
  645001
  647328
  649975
  650532
  653601
  653630
  653865
  654200
  663547
  664212
  669574
  670239
  672999
  677323
  684048
  703472
  716969
  720245
  720291
  720340
  720394
  720840
  720882
  724934
  726301
  730299
  731323
  731480
  732003
  732733
  733589
  734481
  742135
  747234
  755759
  765648
  767859
  768879
  770546
  770884
  775261
  775794
  788315
  792560
  793376
  794265
  796078
  799653
  806160
  809302
  810668
  811040
  813873
  814659
  814822
  815064
  815374
  815442
  815473
  815483
  815748
  818181
  821844
  825122
  825561
]
13.38 ms
(7.59%)
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
  603220
  770546
  806160
  755759
  825122
  653630
  459192
  747234
  607403
  775794
  720394
  810668
  720340
  731323
  821844
  406312
  559091
  815442
  542859
  770884
  730299
  732003
  645001
  814822
  815483
  792560
  447143
  382060
  412183
  492247
  653865
  654200
  629304
  608441
  742135
  649975
  818181
  519688
  672999
  587729
  799653
  768879
  825561
  527231
  653601
  663547
  626838
  703472
  775261
  809302
  716969
  452648
  426085
  796078
  414729
  476138
  720840
  642556
  815064
  794265
  726301
  535045
  397481
  793376
  536640
  669574
  811040
  617408
  399926
  813873
  720882
  734481
  815473
  537673
  532166
  684048
  664212
  620160
  814659
  486674
  637085
  724934
  733589
  765648
  788315
  531085
  650532
  602443
  623869
  767859
  720291
  411838
  610284
  627018
  476578
  634770
  731480
  309449
  430476
  580765
  580647
  677323
  732733
  585753
  445542
  449060
  670239
  608629
  530836
  647328
  382049
  585135
  815748
  541434
  384998
  815374
  527464
  720245
  628114
  401842
]
2.60 ms
(1.48%)
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
  309449
  382049
  382060
  384998
  397481
  399926
  401842
  406312
  411838
  412183
  414729
  426085
  430476
  445542
  447143
  449060
  452648
  459192
  476138
  476578
  486674
  492247
  519688
  527231
  527464
  530836
  531085
  532166
  535045
  536640
  537673
  541434
  542859
  559091
  580647
  580765
  585135
  585753
  587729
  602443
  603220
  607403
  608441
  608629
  610284
  617408
  620160
  623869
  626838
  627018
  628114
  629304
  634770
  637085
  642556
  645001
  647328
  649975
  650532
  653601
  653630
  653865
  654200
  663547
  664212
  669574
  670239
  672999
  677323
  684048
  703472
  716969
  720245
  720291
  720340
  720394
  720840
  720882
  724934
  726301
  730299
  731323
  731480
  732003
  732733
  733589
  734481
  742135
  747234
  755759
  765648
  767859
  768879
  770546
  770884
  775261
  775794
  788315
  792560
  793376
  794265
  796078
  799653
  806160
  809302
  810668
  811040
  813873
  814659
  814822
  815064
  815374
  815442
  815473
  815483
  815748
  818181
  821844
  825122
  825561
]
1.89 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina threesome"
]
1.72 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская секс втро"
]
1.48 ms
(0.84%)
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.