Query Metrics
7
Database Queries
7
Different statements
146.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.22 ms (83.28%) |
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 397191 400569 402969 405777 411213 415928 424268 435737 436825 438032 438828 455834 456366 457803 458077 459626 471662 477348 479296 480625 500095 501408 505857 510410 514953 515976 518247 547581 550941 553610 554065 556869 559358 560859 562359 566763 566987 577052 583532 591138 592665 596950 607263 614331 614381 615947 616227 617089 617526 617711 619647 620240 626351 627844 628258 628669 629575 631674 637176 659050 659956 660605 663724 675390 682763 704034 705705 708227 710034 711320 715121 719109 724781 731185 732869 736531 737280 739971 740539 740709 746592 750686 750692 752840 756094 756697 757082 758953 764864 765577 765952 768008 768456 768965 769585 770063 772795 778989 779722 780130 783531 783627 788655 789080 789859 791101 793219 796017 796577 797272 798293 798636 798735 798820 798848 802236 804648 811350 814213 819543 ] |
||||||||||||||||||||||||||||||
|
15.46 ms (10.53%) |
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 704034 719109 660605 659050 659956 617526 779722 788655 789859 758953 764864 798735 798820 798848 724781 732869 736531 737280 740539 765577 746592 768456 770063 757082 768965 705705 783627 796017 804648 515976 756094 752840 424268 814213 501408 514953 550941 559358 566987 577052 663724 675390 682763 556869 583532 637176 591138 628258 596950 614331 617711 629575 778989 780130 797272 793219 791101 765952 739971 756697 731185 772795 715121 397191 479296 457803 438032 500095 710034 620240 614381 796577 400569 405777 438828 415928 477348 480625 455834 456366 518247 562359 547581 560859 566763 554065 708227 553610 615947 619647 592665 626351 607263 627844 628669 616227 798293 798636 811350 740709 750686 783531 789080 750692 769585 768008 617089 711320 471662 411213 436825 402969 505857 435737 459626 631674 802236 510410 458077 819543 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.53%) |
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 397191 400569 402969 405777 411213 415928 424268 435737 436825 438032 438828 455834 456366 457803 458077 459626 471662 477348 479296 480625 500095 501408 505857 510410 514953 515976 518247 547581 550941 553610 554065 556869 559358 560859 562359 566763 566987 577052 583532 591138 592665 596950 607263 614331 614381 615947 616227 617089 617526 617711 619647 620240 626351 627844 628258 628669 629575 631674 637176 659050 659956 660605 663724 675390 682763 704034 705705 708227 710034 711320 715121 719109 724781 731185 732869 736531 737280 739971 740539 740709 746592 750686 750692 752840 756094 756697 757082 758953 764864 765577 765952 768008 768456 768965 769585 770063 772795 778989 779722 780130 783531 783627 788655 789080 789859 791101 793219 796017 796577 797272 798293 798636 798735 798820 798848 802236 804648 811350 814213 819543 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife outdoor"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен outdoor"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен outdoor"
]
|
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.