GET https://search.jues.net/search/embeds/3?q=dildo%20compilation

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.92 ms
(83.70%)
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
  3561
  76836
  88410
  131602
  133695
  386798
  397775
  414337
  416742
  416751
  418215
  418380
  419144
  420358
  421121
  423814
  428280
  436230
  437867
  437925
  438464
  440571
  444197
  444684
  445666
  452773
  453901
  457341
  464186
  465629
  466907
  469100
  469198
  469437
  473298
  478976
  480438
  481807
  486856
  489338
  495757
  499163
  502369
  504474
  507094
  508800
  509983
  511674
  512975
  516035
  518622
  521481
  526501
  529003
  530021
  531866
  532576
  533030
  534257
  537091
  552069
  554889
  568449
  569168
  574049
  575404
  578180
  590478
  590696
  596288
  597482
  598310
  601026
  602614
  613000
  618256
  636236
  639108
  640222
  650408
  651601
  696594
  696597
  707361
  710918
  710945
  716695
  722388
  728469
  730415
  730860
  735977
  737473
  740409
  750067
  752275
  756212
  757484
  759345
  764556
  765479
  765668
  776398
  777688
  783460
  784149
  785069
  785470
  786876
  788463
  790219
  793520
  796372
  796659
  798685
  798706
  800658
  802600
  803129
  803393
]
13.26 ms
(8.89%)
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
  502369
  419144
  504474
  445666
  531866
  784149
  416742
  508800
  552069
  710945
  803393
  735977
  750067
  76836
  788463
  757484
  133695
  469437
  530021
  534257
  554889
  568449
  696594
  596288
  613000
  597482
  598310
  796372
  800658
  737473
  740409
  722388
  480438
  416751
  452773
  414337
  473298
  418380
  437925
  507094
  526501
  532576
  574049
  777688
  776398
  783460
  765479
  765668
  636236
  785470
  418215
  486856
  464186
  478976
  793520
  88410
  444197
  469198
  710918
  707361
  785069
  802600
  489338
  511674
  512975
  602614
  509983
  386798
  575404
  569168
  651601
  3561
  529003
  590478
  436230
  420358
  518622
  421121
  730415
  516035
  423814
  444684
  537091
  696597
  639108
  590696
  798685
  728469
  618256
  786876
  790219
  533030
  521481
  131602
  397775
  465629
  716695
  650408
  601026
  798706
  764556
  796659
  730860
  759345
  752275
  438464
  428280
  437867
  466907
  495757
  499163
  578180
  640222
  803129
  756212
  440571
  453901
  469100
  481807
  457341
]
3.11 ms
(2.08%)
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
  3561
  76836
  88410
  131602
  133695
  386798
  397775
  414337
  416742
  416751
  418215
  418380
  419144
  420358
  421121
  423814
  428280
  436230
  437867
  437925
  438464
  440571
  444197
  444684
  445666
  452773
  453901
  457341
  464186
  465629
  466907
  469100
  469198
  469437
  473298
  478976
  480438
  481807
  486856
  489338
  495757
  499163
  502369
  504474
  507094
  508800
  509983
  511674
  512975
  516035
  518622
  521481
  526501
  529003
  530021
  531866
  532576
  533030
  534257
  537091
  552069
  554889
  568449
  569168
  574049
  575404
  578180
  590478
  590696
  596288
  597482
  598310
  601026
  602614
  613000
  618256
  636236
  639108
  640222
  650408
  651601
  696594
  696597
  707361
  710918
  710945
  716695
  722388
  728469
  730415
  730860
  735977
  737473
  740409
  750067
  752275
  756212
  757484
  759345
  764556
  765479
  765668
  776398
  777688
  783460
  784149
  785069
  785470
  786876
  788463
  790219
  793520
  796372
  796659
  798685
  798706
  800658
  802600
  803129
  803393
]
2.24 ms
(1.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.20 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo compilation"
]
1.85 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд подборк"
]
1.66 ms
(1.11%)
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.