GET https://search.jues.net/search/embeds/3?q=anal%20cum%20mouth

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.53 ms
(85.36%)
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
  397906
  424116
  425572
  432719
  434442
  440953
  444699
  445891
  446356
  447911
  447917
  447947
  448149
  448215
  452308
  452594
  452760
  454836
  455579
  455875
  459611
  461366
  467700
  483691
  484228
  488249
  494174
  495140
  501462
  507329
  510855
  511455
  513655
  513838
  518231
  519565
  519576
  519879
  523013
  523134
  524455
  530484
  530768
  531115
  531145
  532625
  533010
  533760
  534378
  534670
  535028
  535038
  535597
  536215
  536687
  536766
  536789
  540338
  541201
  542583
  542595
  543627
  544835
  545747
  550124
  553273
  555090
  555106
  562763
  562938
  565283
  566854
  571230
  571433
  572961
  589064
  596882
  599875
  599963
  600002
  600344
  615818
  619221
  620116
  622392
  624320
  629330
  630527
  631195
  631249
  632611
  632852
  634158
  634510
  634787
  637007
  637043
  637063
  640779
  640800
  642875
  643939
  646178
  647939
  648846
  674507
  696451
  717635
  723512
  726864
  746331
  762213
  775860
  782516
  787442
  790844
  795683
  797110
  800808
  814553
]
15.75 ms
(8.76%)
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
  507329
  562938
  589064
  630527
  600344
  624320
  452760
  455579
  452308
  494174
  531145
  534378
  648846
  544835
  572961
  599963
  454836
  455875
  510855
  519565
  790844
  746331
  445891
  447947
  459611
  533010
  530484
  555090
  555106
  620116
  637007
  795683
  643939
  424116
  518231
  488249
  534670
  723512
  814553
  484228
  674507
  619221
  726864
  622392
  629330
  797110
  800808
  432719
  461366
  483691
  533760
  535038
  550124
  634158
  637063
  637043
  634510
  425572
  447911
  524455
  565283
  448149
  511455
  513655
  519879
  562763
  615818
  397906
  434442
  513838
  536215
  535597
  545747
  600002
  523013
  523134
  530768
  531115
  535028
  495140
  553273
  566854
  541201
  631195
  631249
  634787
  640800
  640779
  782516
  452594
  440953
  532625
  467700
  571230
  646178
  696451
  762213
  632611
  717635
  444699
  501462
  540338
  536766
  536687
  536789
  647939
  599875
  632852
  519576
  775860
  787442
  448215
  446356
  542583
  571433
  542595
  543627
  596882
  642875
  447917
]
4.02 ms
(2.23%)
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
  397906
  424116
  425572
  432719
  434442
  440953
  444699
  445891
  446356
  447911
  447917
  447947
  448149
  448215
  452308
  452594
  452760
  454836
  455579
  455875
  459611
  461366
  467700
  483691
  484228
  488249
  494174
  495140
  501462
  507329
  510855
  511455
  513655
  513838
  518231
  519565
  519576
  519879
  523013
  523134
  524455
  530484
  530768
  531115
  531145
  532625
  533010
  533760
  534378
  534670
  535028
  535038
  535597
  536215
  536687
  536766
  536789
  540338
  541201
  542583
  542595
  543627
  544835
  545747
  550124
  553273
  555090
  555106
  562763
  562938
  565283
  566854
  571230
  571433
  572961
  589064
  596882
  599875
  599963
  600002
  600344
  615818
  619221
  620116
  622392
  624320
  629330
  630527
  631195
  631249
  632611
  632852
  634158
  634510
  634787
  637007
  637043
  637063
  640779
  640800
  642875
  643939
  646178
  647939
  648846
  674507
  696451
  717635
  723512
  726864
  746331
  762213
  775860
  782516
  787442
  790844
  795683
  797110
  800808
  814553
]
1.84 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal cum mouth"
]
1.68 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал cum mouth"
]
1.62 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал cum mouth"
]
1.43 ms
(0.79%)
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.