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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.08 ms
(85.53%)
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
  80709
  185143
  192968
  223551
  263299
  387470
  390980
  397217
  397258
  397860
  398878
  401007
  402107
  402342
  402677
  406800
  412287
  412639
  420364
  420480
  421294
  422380
  423458
  426503
  426721
  429179
  429267
  429565
  432374
  433072
  434596
  434891
  435043
  435818
  437756
  438356
  443397
  444048
  444373
  447235
  449175
  452045
  452252
  453075
  453107
  453439
  453993
  455819
  456299
  456655
  457003
  457923
  458362
  458732
  459608
  460465
  461822
  462087
  463111
  466865
  467575
  468501
  469326
  469618
  470001
  470446
  471186
  473999
  474011
  474036
  474137
  475179
  475256
  476274
  476974
  477296
  477691
  478238
  479092
  479645
  480855
  481333
  482138
  484193
  485319
  488282
  491362
  493160
  495061
  497078
  497524
  498459
  498846
  498921
  501040
  501568
  502594
  503354
  503496
  504188
  506305
  507630
  508562
  509009
  520174
  523967
  524432
  527187
  527564
  541878
  543567
  558515
  563148
  564773
  568085
  569104
  571497
  578010
  601717
  635251
]
15.73 ms
(9.03%)
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
  444373
  426721
  457003
  458362
  449175
  452252
  453993
  456655
  452045
  453107
  564773
  571497
  402107
  471186
  474011
  480855
  438356
  457923
  470001
  470446
  481333
  420364
  497078
  498921
  527187
  498846
  497524
  503354
  463111
  635251
  397258
  420480
  421294
  453439
  460465
  192968
  455819
  434596
  476974
  479092
  527564
  412287
  432374
  401007
  422380
  503496
  437756
  456299
  263299
  80709
  387470
  397217
  423458
  412639
  474137
  485319
  495061
  501568
  466865
  475179
  475256
  476274
  541878
  563148
  402342
  429267
  435043
  469326
  397860
  429179
  398878
  406800
  443397
  426503
  435818
  508562
  491362
  493160
  509009
  523967
  507630
  504188
  223551
  429565
  433072
  469618
  474036
  477296
  543567
  568085
  569104
  390980
  444048
  473999
  434891
  461822
  453075
  501040
  484193
  488282
  578010
  478238
  468501
  524432
  402677
  479645
  482138
  467575
  447235
  459608
  462087
  477691
  458732
  520174
  502594
  601717
  498459
  558515
  506305
  185143
]
2.43 ms
(1.40%)
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
  80709
  185143
  192968
  223551
  263299
  387470
  390980
  397217
  397258
  397860
  398878
  401007
  402107
  402342
  402677
  406800
  412287
  412639
  420364
  420480
  421294
  422380
  423458
  426503
  426721
  429179
  429267
  429565
  432374
  433072
  434596
  434891
  435043
  435818
  437756
  438356
  443397
  444048
  444373
  447235
  449175
  452045
  452252
  453075
  453107
  453439
  453993
  455819
  456299
  456655
  457003
  457923
  458362
  458732
  459608
  460465
  461822
  462087
  463111
  466865
  467575
  468501
  469326
  469618
  470001
  470446
  471186
  473999
  474011
  474036
  474137
  475179
  475256
  476274
  476974
  477296
  477691
  478238
  479092
  479645
  480855
  481333
  482138
  484193
  485319
  488282
  491362
  493160
  495061
  497078
  497524
  498459
  498846
  498921
  501040
  501568
  502594
  503354
  503496
  504188
  506305
  507630
  508562
  509009
  520174
  523967
  524432
  527187
  527564
  541878
  543567
  558515
  563148
  564773
  568085
  569104
  571497
  578010
  601717
  635251
]
2.03 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "баба с пись"
]
1.85 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женскийрод вагин"
]
1.64 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.87%)
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.