GET https://search.jues.net/search/embeds/5?q=kissing%20boy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
197.83 ms
(86.86%)
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
  7365
  21711
  29367
  56639
  187349
  203516
  210072
  260297
  312730
  336687
  381855
  381882
  381924
  382712
  388560
  388813
  391653
  398950
  398968
  400999
  401886
  403245
  406067
  411398
  411912
  415577
  427755
  427994
  429150
  429552
  430923
  431205
  436636
  439636
  443463
  443508
  443666
  443806
  446282
  453146
  454886
  463160
  465401
  465949
  467664
  468028
  468328
  473231
  473304
  473919
  475080
  476278
  478343
  484116
  484686
  485978
  487699
  488185
  490759
  491669
  492337
  493445
  505698
  505716
  508247
  510467
  510572
  510658
  511743
  512113
  512271
  512283
  517030
  518412
  520916
  521868
  523750
  524973
  534244
  538429
  538891
  555912
  559053
  559064
  562217
  563001
  563070
  565958
  566750
  569853
  570270
  573744
  573918
  583303
  600154
  616745
  659552
  663431
  664793
  676507
  702179
  706339
  725350
  726518
  726815
  727022
  730735
  743811
  775571
  792686
  794705
  801868
  803081
  803263
  805021
  807144
  807384
  812339
  818438
  818777
]
19.27 ms
(8.46%)
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
  807384
  792686
  730735
  803081
  805021
  726815
  726518
  743811
  727022
  29367
  381882
  382712
  388560
  391653
  400999
  431205
  473231
  478343
  210072
  388813
  443508
  463160
  465401
  260297
  381855
  411398
  429150
  443463
  453146
  398950
  430923
  473304
  473919
  427994
  443666
  468328
  508247
  510658
  511743
  512113
  524973
  485978
  488185
  491669
  517030
  490759
  505716
  510467
  512271
  512283
  523750
  538429
  492337
  505698
  518412
  521868
  475080
  443806
  476278
  439636
  454886
  563001
  559064
  563070
  573744
  573918
  555912
  565958
  187349
  415577
  429552
  411912
  398968
  465949
  510572
  484686
  520916
  534244
  203516
  312730
  336687
  381924
  21711
  56639
  7365
  401886
  403245
  406067
  436636
  427755
  818438
  818777
  446282
  467664
  468028
  487699
  493445
  538891
  484116
  559053
  569853
  570270
  583303
  562217
  702179
  659552
  664793
  663431
  676507
  706339
  566750
  616745
  600154
  775571
  794705
  803263
  801868
  807144
  812339
  725350
]
2.83 ms
(1.24%)
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
  7365
  21711
  29367
  56639
  187349
  203516
  210072
  260297
  312730
  336687
  381855
  381882
  381924
  382712
  388560
  388813
  391653
  398950
  398968
  400999
  401886
  403245
  406067
  411398
  411912
  415577
  427755
  427994
  429150
  429552
  430923
  431205
  436636
  439636
  443463
  443508
  443666
  443806
  446282
  453146
  454886
  463160
  465401
  465949
  467664
  468028
  468328
  473231
  473304
  473919
  475080
  476278
  478343
  484116
  484686
  485978
  487699
  488185
  490759
  491669
  492337
  493445
  505698
  505716
  508247
  510467
  510572
  510658
  511743
  512113
  512271
  512283
  517030
  518412
  520916
  521868
  523750
  524973
  534244
  538429
  538891
  555912
  559053
  559064
  562217
  563001
  563070
  565958
  566750
  569853
  570270
  573744
  573918
  583303
  600154
  616745
  659552
  663431
  664793
  676507
  702179
  706339
  725350
  726518
  726815
  727022
  730735
  743811
  775571
  792686
  794705
  801868
  803081
  803263
  805021
  807144
  807384
  812339
  818438
  818777
]
2.44 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kissing boy"
]
1.88 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "kissing парен"
]
1.75 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "kissing парен"
]
1.75 ms
(0.77%)
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.