GET https://search.jues.net/search/embeds/4?q=pussy%20sexy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.08 ms
(59.04%)
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
  20617
  50537
  144252
  153922
  359075
  382272
  385750
  387186
  387245
  395670
  401582
  401886
  413560
  413792
  414220
  416402
  418803
  419095
  419661
  460614
  469753
  473055
  474347
  489102
  499177
  536359
  539808
  545524
  551619
  572796
  582648
  582654
  587058
  599199
  600795
  604619
  613945
  621875
  621995
  624207
  625300
  629072
  633075
  633289
  650037
  664512
  665966
  668330
  672534
  672547
  674524
  679370
  684847
  689482
  692756
  695113
  695552
  697618
  712817
  717667
  719262
  723713
  724399
  725129
  725353
  725381
  725487
  733098
  734353
  734778
  736446
  737533
  739762
  739959
  741212
  742274
  743914
  744556
  749015
  749577
  753333
  753699
  756202
  756223
  756538
  759595
  759711
  760549
  765363
  765411
  771491
  772359
  773745
  776011
  777790
  780680
  783290
  783348
  789477
  790815
  792430
  792788
  796576
  797254
  802043
  805040
  805108
  809956
  810974
  816083
  816132
  817645
  817766
  817796
  817934
  818936
  824394
  824636
  827958
]
122.32 ms
(34.21%)
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
  20617
  50537
  144252
  153922
  359075
  382272
  385750
  387186
  387245
  395670
  401582
  401886
  413560
  413792
  414220
  416402
  418803
  419095
  419661
  460614
  469753
  473055
  474347
  489102
  499177
  536359
  539808
  545524
  551619
  572796
  582648
  582654
  587058
  599199
  600795
  604619
  613945
  621875
  621995
  624207
  625300
  629072
  633075
  633289
  650037
  664512
  665966
  668330
  672534
  672547
  674524
  679370
  684847
  689482
  692756
  695113
  695552
  697618
  712817
  717667
  719262
  723713
  724399
  725129
  725353
  725381
  725487
  733098
  734353
  734778
  736446
  737533
  739762
  739959
  741212
  742274
  743914
  744556
  749015
  749577
  753333
  753699
  756202
  756223
  756538
  759595
  759711
  760549
  765363
  765411
  771491
  772359
  773745
  776011
  777790
  780680
  783290
  783348
  789477
  790815
  792430
  792788
  796576
  797254
  802043
  805040
  805108
  809956
  810974
  816083
  816132
  817645
  817766
  817796
  817934
  818936
  824394
  824636
  827958
]
16.61 ms
(4.65%)
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
  743914
  744556
  756538
  621995
  629072
  633075
  697618
  719262
  792788
  797254
  153922
  359075
  382272
  413792
  395670
  536359
  590749
  599199
  50537
  401886
  416402
  413560
  419661
  824394
  824636
  816083
  816132
  817766
  817796
  827958
  489102
  539808
  582648
  582654
  674524
  679370
  692756
  717667
  665966
  668330
  689482
  695113
  695552
  650037
  664512
  672534
  672547
  684847
  712817
  572796
  625300
  633289
  600795
  613945
  777790
  783290
  783348
  802043
  780680
  790815
  796576
  805040
  805108
  809956
  723713
  725353
  734353
  737533
  749015
  753699
  771491
  792430
  725381
  725487
  734778
  749577
  756202
  759595
  733098
  736446
  741212
  756223
  765363
  772359
  773745
  724399
  739762
  753333
  759711
  765411
  725129
  739959
  742274
  760549
  621875
  776011
  810974
  387186
  20617
  385750
  387245
  401582
  818936
  460614
  545524
  551619
  604619
  587058
  789477
  418803
  469753
  474347
  414220
  419095
  499177
  624207
  144252
  817645
  817934
  473055
]
2.20 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy sexy"
]
1.84 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy sexy"
]
1.76 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy sexy"
]
1.69 ms
(0.47%)
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.