Query Metrics
8
Database Queries
8
Different statements
149.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.31 ms (83.22%) |
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 48166 48395 74508 90232 92281 382926 386042 386645 397837 506241 507140 530287 542047 543257 543359 546359 547172 550796 554794 557617 558657 566442 583319 585251 590182 602667 605696 607000 607005 609611 610118 610174 615045 617059 617370 618194 618214 624603 625295 625298 625381 628143 632514 632822 633900 640147 650491 650509 650983 651327 657112 664169 668800 679543 681184 681780 685398 691738 692092 700832 702155 703276 705118 705871 717268 717385 718150 720282 723691 725216 725722 726055 730289 730615 731412 732871 732904 732941 733082 733443 733473 734690 735421 737259 743926 744365 750158 759148 760515 767243 768761 772429 775474 778253 781562 783994 784013 784458 785403 786320 786677 789500 792669 792759 794308 795321 798519 802044 802888 804514 807736 808285 810034 810072 811555 812380 813438 813700 817798 820198 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (8.63%) |
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 808285 725216 733443 744365 783994 810034 92281 668800 786677 624603 789500 802888 546359 610174 705118 610118 820198 557617 651327 681780 702155 786320 768761 609611 798519 813438 48166 725722 732941 734690 679543 590182 628143 784458 792759 743926 775474 691738 692092 705871 386042 607005 650983 617370 48395 817798 792669 543257 585251 650491 732904 760515 607000 618194 632514 717268 812380 723691 566442 650509 735421 703276 772429 759148 625298 811555 733473 813700 602667 615045 625295 633900 640147 795321 807736 732871 618214 802044 382926 625381 804514 778253 717385 547172 750158 507140 558657 720282 700832 605696 632822 784013 794308 730615 737259 657112 681184 767243 530287 583319 664169 810072 550796 617059 731412 397837 554794 685398 781562 785403 726055 733082 730289 506241 74508 543359 718150 386645 90232 542047 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.75%) |
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 48166 48395 74508 90232 92281 382926 386042 386645 397837 506241 507140 530287 542047 543257 543359 546359 547172 550796 554794 557617 558657 566442 583319 585251 590182 602667 605696 607000 607005 609611 610118 610174 615045 617059 617370 618194 618214 624603 625295 625298 625381 628143 632514 632822 633900 640147 650491 650509 650983 651327 657112 664169 668800 679543 681184 681780 685398 691738 692092 700832 702155 703276 705118 705871 717268 717385 718150 720282 723691 725216 725722 726055 730289 730615 731412 732871 732904 732941 733082 733443 733473 734690 735421 737259 743926 744365 750158 759148 760515 767243 768761 772429 775474 778253 781562 783994 784013 784458 785403 786320 786677 789500 792669 792759 794308 795321 798519 802044 802888 804514 807736 808285 810034 810072 811555 812380 813438 813700 817798 820198 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife fuck"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.46%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01öÿs.┐rs║Ø▓·È.\n\x00"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.97%) |
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.