GET https://search.jues.net/search/embeds/3?q=cute%2018%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.88 ms
(58.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cute 18 solo"
]
122.78 ms
(34.76%)
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
  382510
  384042
  384162
  384462
  392704
  397569
  401414
  419633
  420902
  421759
  425687
  429566
  437926
  439345
  444204
  446008
  448572
  451695
  454745
  456252
  458642
  464492
  468163
  468251
  470818
  471110
  473038
  477255
  483478
  486891
  489034
  489067
  494302
  494482
  495170
  495550
  498378
  499013
  499484
  500308
  502630
  514986
  522148
  524602
  528451
  530936
  534154
  553843
  556193
  560364
  561756
  564215
  570409
  570410
  572782
  580519
  583185
  584322
  585835
  590409
  598504
  600512
  602444
  605850
  606227
  607926
  608467
  612131
  615497
  616099
  620808
  626609
  632288
  662117
  666925
  676769
  679697
  680029
  680677
  680768
  681204
  682388
  687318
  695339
  695872
  697242
  701292
  727265
  730871
  731456
  736973
  738255
  740407
  740848
  749508
  751110
  751692
  751786
  754086
  757183
  760471
  760485
  762035
  783709
  784513
  785267
  786895
  791235
  791303
  791376
  791385
  791386
  792309
  795397
  806597
  806635
  808981
  813259
  814350
  820884
]
15.86 ms
(4.49%)
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
  791235
  791303
  808981
  813259
  570410
  676769
  681204
  615497
  626609
  606227
  791376
  795397
  786895
  736973
  749508
  384462
  437926
  401414
  679697
  425687
  420902
  522148
  680029
  605850
  760471
  602444
  584322
  384162
  814350
  662117
  680677
  682388
  791386
  760485
  754086
  751786
  757183
  612131
  632288
  382510
  397569
  471110
  534154
  498378
  464492
  470818
  477255
  494482
  570409
  580519
  697242
  564215
  572782
  583185
  590409
  600512
  751110
  806635
  468163
  454745
  528451
  494302
  495170
  499013
  524602
  489034
  392704
  419633
  446008
  458642
  473038
  740407
  751692
  439345
  695339
  695872
  783709
  500308
  421759
  429566
  530936
  556193
  560364
  666925
  701292
  687318
  553843
  561756
  585835
  598504
  607926
  730871
  791385
  448572
  451695
  384042
  444204
  502630
  489067
  495550
  514986
  483478
  499484
  820884
  456252
  468251
  486891
  680768
  616099
  608467
  620808
  806597
  785267
  792309
  740848
  784513
  727265
  731456
  738255
  762035
]
3.10 ms
(0.88%)
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
  382510
  384042
  384162
  384462
  392704
  397569
  401414
  419633
  420902
  421759
  425687
  429566
  437926
  439345
  444204
  446008
  448572
  451695
  454745
  456252
  458642
  464492
  468163
  468251
  470818
  471110
  473038
  477255
  483478
  486891
  489034
  489067
  494302
  494482
  495170
  495550
  498378
  499013
  499484
  500308
  502630
  514986
  522148
  524602
  528451
  530936
  534154
  553843
  556193
  560364
  561756
  564215
  570409
  570410
  572782
  580519
  583185
  584322
  585835
  590409
  598504
  600512
  602444
  605850
  606227
  607926
  608467
  612131
  615497
  616099
  620808
  626609
  632288
  662117
  666925
  676769
  679697
  680029
  680677
  680768
  681204
  682388
  687318
  695339
  695872
  697242
  701292
  727265
  730871
  731456
  736973
  738255
  740407
  740848
  749508
  751110
  751692
  751786
  754086
  757183
  760471
  760485
  762035
  783709
  784513
  785267
  786895
  791235
  791303
  791376
  791385
  791386
  792309
  795397
  806597
  806635
  808981
  813259
  814350
  820884
]
2.01 ms
(0.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cute 18 соло"
]
1.77 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cute 18 соло"
]

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.