GET https://search.jues.net/search/embeds/5?q=sex%20in%20hotel

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.08 ms
(84.76%)
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
  33998
  58825
  383549
  384270
  385470
  386879
  393504
  396951
  397072
  398556
  398830
  414078
  424728
  444722
  456997
  457749
  471570
  511129
  513935
  518904
  520207
  526699
  527154
  530095
  539654
  543367
  543740
  545627
  551145
  555652
  555822
  566197
  571702
  575596
  579696
  585393
  588855
  592079
  592145
  595004
  595478
  604474
  606150
  607017
  609840
  617844
  626561
  630836
  636750
  641487
  643582
  646395
  649713
  653148
  654274
  657458
  663823
  673647
  676191
  680624
  682268
  684859
  685926
  692475
  695773
  697221
  707217
  707608
  709623
  712959
  714795
  714892
  715555
  718448
  718786
  718960
  721122
  721896
  726265
  726637
  732984
  732986
  733273
  737442
  739196
  742099
  750123
  751978
  761398
  761895
  767874
  770374
  771490
  774037
  777909
  779330
  779565
  780370
  780447
  783030
  784767
  786414
  788274
  789838
  791424
  792353
  794250
  796247
  796628
  796824
  798762
  802063
  803806
  807410
  809219
  812662
  816682
  817247
  821497
]
11.97 ms
(8.18%)
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
  393504
  456997
  539654
  513935
  530095
  545627
  579696
  649713
  692475
  697221
  707217
  707608
  657458
  718960
  630836
  798762
  807410
  780447
  732986
  732984
  750123
  58825
  444722
  385470
  398556
  511129
  520207
  526699
  575596
  555652
  695773
  718786
  721122
  571702
  585393
  588855
  595478
  779330
  796824
  786414
  761895
  726265
  773429
  761398
  770374
  771490
  774037
  604474
  714795
  383549
  398830
  684859
  396951
  414078
  816682
  527154
  551145
  714892
  718448
  721896
  685926
  709623
  682268
  617844
  626561
  636750
  788274
  803806
  742099
  791424
  751978
  726637
  739196
  715555
  777909
  471570
  543740
  767874
  386879
  796247
  784767
  33998
  384270
  817247
  653148
  663823
  780370
  783030
  397072
  821497
  543367
  676191
  654274
  673647
  555822
  592145
  641487
  595004
  643582
  592079
  802063
  812662
  737442
  789838
  733273
  609840
  796628
  424728
  457749
  518904
  566197
  680624
  646395
  712959
  607017
  606150
  792353
  794250
  809219
  779565
]
3.03 ms
(2.07%)
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
  33998
  58825
  383549
  384270
  385470
  386879
  393504
  396951
  397072
  398556
  398830
  414078
  424728
  444722
  456997
  457749
  471570
  511129
  513935
  518904
  520207
  526699
  527154
  530095
  539654
  543367
  543740
  545627
  551145
  555652
  555822
  566197
  571702
  575596
  579696
  585393
  588855
  592079
  592145
  595004
  595478
  604474
  606150
  607017
  609840
  617844
  626561
  630836
  636750
  641487
  643582
  646395
  649713
  653148
  654274
  657458
  663823
  673647
  676191
  680624
  682268
  684859
  685926
  692475
  695773
  697221
  707217
  707608
  709623
  712959
  714795
  714892
  715555
  718448
  718786
  718960
  721122
  721896
  726265
  726637
  732984
  732986
  733273
  737442
  739196
  742099
  750123
  751978
  761398
  761895
  767874
  770374
  771490
  774037
  777909
  779330
  779565
  780370
  780447
  783030
  784767
  786414
  788274
  789838
  791424
  792353
  794250
  796247
  796628
  796824
  798762
  802063
  803806
  807410
  809219
  812662
  816682
  817247
  821497
]
2.36 ms
(1.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex in hotel"
]
1.88 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс hotel"
]
1.43 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.