GET https://search.jues.net/search/embeds/9?q=threesome%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.83 ms
(85.31%)
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
  14389
  61168
  81637
  210661
  223442
  239112
  311853
  339474
  381811
  381924
  385304
  387186
  388919
  392967
  395999
  396542
  396989
  400138
  402373
  408558
  431730
  452444
  457789
  475187
  476426
  486589
  488560
  490060
  495738
  504252
  504279
  507309
  511011
  519242
  522532
  536211
  543376
  544713
  547983
  548788
  549273
  549307
  549884
  554841
  557937
  557951
  563407
  563448
  567997
  568480
  569134
  577931
  579598
  582972
  583715
  604555
  607113
  622201
  632010
  633118
  645493
  645749
  648984
  649112
  649127
  650833
  653712
  661289
  662966
  663946
  665406
  667075
  670488
  671000
  671747
  672184
  679067
  680587
  681682
  686021
  690000
  692457
  693164
  697705
  716017
  718976
  742604
  742906
  745311
  746589
  747145
  756054
  760774
  760834
  771358
  775909
  778372
  782755
  783790
  784224
  784442
  786039
  787757
  787912
  790654
  797164
  805705
  807192
  812293
  812300
  816922
  817748
  818447
  820032
  823252
  825894
  826230
  827416
  828299
]
18.84 ms
(10.06%)
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
  718976
  782755
  805705
  756054
  667075
  339474
  823252
  828299
  536211
  475187
  544713
  563407
  579598
  583715
  547983
  549273
  554841
  645749
  662966
  690000
  697705
  549884
  633118
  775909
  812293
  784224
  787757
  812300
  760774
  765461
  771358
  745311
  746589
  81637
  388919
  486589
  507309
  504252
  476426
  519242
  604555
  488560
  567997
  563448
  607113
  511011
  557937
  650833
  522532
  582972
  820032
  649112
  742604
  387186
  385304
  381811
  381924
  223442
  816922
  679067
  680587
  693164
  670488
  681682
  671747
  783790
  786039
  790654
  787912
  742906
  760834
  61168
  210661
  396989
  14389
  817748
  818447
  827416
  653712
  671000
  692457
  645493
  648984
  649127
  661289
  663946
  665406
  622201
  784442
  797164
  311853
  239112
  747145
  778372
  402373
  825894
  826230
  549307
  716017
  490060
  495738
  543376
  577931
  568480
  632010
  504279
  457789
  431730
  548788
  569134
  400138
  408558
  452444
  557951
  392967
  395999
  672184
  686021
  807192
  396542
]
2.05 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome sex"
]
2.05 ms
(1.09%)
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
  14389
  61168
  81637
  210661
  223442
  239112
  311853
  339474
  381811
  381924
  385304
  387186
  388919
  392967
  395999
  396542
  396989
  400138
  402373
  408558
  431730
  452444
  457789
  475187
  476426
  486589
  488560
  490060
  495738
  504252
  504279
  507309
  511011
  519242
  522532
  536211
  543376
  544713
  547983
  548788
  549273
  549307
  549884
  554841
  557937
  557951
  563407
  563448
  567997
  568480
  569134
  577931
  579598
  582972
  583715
  604555
  607113
  622201
  632010
  633118
  645493
  645749
  648984
  649112
  649127
  650833
  653712
  661289
  662966
  663946
  665406
  667075
  670488
  671000
  671747
  672184
  679067
  680587
  681682
  686021
  690000
  692457
  693164
  697705
  716017
  718976
  742604
  742906
  745311
  746589
  747145
  756054
  760774
  760834
  771358
  775909
  778372
  782755
  783790
  784224
  784442
  786039
  787757
  787912
  790654
  797164
  805705
  807192
  812293
  812300
  816922
  817748
  818447
  820032
  823252
  825894
  826230
  827416
  828299
]
1.62 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро секс"
]
1.49 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро секс"
]
1.48 ms
(0.79%)
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.