GET https://search.jues.net/search/embeds/8?q=threesome%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.13 ms
(85.24%)
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
  4131
  391202
  392177
  399162
  400694
  409615
  418567
  429728
  429792
  442551
  442685
  450687
  456681
  456858
  456883
  457245
  457780
  459086
  470548
  470607
  477459
  479077
  482147
  484253
  488560
  500345
  500909
  504171
  508213
  511515
  512466
  513269
  517448
  518499
  523369
  523479
  525710
  531453
  535897
  539841
  543389
  544769
  545865
  550294
  550665
  554796
  566187
  580482
  584951
  585329
  587216
  587223
  587605
  590903
  593853
  598185
  603177
  603648
  604984
  606910
  615438
  616766
  618199
  618544
  622114
  622131
  622170
  622174
  632031
  651428
  653349
  653379
  653766
  653865
  653941
  654624
  656904
  663568
  666695
  675221
  676326
  677064
  678387
  678484
  679863
  687468
  690040
  692890
  702234
  702286
  703472
  715581
  719808
  727799
  728200
  728720
  732697
  741116
  743782
  745785
  770800
  773963
  775261
  775846
  776931
  785145
  785226
  789481
  794362
  795807
  799601
  799653
  802720
  811770
  813050
  816267
  816603
  818998
  819571
  827078
]
16.05 ms
(9.43%)
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
  606910
  795807
  773963
  482147
  457780
  504171
  622174
  622131
  4131
  535897
  603177
  616766
  391202
  429728
  816603
  818998
  819571
  484253
  554796
  584951
  543389
  580482
  653379
  692890
  663568
  585329
  622170
  770800
  727799
  702234
  429792
  418567
  566187
  442551
  816267
  456883
  477459
  457245
  470607
  511515
  523369
  539841
  512466
  531453
  653766
  653865
  651428
  653941
  676326
  678387
  590903
  618199
  587223
  811770
  789481
  745785
  732697
  802720
  400694
  409615
  500909
  392177
  827078
  456858
  456681
  500345
  508213
  513269
  656904
  666695
  702286
  678484
  687468
  690040
  632031
  618544
  775846
  799653
  743782
  776931
  523479
  442685
  450687
  525710
  545865
  550294
  675221
  544769
  598185
  603648
  615438
  785145
  785226
  799601
  794362
  728720
  703472
  775261
  459086
  479077
  550665
  677064
  587605
  728200
  604984
  719808
  653349
  741116
  622114
  654624
  399162
  488560
  679863
  518499
  517448
  587216
  813050
  593853
  715581
  470548
]
2.41 ms
(1.41%)
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
  4131
  391202
  392177
  399162
  400694
  409615
  418567
  429728
  429792
  442551
  442685
  450687
  456681
  456858
  456883
  457245
  457780
  459086
  470548
  470607
  477459
  479077
  482147
  484253
  488560
  500345
  500909
  504171
  508213
  511515
  512466
  513269
  517448
  518499
  523369
  523479
  525710
  531453
  535897
  539841
  543389
  544769
  545865
  550294
  550665
  554796
  566187
  580482
  584951
  585329
  587216
  587223
  587605
  590903
  593853
  598185
  603177
  603648
  604984
  606910
  615438
  616766
  618199
  618544
  622114
  622131
  622170
  622174
  632031
  651428
  653349
  653379
  653766
  653865
  653941
  654624
  656904
  663568
  666695
  675221
  676326
  677064
  678387
  678484
  679863
  687468
  690040
  692890
  702234
  702286
  703472
  715581
  719808
  727799
  728200
  728720
  732697
  741116
  743782
  745785
  770800
  773963
  775261
  775846
  776931
  785145
  785226
  789481
  794362
  795807
  799601
  799653
  802720
  811770
  813050
  816267
  816603
  818998
  819571
  827078
]
1.92 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome wife"
]
1.67 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро жен"
]
1.66 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.83%)
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.