GET https://search.jues.net/search/embeds/3?q=hotel%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.87 ms
(85.95%)
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
  108555
  152479
  152973
  382801
  388226
  389696
  389978
  398128
  398556
  416299
  427798
  443950
  469153
  485029
  489102
  509163
  511129
  513935
  515029
  517280
  517479
  530095
  534572
  539654
  547101
  553188
  553831
  557069
  557794
  571831
  579696
  587025
  587978
  588483
  595142
  596905
  596983
  597164
  602051
  602137
  605226
  609732
  617914
  621727
  623372
  630016
  630836
  633030
  633179
  655485
  660804
  661647
  668732
  669277
  672213
  674280
  680542
  684886
  690633
  691148
  692475
  692752
  695405
  695415
  695773
  697221
  701677
  702300
  705211
  707217
  707608
  710489
  711625
  717456
  718448
  721605
  723575
  723807
  728712
  729316
  730364
  730473
  730614
  732984
  732986
  737286
  739200
  750140
  750652
  751508
  753628
  762499
  765839
  773267
  777228
  779804
  784581
  786477
  787070
  787845
  789030
  789070
  790520
  791753
  792191
  793113
  794144
  794256
  795492
  798762
  800081
  800596
  801537
  804177
  807410
  810948
  813477
  818833
  819448
  824488
]
14.08 ms
(7.97%)
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
  152973
  152479
  547101
  732984
  108555
  388226
  416299
  427798
  723575
  824488
  819448
  553831
  691148
  690633
  695415
  702300
  655485
  661647
  684886
  692752
  705211
  717456
  721605
  587978
  617914
  609732
  602051
  630016
  623372
  789030
  791753
  810948
  777228
  784581
  793113
  804177
  730614
  739200
  762499
  765839
  730473
  737286
  728712
  750652
  751508
  633030
  710489
  786477
  787070
  800596
  389696
  695773
  389978
  818833
  605226
  630836
  794144
  398556
  511129
  718448
  773267
  443950
  398128
  382801
  485029
  489102
  469153
  509163
  517280
  539654
  513935
  534572
  515029
  517479
  530095
  557794
  571831
  579696
  660804
  695405
  711625
  668732
  669277
  692475
  697221
  707217
  707608
  672213
  674280
  680542
  701677
  553188
  557069
  587025
  633179
  588483
  602137
  621727
  595142
  596905
  596983
  597164
  779804
  789070
  792191
  795492
  798762
  807410
  787845
  790520
  800081
  801537
  723807
  794256
  813477
  753628
  729316
  732986
  750140
  730364
]
3.01 ms
(1.70%)
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
  108555
  152479
  152973
  382801
  388226
  389696
  389978
  398128
  398556
  416299
  427798
  443950
  469153
  485029
  489102
  509163
  511129
  513935
  515029
  517280
  517479
  530095
  534572
  539654
  547101
  553188
  553831
  557069
  557794
  571831
  579696
  587025
  587978
  588483
  595142
  596905
  596983
  597164
  602051
  602137
  605226
  609732
  617914
  621727
  623372
  630016
  630836
  633030
  633179
  655485
  660804
  661647
  668732
  669277
  672213
  674280
  680542
  684886
  690633
  691148
  692475
  692752
  695405
  695415
  695773
  697221
  701677
  702300
  705211
  707217
  707608
  710489
  711625
  717456
  718448
  721605
  723575
  723807
  728712
  729316
  730364
  730473
  730614
  732984
  732986
  737286
  739200
  750140
  750652
  751508
  753628
  762499
  765839
  773267
  777228
  779804
  784581
  786477
  787070
  787845
  789030
  789070
  790520
  791753
  792191
  793113
  794144
  794256
  795492
  798762
  800081
  800596
  801537
  804177
  807410
  810948
  813477
  818833
  819448
  824488
]
2.00 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hotel wife"
]
1.99 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hotel жен"
]
1.89 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hotel жен"
]

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.