GET https://search.jues.net/search/embeds/7?q=cum%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.94 ms
(86.33%)
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
  394134
  398331
  419275
  433928
  446669
  453508
  460112
  463239
  463661
  506507
  529115
  538420
  540111
  540612
  542174
  545662
  546871
  548355
  555471
  556424
  557262
  561523
  570134
  571364
  576579
  579589
  581980
  584106
  585588
  590002
  591863
  592546
  595666
  597218
  603887
  604390
  609986
  610614
  613383
  615408
  615471
  619900
  622446
  626823
  628507
  640392
  643178
  644124
  650271
  651220
  653065
  654397
  656252
  663831
  666452
  670253
  672824
  678209
  679879
  684893
  687040
  691706
  695571
  697521
  698252
  709146
  709363
  712201
  713002
  717206
  723591
  742591
  763060
  763481
  771389
  772809
  773761
  774494
  774803
  775112
  777342
  778093
  783478
  790437
  792420
  800978
  805189
  813613
  814219
  814281
  817248
  817325
  817971
  817993
  818759
  819389
  819704
  820213
  820362
  823588
  823614
  823946
  824018
  824045
  825357
  825588
  825890
  826243
  826298
  826530
  826640
  826975
  827589
  827844
  827994
  828443
  828764
  828788
]
13.09 ms
(7.64%)
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
  540612
  609986
  453508
  463661
  398331
  446669
  590002
  433928
  394134
  460112
  463239
  529115
  538420
  666452
  697521
  622446
  595666
  585588
  792420
  805189
  778093
  783478
  790437
  800978
  742591
  772809
  763481
  763060
  771389
  773761
  775112
  419275
  814219
  817971
  817993
  824018
  824045
  824638
  723591
  813613
  826640
  826530
  817248
  823588
  823614
  823946
  826243
  827589
  819389
  820362
  825357
  825588
  826298
  814281
  817325
  818759
  819704
  820213
  825890
  828764
  826975
  827994
  828788
  827844
  828443
  506507
  540111
  557262
  570134
  579589
  584106
  581980
  542174
  545662
  546871
  561523
  571364
  576579
  670253
  672824
  678209
  679879
  684893
  687040
  651220
  656252
  691706
  695571
  709146
  712201
  713002
  650271
  653065
  654397
  663831
  698164
  698252
  709363
  717206
  548355
  555471
  556424
  591863
  592546
  597218
  615408
  626823
  603887
  604390
  628507
  610614
  613383
  615471
  619900
  643178
  644124
  640392
  774494
  774803
  777342
]
2.65 ms
(1.55%)
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
  394134
  398331
  419275
  433928
  446669
  453508
  460112
  463239
  463661
  506507
  529115
  538420
  540111
  540612
  542174
  545662
  546871
  548355
  555471
  556424
  557262
  561523
  570134
  571364
  576579
  579589
  581980
  584106
  585588
  590002
  591863
  592546
  595666
  597218
  603887
  604390
  609986
  610614
  613383
  615408
  615471
  619900
  622446
  626823
  628507
  640392
  643178
  644124
  650271
  651220
  653065
  654397
  656252
  663831
  666452
  670253
  672824
  678209
  679879
  684893
  687040
  691706
  695571
  697521
  698252
  709146
  709363
  712201
  713002
  717206
  723591
  742591
  763060
  763481
  771389
  772809
  773761
  774494
  774803
  775112
  777342
  778093
  783478
  790437
  792420
  800978
  805189
  813613
  814219
  814281
  817248
  817325
  817971
  817993
  818759
  819389
  819704
  820213
  820362
  823588
  823614
  823946
  824018
  824045
  825357
  825588
  825890
  826243
  826298
  826530
  826640
  826975
  827589
  827844
  827994
  828443
  828764
  828788
]
2.34 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum pov"
]
1.90 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum пов"
]
1.86 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum пов"
]

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.