GET https://search.jues.net/search/embeds/7?q=%D0%B7%D0%B0%D1%81%D0%B2%D0%B5%D1%82%20%D0%BF%D0%B8%D1%81%D1%8C

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
218.88 ms
(88.75%)
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
  29292
  382665
  383432
  387409
  388790
  389314
  397194
  397542
  398738
  398948
  400484
  403707
  403872
  404084
  404438
  408626
  409075
  413179
  414233
  415518
  417599
  419346
  419987
  420116
  422020
  422298
  423862
  424296
  426477
  427153
  428480
  428999
  434075
  434128
  435559
  440724
  441800
  442800
  446218
  446789
  448675
  449067
  451305
  451324
  454689
  454761
  458296
  458423
  458456
  458545
  459760
  459824
  460612
  461282
  461425
  461632
  461979
  463189
  464019
  464869
  464911
  465447
  467833
  468208
  468272
  468275
  468277
  468284
  468286
  468321
  470790
  470990
  471009
  473107
  473724
  475748
  477144
  477256
  480101
  480735
  481828
  482609
  483690
  484110
  484510
  485809
  488777
  489156
  491064
  493342
  493732
  497714
  497917
  504014
  505352
  507330
  507606
  510735
  512312
  515443
  522635
  523739
  526668
  526804
  537791
  555003
  557921
  558504
  559881
  566869
  568902
  570289
  570461
  579441
  595471
  598048
  601295
  602754
  618008
  618797
]
17.10 ms
(6.93%)
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
  595471
  497917
  481828
  428480
  460612
  618008
  403872
  468286
  471009
  468208
  485809
  493732
  507330
  470990
  505352
  570289
  579441
  446218
  464869
  458456
  398948
  419346
  454761
  504014
  29292
  510735
  618797
  404438
  417599
  427153
  434075
  557921
  424296
  473107
  400484
  442800
  497714
  523739
  526804
  537791
  409075
  468284
  568902
  555003
  459824
  451324
  484110
  566869
  602754
  397194
  398738
  458423
  461632
  468272
  559881
  570461
  387409
  449067
  383432
  403707
  415518
  458545
  480735
  512312
  428999
  420116
  404084
  477144
  463189
  389314
  461979
  382665
  388790
  414233
  435559
  473724
  475748
  484510
  464911
  489156
  598048
  461282
  477256
  467833
  468275
  426477
  441800
  526668
  488777
  493342
  483690
  422020
  440724
  482609
  468321
  558504
  601295
  522635
  448675
  459760
  491064
  461425
  464019
  465447
  413179
  423862
  454689
  408626
  470790
  515443
  507606
  397542
  419987
  434128
  422298
  446789
  458296
  480101
  451305
  468277
]
2.99 ms
(1.21%)
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
  29292
  382665
  383432
  387409
  388790
  389314
  397194
  397542
  398738
  398948
  400484
  403707
  403872
  404084
  404438
  408626
  409075
  413179
  414233
  415518
  417599
  419346
  419987
  420116
  422020
  422298
  423862
  424296
  426477
  427153
  428480
  428999
  434075
  434128
  435559
  440724
  441800
  442800
  446218
  446789
  448675
  449067
  451305
  451324
  454689
  454761
  458296
  458423
  458456
  458545
  459760
  459824
  460612
  461282
  461425
  461632
  461979
  463189
  464019
  464869
  464911
  465447
  467833
  468208
  468272
  468275
  468277
  468284
  468286
  468321
  470790
  470990
  471009
  473107
  473724
  475748
  477144
  477256
  480101
  480735
  481828
  482609
  483690
  484110
  484510
  485809
  488777
  489156
  491064
  493342
  493732
  497714
  497917
  504014
  505352
  507330
  507606
  510735
  512312
  515443
  522635
  523739
  526668
  526804
  537791
  555003
  557921
  558504
  559881
  566869
  568902
  570289
  570461
  579441
  595471
  598048
  601295
  602754
  618008
  618797
]
2.15 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "засвет вагин"
]
1.98 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "засвет пись"
]
1.81 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "засвет вагин"
]
1.73 ms
(0.70%)
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.