GET https://search.jues.net/search/embeds/4?q=sex%20sauna

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.07 ms
(79.35%)
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
  72730
  122488
  122817
  236472
  351650
  366284
  382085
  383697
  402254
  402518
  411047
  411697
  415540
  417391
  418877
  423375
  426675
  430407
  451578
  453514
  453595
  454279
  458595
  460726
  462155
  462539
  464738
  467628
  468006
  470003
  470563
  470590
  474247
  474494
  476259
  476261
  478461
  480387
  481358
  484547
  485487
  485960
  491361
  493342
  499022
  504446
  508041
  513303
  522104
  522838
  523109
  523982
  533851
  539139
  548092
  550804
  552034
  552159
  552212
  552887
  556879
  556884
  562247
  566503
  566575
  566637
  573776
  576393
  584022
  585089
  585596
  585671
  590579
  590839
  591918
  599332
  600887
  614611
  625164
  633079
  633085
  633097
  651644
  659347
  662556
  664087
  671761
  686401
  692973
  695661
  699661
  702147
  704702
  706480
  713794
  719452
  722086
  731285
  738583
  740035
  744933
  749799
  758501
  763724
  776403
  779144
  779146
  779162
  781601
  794500
  795585
  797598
  799813
  804158
  809125
  810692
  814765
  822412
  822768
  823648
]
21.94 ms
(14.26%)
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
  522104
  556879
  411047
  476259
  591918
  556884
  415540
  462539
  566575
  662556
  671761
  633097
  633079
  522838
  474247
  470003
  418877
  430407
  533851
  573776
  590839
  460726
  467628
  468006
  633085
  548092
  411697
  552887
  451578
  426675
  523982
  484547
  462155
  417391
  481358
  763724
  499022
  590579
  625164
  562247
  566637
  576393
  480387
  72730
  523109
  566503
  474494
  470590
  476261
  584022
  823648
  122817
  423375
  692973
  614611
  699661
  504446
  122488
  794500
  749799
  659347
  513303
  366284
  585671
  740035
  458595
  795585
  382085
  695661
  550804
  804158
  402518
  799813
  822412
  719452
  822768
  706480
  704702
  454279
  779162
  781601
  731285
  797598
  236472
  351650
  402254
  585089
  722086
  539139
  464738
  552159
  585596
  779144
  738583
  508041
  383697
  758501
  485487
  470563
  809125
  744933
  810692
  493342
  552212
  776403
  552034
  702147
  664087
  814765
  686401
  713794
  485960
  600887
  478461
  599332
  453514
  453595
  651644
  779146
  491361
]
3.42 ms
(2.22%)
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
  72730
  122488
  122817
  236472
  351650
  366284
  382085
  383697
  402254
  402518
  411047
  411697
  415540
  417391
  418877
  423375
  426675
  430407
  451578
  453514
  453595
  454279
  458595
  460726
  462155
  462539
  464738
  467628
  468006
  470003
  470563
  470590
  474247
  474494
  476259
  476261
  478461
  480387
  481358
  484547
  485487
  485960
  491361
  493342
  499022
  504446
  508041
  513303
  522104
  522838
  523109
  523982
  533851
  539139
  548092
  550804
  552034
  552159
  552212
  552887
  556879
  556884
  562247
  566503
  566575
  566637
  573776
  576393
  584022
  585089
  585596
  585671
  590579
  590839
  591918
  599332
  600887
  614611
  625164
  633079
  633085
  633097
  651644
  659347
  662556
  664087
  671761
  686401
  692973
  695661
  699661
  702147
  704702
  706480
  713794
  719452
  722086
  731285
  738583
  740035
  744933
  749799
  758501
  763724
  776403
  779144
  779146
  779162
  781601
  794500
  795585
  797598
  799813
  804158
  809125
  810692
  814765
  822412
  822768
  823648
]
1.76 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex sauna"
]
1.74 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс бан"
]
1.35 ms
(0.88%)
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.