GET https://search.jues.net/search/embeds/9?q=facesitting%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.49 ms
(85.89%)
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
  29429
  384049
  418254
  434656
  437705
  450485
  455175
  455790
  460856
  466081
  466157
  466316
  468328
  469720
  470920
  479283
  482564
  485039
  490114
  492625
  499875
  500949
  504162
  507975
  509114
  509232
  509353
  511045
  512580
  513386
  514985
  520363
  521697
  521745
  524138
  525705
  535100
  537838
  541302
  555369
  555908
  577134
  580609
  596376
  598139
  599230
  605520
  616795
  621792
  627063
  659066
  660435
  670919
  674615
  680590
  681501
  691735
  696989
  697513
  705744
  723964
  724093
  726596
  728902
  728903
  729258
  729284
  732791
  733325
  736267
  741073
  745364
  746040
  750644
  757167
  758816
  761267
  761273
  761306
  761670
  762780
  762812
  763482
  764250
  764807
  767040
  767479
  769957
  771782
  782775
  784831
  785119
  787055
  787667
  787983
  788217
  788235
  788799
  788867
  791213
  793877
  794445
  794958
  797250
  798427
  799657
  801182
  803038
  805276
  806383
  808091
  808497
  812387
  813100
  813161
  814117
  814309
  817571
  823634
  826576
]
14.45 ms
(8.47%)
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
  788217
  797250
  808091
  813161
  723964
  757167
  762780
  767479
  794958
  799657
  803038
  813100
  736267
  761267
  761273
  764807
  767040
  724093
  729284
  758816
  762812
  729258
  732791
  741073
  750644
  761306
  771782
  697513
  784831
  785119
  788799
  794445
  806383
  460856
  384049
  418254
  450485
  479283
  512580
  521697
  29429
  814309
  525705
  537838
  577134
  555908
  596376
  627063
  793877
  805276
  787667
  763482
  808497
  470920
  468328
  513386
  520363
  504162
  680590
  466081
  466316
  466157
  492625
  541302
  761670
  434656
  437705
  826576
  817571
  823634
  814117
  482564
  469720
  490114
  455175
  455790
  485039
  499875
  500949
  509114
  514985
  521745
  509232
  524138
  507975
  509353
  511045
  535100
  555369
  670919
  705744
  674615
  681501
  696989
  659066
  660435
  691735
  580609
  605520
  598139
  621792
  599230
  616795
  782775
  788867
  791213
  798427
  801182
  812387
  787983
  788235
  787055
  728903
  733325
  745364
  746040
  769957
  728902
  764250
  726596
]
2.46 ms
(1.44%)
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
  29429
  384049
  418254
  434656
  437705
  450485
  455175
  455790
  460856
  466081
  466157
  466316
  468328
  469720
  470920
  479283
  482564
  485039
  490114
  492625
  499875
  500949
  504162
  507975
  509114
  509232
  509353
  511045
  512580
  513386
  514985
  520363
  521697
  521745
  524138
  525705
  535100
  537838
  541302
  555369
  555908
  577134
  580609
  596376
  598139
  599230
  605520
  616795
  621792
  627063
  659066
  660435
  670919
  674615
  680590
  681501
  691735
  696989
  697513
  705744
  723964
  724093
  726596
  728902
  728903
  729258
  729284
  732791
  733325
  736267
  741073
  745364
  746040
  750644
  757167
  758816
  761267
  761273
  761306
  761670
  762780
  762812
  763482
  764250
  764807
  767040
  767479
  769957
  771782
  782775
  784831
  785119
  787055
  787667
  787983
  788217
  788235
  788799
  788867
  791213
  793877
  794445
  794958
  797250
  798427
  799657
  801182
  803038
  805276
  806383
  808091
  808497
  812387
  813100
  813161
  814117
  814309
  817571
  823634
  826576
]
2.12 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facesitting wife"
]
1.84 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фейсситтинг жен"
]
1.43 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.