Query Metrics
7
Database Queries
7
Different statements
154.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.99 ms (82.58%) |
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 69589 76852 147173 147403 385912 391694 401160 401769 405995 456946 458604 466408 474319 505291 506206 540225 568545 571506 612781 619210 619893 625496 626802 629659 636500 636719 656487 680378 687718 689523 695435 697578 703264 703783 707056 707741 709913 710926 710939 710947 715349 716417 717117 718460 719032 719069 719255 720286 721649 722121 722122 722152 722167 724445 724685 724688 724842 725084 726444 728148 728893 728905 728954 729246 731238 731421 732598 734491 735015 736961 738349 738888 739400 739588 740541 740666 752846 757025 757926 758710 758996 771204 772861 772872 773718 775460 775464 777737 778164 782393 785345 785739 792782 793747 794111 794546 795063 795898 796022 796660 796764 797179 797258 797291 798747 799434 800039 801369 801501 802268 802309 803395 803542 803922 806925 810334 810361 812262 813603 824800 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (11.26%) |
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 724842 505291 76852 147173 401160 506206 656487 687718 715349 717117 719255 720286 721649 703264 716417 719032 722167 612781 636500 626802 619210 796764 802268 802309 775460 775464 785739 795898 796660 797258 801501 739400 740541 758996 772861 773718 792782 793747 794111 797179 800039 724445 724688 726444 728148 729246 734491 724685 725084 728893 728905 735015 738349 739588 757926 758710 771204 728954 736961 752846 731238 732598 740666 757025 772872 703783 722121 778164 798747 803542 803922 810334 810361 69589 147403 571506 796022 738888 458604 731421 824800 401769 636719 391694 456946 385912 405995 813603 466408 474319 540225 568545 680378 707056 707741 710926 722152 710939 722122 689523 695435 697578 709913 710947 718460 719069 619893 625496 629659 777737 782393 785345 794546 795063 797291 799434 801369 803395 806925 812262 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.80%) |
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 69589 76852 147173 147403 385912 391694 401160 401769 405995 456946 458604 466408 474319 505291 506206 540225 568545 571506 612781 619210 619893 625496 626802 629659 636500 636719 656487 680378 687718 689523 695435 697578 703264 703783 707056 707741 709913 710926 710939 710947 715349 716417 717117 718460 719032 719069 719255 720286 721649 722121 722122 722152 722167 724445 724685 724688 724842 725084 726444 728148 728893 728905 728954 729246 731238 731421 732598 734491 735015 736961 738349 738888 739400 739588 740541 740666 752846 757025 757926 758710 758996 771204 772861 772872 773718 775460 775464 777737 778164 782393 785345 785739 792782 793747 794111 794546 795063 795898 796022 796660 796764 797179 797258 797291 798747 799434 800039 801369 801501 802268 802309 803395 803542 803922 806925 810334 810361 812262 813603 824800 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation wife"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк жен"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.89%) |
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.