GET https://search.jues.net/search/embeds/5?q=pissing%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.87 ms
(60.13%)
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
  459638
  520879
  541750
  541788
  541790
  541795
  542454
  542726
  545233
  547416
  547441
  548389
  549031
  549037
  554683
  554686
  554707
  554712
  554841
  554843
  555217
  555315
  555780
  558623
  562111
  576506
  577026
  577034
  581550
  582998
  585350
  585802
  588391
  597099
  607503
  613958
  614201
  614330
  620911
  623343
  629671
  630821
  630963
  631879
  633715
  636607
  636644
  643689
  643706
  644663
  651784
  664602
  666031
  675261
  691337
  700893
  707236
  707971
  710786
  715073
  718383
  719829
  724731
  725189
  725483
  726636
  726802
  728518
  728616
  730997
  731022
  734706
  734827
  735828
  737598
  741761
  743993
  744167
  744765
  744835
  746646
  751384
  751390
  757217
  757230
  757237
  771272
  778686
  781358
  783308
  783930
  785114
  788112
  789616
  790102
  795004
  795924
  795951
  795974
  795990
  796338
  796635
  797215
  797255
  802194
  804416
  804428
  810075
  810079
  810083
  811844
  811852
  811873
  811902
  811905
  813174
  824196
  827190
  827278
  828592
]
123.24 ms
(34.65%)
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
  459638
  520879
  541750
  541788
  541790
  541795
  542454
  542726
  545233
  547416
  547441
  548389
  549031
  549037
  554683
  554686
  554707
  554712
  554841
  554843
  555217
  555315
  555780
  558623
  562111
  576506
  577026
  577034
  581550
  582998
  585350
  585802
  588391
  597099
  607503
  613958
  614201
  614330
  620911
  623343
  629671
  630821
  630963
  631879
  633715
  636607
  636644
  643689
  643706
  644663
  651784
  664602
  666031
  675261
  691337
  700893
  707236
  707971
  710786
  715073
  718383
  719829
  724731
  725189
  725483
  726636
  726802
  728518
  728616
  730997
  731022
  734706
  734827
  735828
  737598
  741761
  743993
  744167
  744765
  744835
  746646
  751384
  751390
  757217
  757230
  757237
  771272
  778686
  781358
  783308
  783930
  785114
  788112
  789616
  790102
  795004
  795924
  795951
  795974
  795990
  796338
  796635
  797215
  797255
  802194
  804416
  804428
  810075
  810079
  810083
  811844
  811852
  811873
  811902
  811905
  813174
  824196
  827190
  827278
  828592
]
12.07 ms
(3.39%)
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
  710786
  547441
  554686
  554712
  585802
  614201
  631879
  633715
  620911
  623343
  629671
  636607
  636644
  643689
  643706
  588391
  613958
  614330
  785114
  795990
  789616
  790102
  802194
  725189
  725483
  743993
  744167
  757230
  795004
  810079
  810083
  811873
  724731
  730997
  734706
  735828
  744765
  744835
  771272
  726802
  728518
  728616
  746646
  751390
  783930
  795951
  795974
  796635
  804428
  810075
  811844
  582998
  737598
  781358
  828592
  757237
  824196
  827190
  827278
  459638
  520879
  541750
  541790
  548389
  549037
  554707
  562111
  576506
  577026
  541788
  542454
  542726
  547416
  549031
  554841
  541795
  554683
  555315
  581550
  664602
  651784
  666031
  707236
  715073
  718383
  719829
  675261
  691337
  700893
  707971
  545233
  554843
  555217
  555780
  558623
  577034
  644663
  607503
  630821
  585350
  597099
  630963
  797215
  811902
  811905
  778686
  796338
  804416
  757217
  783308
  788112
  795924
  797255
  811852
  813174
  731022
  734827
  741761
  751384
  726636
]
1.92 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pissing wife"
]
1.66 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pissing жен"
]
1.49 ms
(0.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pissing жен"
]

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.