GET https://search.jues.net/search/embeds/10?q=amateur%20hotel

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.42 ms
(83.18%)
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
  420880
  424314
  428319
  435244
  437310
  437344
  442611
  443599
  444044
  450587
  450723
  452928
  455039
  457335
  461144
  462008
  462995
  463057
  463663
  466941
  471652
  472620
  475556
  479954
  481726
  487525
  489648
  492529
  493169
  495121
  495434
  496527
  502587
  503739
  504333
  504825
  506131
  509387
  510297
  511016
  512012
  512478
  513351
  514677
  515580
  516550
  518328
  519200
  519768
  520427
  520943
  522498
  522776
  524751
  525049
  525547
  525868
  526325
  527054
  527213
  541241
  545645
  547824
  548422
  552348
  554881
  555736
  559103
  559568
  559934
  561488
  561898
  562505
  562866
  565779
  566086
  567563
  569408
  571843
  571976
  574301
  579965
  581552
  585771
  588090
  589723
  592981
  593792
  595099
  595723
  596987
  600449
  601180
  603684
  603852
  605378
  605442
  607377
  609807
  612490
  612507
  613555
  613977
  615680
  619201
  621494
  623229
  625594
  634725
  641910
  650056
  661382
  666714
  670821
  675926
  684868
  723892
  724481
  751572
  779012
]
16.96 ms
(10.58%)
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
  592981
  625594
  723892
  442611
  462008
  463057
  444044
  472620
  481726
  520943
  525868
  513351
  525547
  516550
  420880
  437310
  435244
  487525
  466941
  509387
  511016
  495121
  510297
  492529
  567563
  555736
  561898
  569408
  545645
  548422
  562505
  670821
  684868
  554881
  593792
  612490
  589723
  609807
  724481
  751572
  779012
  452928
  462995
  471652
  455039
  479954
  450587
  504333
  525049
  502587
  506131
  512012
  495434
  519768
  661382
  595099
  522776
  585771
  603684
  603852
  600449
  621494
  615680
  641910
  612507
  634725
  443599
  559568
  437344
  461144
  519200
  581552
  650056
  571976
  601180
  457335
  526325
  489648
  475556
  428319
  607377
  493169
  518328
  503739
  504825
  512478
  514677
  496527
  541241
  559103
  561488
  566086
  571843
  562866
  574301
  675926
  613555
  619201
  605378
  605442
  588090
  595723
  596987
  613977
  623229
  463663
  520427
  515580
  522498
  524751
  424314
  450723
  527213
  527054
  552348
  565779
  579965
  547824
  666714
  559934
]
2.81 ms
(1.75%)
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
  420880
  424314
  428319
  435244
  437310
  437344
  442611
  443599
  444044
  450587
  450723
  452928
  455039
  457335
  461144
  462008
  462995
  463057
  463663
  466941
  471652
  472620
  475556
  479954
  481726
  487525
  489648
  492529
  493169
  495121
  495434
  496527
  502587
  503739
  504333
  504825
  506131
  509387
  510297
  511016
  512012
  512478
  513351
  514677
  515580
  516550
  518328
  519200
  519768
  520427
  520943
  522498
  522776
  524751
  525049
  525547
  525868
  526325
  527054
  527213
  541241
  545645
  547824
  548422
  552348
  554881
  555736
  559103
  559568
  559934
  561488
  561898
  562505
  562866
  565779
  566086
  567563
  569408
  571843
  571976
  574301
  579965
  581552
  585771
  588090
  589723
  592981
  593792
  595099
  595723
  596987
  600449
  601180
  603684
  603852
  605378
  605442
  607377
  609807
  612490
  612507
  613555
  613977
  615680
  619201
  621494
  623229
  625594
  634725
  641910
  650056
  661382
  666714
  670821
  675926
  684868
  723892
  724481
  751572
  779012
]
1.91 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск hotel"
]
1.80 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск hotel"
]
1.80 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur 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.