GET https://search.jues.net/search/embeds/3?q=hard%20threesome

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.19 ms
(83.27%)
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
  7981
  95673
  96371
  191048
  387544
  393724
  399568
  400162
  400932
  407895
  411688
  414723
  419932
  421201
  421204
  425281
  425332
  426009
  426547
  428406
  434456
  438001
  445681
  447265
  448383
  448992
  451576
  454364
  461090
  461903
  463082
  463941
  464732
  465509
  466369
  466573
  471678
  471722
  473782
  474706
  474923
  475911
  475915
  478779
  478787
  480709
  483212
  487150
  491169
  493260
  495014
  495738
  495877
  495890
  499498
  506557
  506827
  508468
  510821
  517556
  519962
  521977
  531908
  533848
  533851
  535269
  536681
  538242
  542751
  545586
  548606
  548751
  557540
  562037
  564668
  565251
  565355
  566375
  566439
  570644
  573263
  581350
  590560
  593238
  601651
  614344
  616617
  621647
  631919
  632020
  632021
  633744
  637007
  640802
  665139
  674129
  682839
  683438
  685718
  690785
  713262
  720271
  721109
  722900
  728441
  729618
  733854
  741542
  790397
  797541
  799971
  807141
  808077
  809466
  810826
  814392
  814511
  818439
  821605
  827854
]
22.51 ms
(11.56%)
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
  810826
  733854
  721109
  399568
  425281
  818439
  493260
  685718
  632021
  799971
  729618
  400162
  421204
  495877
  400932
  411688
  814511
  682839
  570644
  807141
  728441
  7981
  521977
  545586
  191048
  387544
  533851
  674129
  713262
  474923
  564668
  508468
  448992
  438001
  426009
  517556
  447265
  590560
  827854
  741542
  495738
  566375
  506557
  531908
  814392
  461090
  475915
  478779
  720271
  690785
  722900
  614344
  448383
  471722
  96371
  419932
  473782
  535269
  461903
  466573
  665139
  565251
  601651
  790397
  475911
  428406
  95673
  421201
  538242
  533848
  562037
  621647
  637007
  809466
  797541
  808077
  451576
  478787
  495890
  573263
  565355
  631919
  426547
  510821
  445681
  463082
  474706
  499498
  454364
  632020
  566439
  495014
  425332
  414723
  640802
  465509
  434456
  593238
  633744
  480709
  557540
  616617
  407895
  491169
  821605
  536681
  519962
  548751
  683438
  463941
  464732
  483212
  471678
  548606
  581350
  542751
  466369
  393724
  487150
  506827
]
2.65 ms
(1.36%)
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
  7981
  95673
  96371
  191048
  387544
  393724
  399568
  400162
  400932
  407895
  411688
  414723
  419932
  421201
  421204
  425281
  425332
  426009
  426547
  428406
  434456
  438001
  445681
  447265
  448383
  448992
  451576
  454364
  461090
  461903
  463082
  463941
  464732
  465509
  466369
  466573
  471678
  471722
  473782
  474706
  474923
  475911
  475915
  478779
  478787
  480709
  483212
  487150
  491169
  493260
  495014
  495738
  495877
  495890
  499498
  506557
  506827
  508468
  510821
  517556
  519962
  521977
  531908
  533848
  533851
  535269
  536681
  538242
  542751
  545586
  548606
  548751
  557540
  562037
  564668
  565251
  565355
  566375
  566439
  570644
  573263
  581350
  590560
  593238
  601651
  614344
  616617
  621647
  631919
  632020
  632021
  633744
  637007
  640802
  665139
  674129
  682839
  683438
  685718
  690785
  713262
  720271
  721109
  722900
  728441
  729618
  733854
  741542
  790397
  797541
  799971
  807141
  808077
  809466
  810826
  814392
  814511
  818439
  821605
  827854
]
2.30 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard секс втро"
]
1.90 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard threesome"
]
1.63 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard секс втро"
]
1.61 ms
(0.83%)
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.