GET https://search.jues.net/search/embeds/4?q=hidden%20public%20bath

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.96 ms
(86.30%)
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
  364718
  411300
  411425
  420520
  428021
  443878
  447376
  449691
  455370
  455732
  455809
  456280
  456843
  456873
  457019
  457043
  457057
  457697
  457715
  457718
  457739
  461958
  465420
  465423
  468926
  468947
  468948
  469632
  471172
  472038
  474072
  474158
  477763
  477855
  478106
  488213
  488234
  488235
  488848
  489779
  494657
  494663
  494682
  494866
  495173
  495499
  497599
  503041
  503907
  506571
  507152
  507769
  510718
  510730
  513162
  516692
  519366
  520173
  520298
  522217
  523136
  527043
  527887
  528681
  534335
  534344
  534667
  534841
  535451
  537617
  537783
  541144
  541907
  545732
  548382
  550477
  550506
  552282
  553331
  553454
  556375
  558104
  558108
  558449
  567854
  568483
  580925
  584691
  585475
  594944
  594947
  599666
  605654
  613355
  620808
  632808
  634329
  636528
  637517
  672369
  673574
  689697
  692108
  708297
  714027
  714341
  721954
  721968
  729593
  736548
  738951
  761142
  774345
  785540
  789009
  792760
  794625
  805225
  810638
  823617
]
15.30 ms
(8.57%)
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
  692108
  594944
  792760
  785540
  465420
  497599
  823617
  522217
  584691
  541907
  689697
  585475
  594947
  599666
  789009
  774345
  721954
  810638
  634329
  548382
  495173
  527887
  456280
  488848
  506571
  568483
  541144
  708297
  580925
  553331
  516692
  736548
  738951
  489779
  729593
  503041
  447376
  457019
  468948
  474158
  456843
  457739
  537783
  510718
  468947
  488213
  443878
  457718
  465423
  494663
  534667
  545732
  714027
  567854
  605654
  794625
  474072
  469632
  507152
  488235
  428021
  468926
  477855
  534841
  520298
  527043
  535451
  488234
  550506
  553454
  714341
  632808
  620808
  613355
  761142
  636528
  461958
  534344
  513162
  550477
  411300
  471172
  528681
  552282
  637517
  411425
  558108
  556375
  523136
  672369
  805225
  494682
  537617
  478106
  534335
  364718
  449691
  477763
  510730
  673574
  495499
  457715
  558104
  507769
  456873
  455809
  457043
  558449
  721968
  420520
  457697
  455370
  455732
  494657
  494866
  520173
  457057
  472038
  503907
  519366
]
2.59 ms
(1.45%)
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
  364718
  411300
  411425
  420520
  428021
  443878
  447376
  449691
  455370
  455732
  455809
  456280
  456843
  456873
  457019
  457043
  457057
  457697
  457715
  457718
  457739
  461958
  465420
  465423
  468926
  468947
  468948
  469632
  471172
  472038
  474072
  474158
  477763
  477855
  478106
  488213
  488234
  488235
  488848
  489779
  494657
  494663
  494682
  494866
  495173
  495499
  497599
  503041
  503907
  506571
  507152
  507769
  510718
  510730
  513162
  516692
  519366
  520173
  520298
  522217
  523136
  527043
  527887
  528681
  534335
  534344
  534667
  534841
  535451
  537617
  537783
  541144
  541907
  545732
  548382
  550477
  550506
  552282
  553331
  553454
  556375
  558104
  558108
  558449
  567854
  568483
  580925
  584691
  585475
  594944
  594947
  599666
  605654
  613355
  620808
  632808
  634329
  636528
  637517
  672369
  673574
  689697
  692108
  708297
  714027
  714341
  721954
  721968
  729593
  736548
  738951
  761142
  774345
  785540
  789009
  792760
  794625
  805225
  810638
  823617
]
1.70 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden public bath"
]
1.60 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт на bath улиц"
]
1.57 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скрыт на bath улиц"
]

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.