GET https://search.jues.net/search/embeds/5?q=piss%20tits%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.08 ms
(83.45%)
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
  439798
  499904
  509554
  514240
  518581
  523641
  535443
  538854
  541699
  541844
  541888
  542456
  543022
  544366
  545337
  545480
  551059
  551535
  554711
  554826
  555186
  555616
  559111
  561488
  562049
  565571
  565997
  567277
  567457
  568777
  570735
  575411
  576509
  576719
  578642
  579707
  581972
  585331
  589240
  590344
  591487
  598099
  599940
  600171
  600206
  600218
  600252
  600332
  600340
  600995
  601517
  601583
  615605
  615714
  617129
  618622
  619091
  623178
  625696
  625801
  626760
  632595
  632694
  633780
  633819
  635224
  639735
  639741
  639751
  639767
  639823
  640762
  642018
  642774
  643122
  644941
  647837
  647860
  647994
  649543
  651079
  651090
  651599
  664166
  666472
  666549
  666584
  673588
  676623
  677892
  681251
  699397
  711283
  714658
  737438
  738564
  746686
  749087
  750549
  751715
  776822
  776940
  784254
  784308
  786608
  788789
  800492
  801348
  801968
  805292
  808579
  809292
  811366
  812279
  812326
  812934
  812979
  818906
  820778
  827080
]
18.05 ms
(10.60%)
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
  812934
  647860
  642774
  714658
  805292
  543022
  677892
  666472
  786608
  827080
  576509
  812279
  812326
  738564
  681251
  579707
  565997
  575411
  639741
  639751
  820778
  523641
  666584
  649543
  664166
  545337
  784254
  811366
  776822
  800492
  737438
  784308
  812979
  751715
  535443
  570735
  551535
  554711
  562049
  615605
  818906
  565571
  542456
  578642
  746686
  518581
  576719
  567457
  644941
  499904
  555186
  619091
  801348
  750549
  625801
  590344
  581972
  538854
  554826
  561488
  555616
  749087
  599940
  545480
  618622
  615714
  439798
  673588
  568777
  551059
  617129
  623178
  801968
  809292
  776940
  788789
  509554
  639823
  567277
  651079
  598099
  601517
  640762
  541844
  651090
  585331
  639735
  643122
  591487
  541699
  651599
  626760
  699397
  544366
  600206
  633819
  666549
  600332
  600340
  808579
  632694
  600171
  635224
  625696
  514240
  647994
  676623
  633780
  642018
  600995
  589240
  647837
  639767
  632595
  600218
  541888
  559111
  711283
  601583
  600252
]
3.16 ms
(1.86%)
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
  439798
  499904
  509554
  514240
  518581
  523641
  535443
  538854
  541699
  541844
  541888
  542456
  543022
  544366
  545337
  545480
  551059
  551535
  554711
  554826
  555186
  555616
  559111
  561488
  562049
  565571
  565997
  567277
  567457
  568777
  570735
  575411
  576509
  576719
  578642
  579707
  581972
  585331
  589240
  590344
  591487
  598099
  599940
  600171
  600206
  600218
  600252
  600332
  600340
  600995
  601517
  601583
  615605
  615714
  617129
  618622
  619091
  623178
  625696
  625801
  626760
  632595
  632694
  633780
  633819
  635224
  639735
  639741
  639751
  639767
  639823
  640762
  642018
  642774
  643122
  644941
  647837
  647860
  647994
  649543
  651079
  651090
  651599
  664166
  666472
  666549
  666584
  673588
  676623
  677892
  681251
  699397
  711283
  714658
  737438
  738564
  746686
  749087
  750549
  751715
  776822
  776940
  784254
  784308
  786608
  788789
  800492
  801348
  801968
  805292
  808579
  809292
  811366
  812279
  812326
  812934
  812979
  818906
  820778
  827080
]
1.88 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss tits milf"
]
1.77 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг сиськ milf"
]
1.72 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг сиськ milf"
]

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.