GET https://search.jues.net/search/embeds/6?q=amateur%20facesitting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
180.13 ms
(88.04%)
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
  389757
  401821
  402719
  410855
  412548
  415829
  417065
  417548
  421122
  421779
  423864
  429728
  439899
  440664
  443604
  443925
  448044
  449424
  453220
  454299
  457909
  461162
  462597
  462895
  464763
  466027
  466123
  466879
  469935
  471653
  474030
  475859
  483943
  484451
  489847
  490236
  499387
  503789
  511633
  522296
  523048
  528847
  542449
  544523
  553257
  554796
  555335
  559373
  560302
  562816
  574083
  577901
  578430
  578701
  579202
  581501
  582238
  584705
  584987
  585734
  590205
  592596
  592636
  593626
  594420
  595357
  595938
  598909
  600651
  609370
  612429
  612534
  619271
  619705
  621337
  631975
  632037
  634826
  636111
  649208
  663568
  675677
  675923
  675968
  675971
  675995
  676402
  677587
  682902
  683428
  693576
  703212
  710096
  712466
  724410
  730396
  734466
  750729
  761668
  767281
  769518
  771576
  771682
  772959
  776138
  777257
  778681
  779194
  784925
  786153
  793629
  797195
  798075
  807439
  810574
  812298
  813492
  814399
  824411
  826278
]
14.70 ms
(7.18%)
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
  464763
  649208
  677587
  710096
  712466
  675968
  675995
  693576
  675923
  675971
  676402
  562816
  579202
  585734
  619271
  621337
  631975
  634826
  776138
  779194
  786153
  797195
  807439
  734466
  767281
  784925
  798075
  812298
  771682
  730396
  750729
  772959
  761668
  769518
  771576
  612429
  778681
  793629
  813492
  462895
  462597
  466123
  423864
  439899
  522296
  511633
  448044
  810574
  402719
  421122
  469935
  574083
  389757
  577901
  417548
  429728
  440664
  814399
  471653
  560302
  592636
  777257
  724410
  412548
  457909
  499387
  415829
  417065
  449424
  484451
  489847
  503789
  582238
  675677
  682902
  663568
  683428
  703212
  555335
  619705
  636111
  592596
  598909
  600651
  612534
  595938
  594420
  609370
  632037
  474030
  466879
  581501
  595357
  593626
  590205
  443925
  401821
  443604
  410855
  421779
  824411
  584987
  826278
  454299
  483943
  453220
  466027
  490236
  523048
  528847
  461162
  475859
  578701
  584705
  554796
  542449
  544523
  553257
  559373
  578430
]
2.70 ms
(1.32%)
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
  389757
  401821
  402719
  410855
  412548
  415829
  417065
  417548
  421122
  421779
  423864
  429728
  439899
  440664
  443604
  443925
  448044
  449424
  453220
  454299
  457909
  461162
  462597
  462895
  464763
  466027
  466123
  466879
  469935
  471653
  474030
  475859
  483943
  484451
  489847
  490236
  499387
  503789
  511633
  522296
  523048
  528847
  542449
  544523
  553257
  554796
  555335
  559373
  560302
  562816
  574083
  577901
  578430
  578701
  579202
  581501
  582238
  584705
  584987
  585734
  590205
  592596
  592636
  593626
  594420
  595357
  595938
  598909
  600651
  609370
  612429
  612534
  619271
  619705
  621337
  631975
  632037
  634826
  636111
  649208
  663568
  675677
  675923
  675968
  675971
  675995
  676402
  677587
  682902
  683428
  693576
  703212
  710096
  712466
  724410
  730396
  734466
  750729
  761668
  767281
  769518
  771576
  771682
  772959
  776138
  777257
  778681
  779194
  784925
  786153
  793629
  797195
  798075
  807439
  810574
  812298
  813492
  814399
  824411
  826278
]
2.03 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur facesitting"
]
1.87 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск фейсситтинг"
]
1.66 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.