GET https://search.jues.net/search/embeds/5?q=xxx%20sport

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.78 ms
(83.92%)
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
  33756
  382173
  382507
  383186
  386240
  396064
  398902
  400235
  400582
  402065
  405420
  405812
  407389
  413099
  416889
  418165
  420011
  427818
  437830
  444420
  444550
  444994
  445576
  454686
  454728
  454773
  454799
  454902
  455837
  456427
  458446
  458557
  459458
  460057
  460199
  461118
  461208
  461253
  464112
  464646
  465557
  465583
  468558
  470318
  470398
  475638
  475984
  478007
  479788
  479873
  485831
  498632
  505269
  510415
  511503
  512202
  513003
  514709
  515512
  515578
  517062
  518383
  518385
  519206
  529086
  531779
  532078
  532486
  532498
  532872
  533279
  535387
  535598
  537497
  539181
  541736
  543218
  543436
  546260
  553809
  553814
  563994
  564621
  570826
  572254
  576318
  578093
  578253
  586833
  589263
  593408
  598331
  602351
  606956
  611183
  611208
  618747
  624298
  649983
  681392
  693284
  693600
  696329
  722549
  735495
  740396
  743161
  752093
  752169
  759159
  762780
  767598
  768451
  777314
  790085
  796236
  797539
  809794
  826425
  827555
]
21.64 ms
(10.76%)
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
  458446
  458557
  460057
  445576
  454773
  470398
  485831
  454728
  454902
  479873
  518383
  512202
  532498
  532872
  513003
  460199
  465557
  478007
  543218
  543436
  553814
  564621
  572254
  578093
  578253
  693284
  693600
  576318
  593408
  624298
  598331
  611208
  589263
  606956
  611183
  796236
  797539
  809794
  777314
  743161
  762780
  768451
  767598
  602351
  722549
  386240
  400235
  405812
  464112
  402065
  420011
  459458
  461208
  461253
  475638
  396064
  398902
  413099
  416889
  400582
  405420
  407389
  427818
  444420
  444550
  454686
  454799
  464646
  465583
  470318
  461118
  468558
  518385
  498632
  519206
  532486
  510415
  515512
  517062
  529086
  505269
  535387
  541736
  383186
  33756
  826425
  827555
  535598
  553809
  696329
  681392
  618747
  740396
  759159
  752169
  456427
  455837
  514709
  515578
  479788
  444994
  418165
  437830
  475984
  511503
  382173
  531779
  537497
  532078
  533279
  539181
  563994
  649983
  546260
  570826
  586833
  790085
  735495
  752093
  382507
]
3.55 ms
(1.77%)
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
  33756
  382173
  382507
  383186
  386240
  396064
  398902
  400235
  400582
  402065
  405420
  405812
  407389
  413099
  416889
  418165
  420011
  427818
  437830
  444420
  444550
  444994
  445576
  454686
  454728
  454773
  454799
  454902
  455837
  456427
  458446
  458557
  459458
  460057
  460199
  461118
  461208
  461253
  464112
  464646
  465557
  465583
  468558
  470318
  470398
  475638
  475984
  478007
  479788
  479873
  485831
  498632
  505269
  510415
  511503
  512202
  513003
  514709
  515512
  515578
  517062
  518383
  518385
  519206
  529086
  531779
  532078
  532486
  532498
  532872
  533279
  535387
  535598
  537497
  539181
  541736
  543218
  543436
  546260
  553809
  553814
  563994
  564621
  570826
  572254
  576318
  578093
  578253
  586833
  589263
  593408
  598331
  602351
  606956
  611183
  611208
  618747
  624298
  649983
  681392
  693284
  693600
  696329
  722549
  735495
  740396
  743161
  752093
  752169
  759159
  762780
  767598
  768451
  777314
  790085
  796236
  797539
  809794
  826425
  827555
]
2.12 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.09 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx sport"
]
1.55 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx спортивная"
]
1.39 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx спортивная"
]

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.