GET https://search.jues.net/search/embeds/7?q=kissing%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.70 ms
(85.26%)
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
  3335
  66792
  148176
  169326
  181441
  309171
  382318
  384845
  385260
  386807
  390346
  458740
  477752
  477767
  512644
  523945
  532050
  533410
  534175
  537727
  540088
  544332
  544355
  545663
  549351
  549414
  551712
  552196
  558423
  572430
  573606
  573631
  578104
  584651
  605543
  609089
  613989
  620175
  625408
  647453
  647759
  652905
  653514
  653530
  654329
  657101
  663430
  665482
  667885
  669210
  670814
  681816
  681937
  682256
  684203
  685515
  691444
  692822
  706256
  709321
  709703
  716576
  717109
  717368
  719134
  719138
  723487
  727494
  730621
  730681
  730944
  731952
  735158
  741907
  742213
  742652
  745774
  746978
  747588
  747993
  750016
  750841
  752936
  768074
  768301
  770596
  773179
  774280
  778747
  783155
  786204
  786386
  788689
  789527
  791204
  794451
  795263
  795279
  798984
  801582
  802874
  810641
  813910
  817330
  817817
  818416
  818790
  818856
  818858
  820375
  820691
  823167
  823257
  823918
  824219
  825188
  826062
  826438
  827407
  828824
]
12.17 ms
(8.00%)
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
  532050
  552196
  572430
  584651
  717109
  667885
  684203
  709703
  573631
  625408
  605543
  730681
  746978
  66792
  533410
  534175
  545663
  558423
  549351
  544332
  544355
  573606
  647759
  652905
  665482
  669210
  691444
  717368
  719138
  723487
  670814
  682256
  709321
  647453
  653514
  654329
  657101
  681816
  685515
  692822
  706256
  609089
  620175
  613989
  778747
  786204
  791204
  794451
  798984
  786386
  789527
  742652
  747588
  750841
  773179
  783155
  788689
  801582
  802874
  730944
  731952
  745774
  768301
  774280
  727494
  742213
  747993
  752936
  730621
  741907
  750016
  768074
  735158
  770596
  716576
  719134
  795263
  795279
  810641
  309171
  390346
  382318
  458740
  477752
  512644
  385260
  386807
  384845
  181441
  148176
  169326
  3335
  813910
  826062
  824219
  818416
  818790
  820691
  823257
  820375
  823167
  826438
  817330
  817817
  818856
  818858
  825188
  827407
  828824
  823918
  537727
  523945
  540088
  477767
  551712
  549414
  578104
  653530
  663430
  681937
]
3.08 ms
(2.02%)
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
  3335
  66792
  148176
  169326
  181441
  309171
  382318
  384845
  385260
  386807
  390346
  458740
  477752
  477767
  512644
  523945
  532050
  533410
  534175
  537727
  540088
  544332
  544355
  545663
  549351
  549414
  551712
  552196
  558423
  572430
  573606
  573631
  578104
  584651
  605543
  609089
  613989
  620175
  625408
  647453
  647759
  652905
  653514
  653530
  654329
  657101
  663430
  665482
  667885
  669210
  670814
  681816
  681937
  682256
  684203
  685515
  691444
  692822
  706256
  709321
  709703
  716576
  717109
  717368
  719134
  719138
  723487
  727494
  730621
  730681
  730944
  731952
  735158
  741907
  742213
  742652
  745774
  746978
  747588
  747993
  750016
  750841
  752936
  768074
  768301
  770596
  773179
  774280
  778747
  783155
  786204
  786386
  788689
  789527
  791204
  794451
  795263
  795279
  798984
  801582
  802874
  810641
  813910
  817330
  817817
  818416
  818790
  818856
  818858
  820375
  820691
  823167
  823257
  823918
  824219
  825188
  826062
  826438
  827407
  828824
]
1.99 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kissing girl"
]
1.81 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "kissing девушк"
]
1.62 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "kissing девушк"
]

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.