GET https://search.jues.net/search/embeds/5?q=amateur%20doggystyle

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.25 ms
(87.78%)
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
  400955
  426778
  455271
  460700
  460895
  467659
  468151
  468345
  480077
  485826
  487646
  494548
  495822
  497903
  507361
  509365
  510928
  522516
  530300
  539930
  542169
  542297
  545114
  546527
  558533
  559237
  564998
  568184
  577267
  580356
  582428
  588531
  589383
  592149
  609634
  615272
  618494
  620828
  625360
  631113
  632216
  633856
  635860
  636050
  636505
  640319
  641012
  647511
  647809
  650681
  654286
  666041
  666069
  666468
  668544
  672820
  676196
  682399
  683407
  685400
  687355
  691432
  695705
  697219
  702280
  703325
  706531
  709872
  710261
  710671
  711570
  712846
  713473
  716657
  720015
  725779
  728712
  731573
  733041
  736444
  742312
  751742
  755577
  758687
  759913
  760574
  762793
  766659
  775374
  778482
  779317
  779513
  784078
  786916
  788188
  790490
  791246
  791530
  793184
  794897
  796714
  797005
  797348
  797424
  797483
  797840
  799877
  803926
  808252
  809826
  809851
  810040
  813646
  819177
  819208
  819779
  820099
  820378
  825865
  828110
]
10.45 ms
(6.54%)
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
  728712
  731573
  760574
  766659
  790490
  794897
  797005
  426778
  828110
  733041
  539930
  647809
  666041
  558533
  706531
  819779
  825865
  819177
  813646
  819208
  820099
  468151
  468345
  510928
  497903
  712846
  716657
  720015
  786916
  791530
  796714
  799877
  809851
  778482
  779513
  793184
  797348
  809826
  810040
  736444
  742312
  788188
  803926
  751742
  755577
  758687
  762793
  725779
  775374
  784078
  797424
  797483
  797840
  808252
  460700
  460895
  487646
  507361
  509365
  494548
  495822
  530300
  542297
  546527
  564998
  542169
  559237
  582428
  545114
  568184
  580356
  650681
  668544
  672820
  683407
  685400
  695705
  647511
  666069
  687355
  702280
  703325
  710261
  710671
  711570
  654286
  666468
  676196
  691432
  592149
  620828
  625360
  636050
  640319
  588531
  631113
  633856
  636505
  641012
  779317
  609634
  615272
  632216
  635860
  697219
  709872
  713473
  522516
  682399
  577267
  589383
  618494
  791246
  759913
  467659
  400955
  820378
  480077
  455271
  485826
]
2.64 ms
(1.65%)
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
  400955
  426778
  455271
  460700
  460895
  467659
  468151
  468345
  480077
  485826
  487646
  494548
  495822
  497903
  507361
  509365
  510928
  522516
  530300
  539930
  542169
  542297
  545114
  546527
  558533
  559237
  564998
  568184
  577267
  580356
  582428
  588531
  589383
  592149
  609634
  615272
  618494
  620828
  625360
  631113
  632216
  633856
  635860
  636050
  636505
  640319
  641012
  647511
  647809
  650681
  654286
  666041
  666069
  666468
  668544
  672820
  676196
  682399
  683407
  685400
  687355
  691432
  695705
  697219
  702280
  703325
  706531
  709872
  710261
  710671
  711570
  712846
  713473
  716657
  720015
  725779
  728712
  731573
  733041
  736444
  742312
  751742
  755577
  758687
  759913
  760574
  762793
  766659
  775374
  778482
  779317
  779513
  784078
  786916
  788188
  790490
  791246
  791530
  793184
  794897
  796714
  797005
  797348
  797424
  797483
  797840
  799877
  803926
  808252
  809826
  809851
  810040
  813646
  819177
  819208
  819779
  820099
  820378
  825865
  828110
]
1.71 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur doggystyle"
]
1.68 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск doggystyle"
]
1.55 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск doggystyle"
]
1.50 ms
(0.94%)
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.