GET https://search.jues.net/search/embeds/6?q=xxx%20hotel

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.66 ms
(83.24%)
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
  4349
  383549
  384270
  386297
  386879
  395317
  395504
  397072
  398128
  398830
  399048
  403268
  418739
  443950
  451090
  452175
  457749
  469126
  471570
  474412
  476633
  500182
  505290
  509549
  518904
  525414
  543367
  543740
  555822
  557847
  558211
  559851
  559907
  566197
  579838
  592145
  595003
  595004
  604474
  607017
  610138
  614985
  617956
  629260
  633917
  637229
  641479
  641487
  643582
  646395
  651102
  651294
  653148
  654274
  660687
  661899
  663823
  672840
  673647
  676191
  676710
  678614
  680624
  684859
  695182
  701221
  708718
  712959
  714795
  715555
  718338
  718456
  720877
  721942
  721945
  723828
  726265
  726637
  732623
  735750
  739196
  739471
  742099
  746878
  751978
  757773
  761398
  761895
  763733
  768150
  770374
  771490
  773267
  773928
  774037
  776737
  777217
  777909
  779330
  785679
  785824
  786414
  788274
  791424
  794144
  795985
  796824
  799874
  799983
  800935
  802577
  802757
  803806
  805056
  805145
  812785
  817247
  818835
  821497
]
13.71 ms
(9.54%)
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
  779330
  785679
  796824
  802577
  802757
  805145
  776737
  777217
  786414
  788274
  795985
  800935
  803806
  812785
  723828
  739471
  742099
  763733
  773267
  773928
  791424
  794144
  746878
  761895
  726265
  735750
  751978
  757773
  768150
  773429
  761398
  770374
  771490
  774037
  726637
  732623
  739196
  604474
  629260
  714795
  715555
  718338
  718456
  777909
  785824
  799874
  799983
  805056
  4349
  383549
  443950
  471570
  395504
  398830
  469126
  386297
  403268
  395317
  398128
  399048
  509549
  384270
  386879
  397072
  418739
  817247
  818835
  821497
  451090
  474412
  452175
  457749
  500182
  505290
  518904
  525414
  476633
  558211
  559851
  579838
  543367
  543740
  566197
  559907
  661899
  676191
  680624
  684859
  701221
  651102
  653148
  654274
  660687
  663823
  672840
  676710
  695182
  720877
  646395
  651294
  673647
  678614
  708718
  712959
  721942
  721945
  555822
  557847
  592145
  595003
  607017
  617956
  641479
  641487
  614985
  633917
  595004
  610138
  637229
  643582
]
2.58 ms
(1.79%)
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
  4349
  383549
  384270
  386297
  386879
  395317
  395504
  397072
  398128
  398830
  399048
  403268
  418739
  443950
  451090
  452175
  457749
  469126
  471570
  474412
  476633
  500182
  505290
  509549
  518904
  525414
  543367
  543740
  555822
  557847
  558211
  559851
  559907
  566197
  579838
  592145
  595003
  595004
  604474
  607017
  610138
  614985
  617956
  629260
  633917
  637229
  641479
  641487
  643582
  646395
  651102
  651294
  653148
  654274
  660687
  661899
  663823
  672840
  673647
  676191
  676710
  678614
  680624
  684859
  695182
  701221
  708718
  712959
  714795
  715555
  718338
  718456
  720877
  721942
  721945
  723828
  726265
  726637
  732623
  735750
  739196
  739471
  742099
  746878
  751978
  757773
  761398
  761895
  763733
  768150
  770374
  771490
  773267
  773928
  774037
  776737
  777217
  777909
  779330
  785679
  785824
  786414
  788274
  791424
  794144
  795985
  796824
  799874
  799983
  800935
  802577
  802757
  803806
  805056
  805145
  812785
  817247
  818835
  821497
]
2.19 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx hotel"
]
1.90 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx hotel"
]
1.88 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx hotel"
]
1.84 ms
(1.28%)
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.