GET https://search.jues.net/search/embeds/3?q=girls%20on%20top

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.31 ms
(82.75%)
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
  387047
  398447
  406332
  413569
  421033
  423425
  425675
  426877
  432334
  435689
  448060
  449647
  451816
  454349
  457045
  460058
  462859
  463828
  466664
  469824
  475381
  477608
  478850
  484483
  489042
  493845
  500016
  502293
  506299
  506357
  507169
  512181
  513300
  516409
  518491
  519215
  519325
  520329
  523342
  523433
  524530
  525398
  525440
  532981
  534673
  536586
  537929
  545860
  548046
  553951
  554415
  555168
  556006
  557605
  557812
  559771
  564212
  568457
  568463
  569041
  570830
  570832
  574511
  577301
  582687
  582920
  585123
  586556
  587381
  588204
  595549
  596346
  597753
  598207
  599040
  599520
  601472
  601859
  603384
  604821
  609370
  613333
  620512
  620670
  621179
  622405
  625378
  625446
  626189
  626482
  633461
  637009
  637025
  652125
  660405
  666016
  666459
  669079
  676887
  677082
  686106
  693316
  695870
  701231
  706945
  707470
  724934
  729328
  740212
  740226
  747249
  758797
  760683
  780517
  785384
  796831
  807711
  808497
  809574
  815383
]
15.41 ms
(10.51%)
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
  534673
  693316
  701231
  570832
  620670
  596346
  604821
  613333
  729328
  747249
  760683
  785384
  808497
  413569
  449647
  513300
  523433
  502293
  545860
  398447
  570830
  577301
  660405
  666016
  677082
  686106
  588204
  601472
  626189
  454349
  448060
  460058
  489042
  506357
  387047
  463828
  707470
  666459
  626482
  587381
  595549
  609370
  620512
  758797
  423425
  425675
  426877
  477608
  493845
  520329
  807711
  809574
  421033
  469824
  554415
  599040
  724934
  525440
  466664
  582687
  695870
  599520
  432334
  506299
  523342
  564212
  676887
  568463
  601859
  796831
  740226
  780517
  478850
  475381
  559771
  706945
  637025
  574511
  548046
  598207
  622405
  462859
  500016
  815383
  516409
  557605
  557812
  582920
  633461
  597753
  740212
  625446
  406332
  457045
  569041
  669079
  435689
  585123
  518491
  532981
  555168
  586556
  603384
  652125
  568457
  512181
  553951
  621179
  451816
  519215
  537929
  637009
  519325
  507169
  536586
  556006
  625378
  484483
  524530
  525398
]
2.78 ms
(1.90%)
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
  387047
  398447
  406332
  413569
  421033
  423425
  425675
  426877
  432334
  435689
  448060
  449647
  451816
  454349
  457045
  460058
  462859
  463828
  466664
  469824
  475381
  477608
  478850
  484483
  489042
  493845
  500016
  502293
  506299
  506357
  507169
  512181
  513300
  516409
  518491
  519215
  519325
  520329
  523342
  523433
  524530
  525398
  525440
  532981
  534673
  536586
  537929
  545860
  548046
  553951
  554415
  555168
  556006
  557605
  557812
  559771
  564212
  568457
  568463
  569041
  570830
  570832
  574511
  577301
  582687
  582920
  585123
  586556
  587381
  588204
  595549
  596346
  597753
  598207
  599040
  599520
  601472
  601859
  603384
  604821
  609370
  613333
  620512
  620670
  621179
  622405
  625378
  625446
  626189
  626482
  633461
  637009
  637025
  652125
  660405
  666016
  666459
  669079
  676887
  677082
  686106
  693316
  695870
  701231
  706945
  707470
  724934
  729328
  740212
  740226
  747249
  758797
  760683
  780517
  785384
  796831
  807711
  808497
  809574
  815383
]
2.24 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls on top"
]
1.80 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк top"
]
1.62 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк top"
]

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.