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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.15 ms
(86.05%)
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
  387579
  388175
  395317
  398128
  408701
  418739
  424937
  431381
  436732
  442928
  443950
  444163
  444582
  444608
  451009
  451090
  452175
  454431
  469126
  474412
  476633
  481379
  481587
  482007
  489273
  496743
  518904
  520207
  525412
  525414
  527154
  543367
  545453
  551908
  553937
  557539
  557847
  566197
  566662
  578705
  579838
  585393
  586050
  588132
  589677
  595004
  598966
  600406
  607017
  610138
  612403
  614985
  617956
  626561
  629831
  633839
  637203
  637229
  641487
  649212
  651102
  653148
  661899
  672840
  673647
  676710
  684859
  695773
  697390
  703218
  708280
  708621
  709623
  712298
  714795
  714892
  715555
  716111
  718448
  718733
  720877
  721122
  721896
  726265
  731389
  732148
  732567
  733273
  733512
  735750
  746878
  751978
  759325
  761398
  768150
  771609
  773267
  773928
  774037
  776737
  776840
  777217
  777909
  783465
  784767
  786414
  788274
  793835
  796143
  796825
  799657
  799983
  800935
  802063
  803806
  804326
  812662
  812785
]
13.34 ms
(8.08%)
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
  398128
  793835
  452175
  731389
  482007
  759325
  388175
  804326
  387579
  431381
  637203
  451009
  481587
  527154
  520207
  551908
  649212
  695773
  708621
  712298
  714892
  718448
  718733
  721896
  703218
  708280
  709623
  721122
  697390
  716111
  626561
  585393
  776737
  777217
  786414
  788274
  800935
  803806
  812785
  773267
  773928
  746878
  726265
  735750
  751978
  768150
  761398
  774037
  714795
  715555
  777909
  799983
  443950
  469126
  395317
  673647
  637229
  796825
  799657
  436732
  444582
  588132
  586050
  481379
  629831
  454431
  553937
  489273
  545453
  566662
  444608
  418739
  451090
  474412
  518904
  525414
  476633
  579838
  543367
  566197
  661899
  684859
  651102
  653148
  672840
  676710
  720877
  557847
  607017
  617956
  641487
  614985
  595004
  610138
  598966
  776840
  784767
  802063
  812662
  733512
  732148
  733273
  738586
  612403
  633839
  783465
  424937
  557539
  589677
  600406
  607290
  771609
  525412
  578705
  796143
  442928
  444163
  496743
  732567
  408701
]
3.06 ms
(1.85%)
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
  387579
  388175
  395317
  398128
  408701
  418739
  424937
  431381
  436732
  442928
  443950
  444163
  444582
  444608
  451009
  451090
  452175
  454431
  469126
  474412
  476633
  481379
  481587
  482007
  489273
  496743
  518904
  520207
  525412
  525414
  527154
  543367
  545453
  551908
  553937
  557539
  557847
  566197
  566662
  578705
  579838
  585393
  586050
  588132
  589677
  595004
  598966
  600406
  607017
  610138
  612403
  614985
  617956
  626561
  629831
  633839
  637203
  637229
  641487
  649212
  651102
  653148
  661899
  672840
  673647
  676710
  684859
  695773
  697390
  703218
  708280
  708621
  709623
  712298
  714795
  714892
  715555
  716111
  718448
  718733
  720877
  721122
  721896
  726265
  731389
  732148
  732567
  733273
  733512
  735750
  746878
  751978
  759325
  761398
  768150
  771609
  773267
  773928
  774037
  776737
  776840
  777217
  777909
  783465
  784767
  786414
  788274
  793835
  796143
  796825
  799657
  799983
  800935
  802063
  803806
  804326
  812662
  812785
]
1.81 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hotel большая большие жоп"
]
1.75 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hotel big ass"
]
1.69 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.86%)
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.