GET https://search.jues.net/search/embeds/9?q=real%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.70 ms
(85.06%)
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
  389683
  406861
  429121
  437560
  438276
  438396
  438648
  440986
  441892
  445088
  454519
  457744
  461300
  461658
  487205
  489155
  490853
  493994
  498332
  501322
  509054
  510637
  513854
  515512
  516692
  527523
  527526
  528541
  528965
  529003
  539557
  552000
  552263
  553708
  558048
  561435
  561442
  564750
  572670
  577698
  607964
  613440
  618461
  618816
  620974
  631117
  637998
  639882
  647605
  658837
  659324
  670623
  671092
  678699
  680749
  691170
  694619
  696241
  697296
  698352
  700452
  706523
  707488
  709937
  713335
  719383
  719640
  725378
  727564
  728463
  731232
  733151
  733176
  735839
  739459
  740803
  740897
  741064
  743933
  744834
  747637
  748334
  756277
  756295
  758420
  759608
  762369
  764889
  765456
  767354
  767983
  768060
  769686
  770810
  770943
  773313
  777830
  781515
  785029
  785362
  786432
  790944
  791301
  791405
  791600
  791684
  792988
  794467
  795120
  797773
  800975
  804783
  805643
  809729
  811130
  814090
  819628
]
16.10 ms
(9.15%)
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
  781515
  785029
  791684
  794467
  725378
  744834
  759608
  762013
  764889
  728463
  739459
  766177
  767983
  768060
  770943
  733151
  741064
  756295
  769686
  756277
  758420
  613440
  637998
  698352
  707488
  790944
  457744
  389683
  406861
  438396
  437560
  814090
  489155
  552000
  577698
  561442
  670623
  678699
  700452
  709937
  713335
  658837
  696241
  618816
  620974
  800975
  811130
  791301
  731232
  740897
  770810
  772131
  785362
  797773
  809729
  733176
  747637
  765456
  773313
  740803
  727564
  748334
  762369
  607964
  639882
  777830
  791600
  438276
  440986
  513854
  490853
  510637
  694619
  706523
  804783
  719383
  454519
  516692
  461658
  553708
  552263
  647605
  659324
  671092
  680749
  558048
  618461
  795120
  735839
  528965
  515512
  429121
  487205
  529003
  527523
  527526
  498332
  509054
  561435
  564750
  572670
  691170
  697296
  767354
  786432
  743933
  631117
  719640
  791405
  792988
  805643
  438648
  441892
  445088
  819628
  501322
  539557
  528541
  461300
  493994
]
3.12 ms
(1.77%)
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
  389683
  406861
  429121
  437560
  438276
  438396
  438648
  440986
  441892
  445088
  454519
  457744
  461300
  461658
  487205
  489155
  490853
  493994
  498332
  501322
  509054
  510637
  513854
  515512
  516692
  527523
  527526
  528541
  528965
  529003
  539557
  552000
  552263
  553708
  558048
  561435
  561442
  564750
  572670
  577698
  607964
  613440
  618461
  618816
  620974
  631117
  637998
  639882
  647605
  658837
  659324
  670623
  671092
  678699
  680749
  691170
  694619
  696241
  697296
  698352
  700452
  706523
  707488
  709937
  713335
  719383
  719640
  725378
  727564
  728463
  731232
  733151
  733176
  735839
  739459
  740803
  740897
  741064
  743933
  744834
  747637
  748334
  756277
  756295
  758420
  759608
  762369
  764889
  765456
  767354
  767983
  768060
  769686
  770810
  770943
  773313
  777830
  781515
  785029
  785362
  786432
  790944
  791301
  791405
  791600
  791684
  792988
  794467
  795120
  797773
  800975
  804783
  805643
  809729
  811130
  814090
  819628
]
1.91 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real девушк"
]
1.80 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real girls"
]
1.78 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real девушк"
]
1.60 ms
(0.91%)
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.