GET https://search.jues.net/search/embeds/8?q=%D0%BF%D0%B8%D1%81%D1%8F%20%D1%82%D1%83%D0%B0%D0%BB%D0%B5%D1%82

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.61 ms
(84.20%)
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
  66919
  83083
  145336
  336085
  361992
  391317
  391762
  395439
  396776
  400595
  412616
  421623
  426487
  454290
  457275
  458203
  460327
  462189
  466925
  473692
  489731
  495733
  497809
  497894
  509717
  512190
  517508
  523407
  526767
  527140
  528370
  529638
  531655
  533224
  533785
  541124
  547416
  548945
  550511
  553160
  553547
  554707
  555315
  555959
  558402
  559863
  560345
  560723
  561409
  562051
  571304
  578987
  581357
  581550
  585784
  586100
  589526
  591836
  596800
  602964
  603023
  611476
  614485
  627425
  630468
  649388
  649474
  650524
  651784
  658492
  658931
  658939
  662212
  668330
  669941
  670934
  671779
  673375
  679281
  679391
  683080
  683698
  686867
  690014
  691785
  692691
  698196
  698797
  700830
  704662
  704788
  708561
  709374
  710860
  712446
  715743
  719439
  720297
  722043
  732178
  744138
  751386
  751669
  753605
  755608
  760315
  762526
  768599
  793721
  794082
  798762
  803367
  812399
  815989
  816147
  817734
  817829
  818209
  824000
  827627
]
15.47 ms
(8.95%)
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
  145336
  391762
  396776
  466925
  489731
  512190
  517508
  562051
  581357
  720297
  722043
  668330
  669941
  715743
  670934
  673375
  704662
  553547
  585784
  589526
  591836
  614485
  627425
  586100
  611476
  596800
  798762
  803367
  812399
  793721
  755608
  760315
  762526
  794082
  751669
  698797
  391317
  421623
  753605
  751386
  66919
  555959
  454290
  497809
  558402
  690014
  630468
  528370
  426487
  460327
  457275
  527140
  550511
  602964
  523407
  412616
  495733
  603023
  744138
  768599
  732178
  395439
  336085
  361992
  83083
  400595
  815989
  817829
  816147
  827627
  817734
  818209
  824000
  458203
  473692
  462189
  529638
  533785
  531655
  533224
  497894
  509717
  526767
  553160
  554707
  559863
  560723
  561409
  571304
  547416
  548945
  578987
  541124
  555315
  560345
  581550
  650524
  658939
  662212
  671779
  683080
  686867
  692691
  719439
  649474
  651784
  658492
  683698
  700830
  709374
  710860
  649388
  658931
  679281
  679391
  691785
  698196
  704788
  708561
  712446
]
3.70 ms
(2.14%)
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
  66919
  83083
  145336
  336085
  361992
  391317
  391762
  395439
  396776
  400595
  412616
  421623
  426487
  454290
  457275
  458203
  460327
  462189
  466925
  473692
  489731
  495733
  497809
  497894
  509717
  512190
  517508
  523407
  526767
  527140
  528370
  529638
  531655
  533224
  533785
  541124
  547416
  548945
  550511
  553160
  553547
  554707
  555315
  555959
  558402
  559863
  560345
  560723
  561409
  562051
  571304
  578987
  581357
  581550
  585784
  586100
  589526
  591836
  596800
  602964
  603023
  611476
  614485
  627425
  630468
  649388
  649474
  650524
  651784
  658492
  658931
  658939
  662212
  668330
  669941
  670934
  671779
  673375
  679281
  679391
  683080
  683698
  686867
  690014
  691785
  692691
  698196
  698797
  700830
  704662
  704788
  708561
  709374
  710860
  712446
  715743
  719439
  720297
  722043
  732178
  744138
  751386
  751669
  753605
  755608
  760315
  762526
  768599
  793721
  794082
  798762
  803367
  812399
  815989
  816147
  817734
  817829
  818209
  824000
  827627
]
2.22 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.12 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пися туалет"
]
2.03 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин туалет"
]
1.79 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.