Query Metrics
7
Database Queries
7
Different statements
180.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.26 ms (87.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 102026 148028 365938 382094 386658 400055 400835 403066 403633 406907 414058 419849 420481 428475 430326 435864 437870 443671 445776 449237 454680 457095 458738 461443 464374 465941 470555 473328 475916 477397 477645 479402 479561 481254 482648 483394 483675 485484 487079 487328 489166 501782 505319 513891 520674 531395 556431 556674 557883 557973 559609 560477 564370 566780 566859 570423 576785 577138 581323 585734 586356 596391 597128 603948 604952 605680 606923 608714 612030 614393 618774 627748 631595 636451 645959 648517 652853 654764 655636 663386 664811 666778 666844 668801 668808 679700 681936 684226 697416 702396 705118 708034 709492 715387 716225 717663 718552 721471 721843 726144 731000 732825 733231 754097 757175 773944 775974 776307 785078 788589 789666 792356 796545 798701 801475 801889 809663 812794 816755 818779 ] |
||||||||||||||||||||||||||||||
|
13.43 ms (7.45%) |
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 473328 477645 406907 420481 443671 483394 513891 487079 505319 386658 102026 365938 652853 489166 556674 557973 570423 716225 796545 732825 776307 792356 403066 403633 566780 586356 603948 596391 789666 809663 721843 775974 445776 482648 483675 564370 668801 709492 681936 605680 597128 604952 606923 608714 757175 785078 788589 481254 816755 457095 581323 576785 648517 679700 708034 645959 585734 726144 718552 400835 148028 382094 414058 419849 437870 430326 818779 454680 464374 477397 485484 531395 520674 560477 557883 559609 566859 715387 666778 684226 697416 627748 618774 631595 801475 801889 812794 754097 733231 612030 705118 470555 475916 400055 465941 479561 501782 428475 449237 487328 654764 655636 664811 666844 702396 721471 663386 668808 556431 577138 614393 636451 773944 731000 717663 798701 435864 479402 461443 458738 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.18%) |
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 102026 148028 365938 382094 386658 400055 400835 403066 403633 406907 414058 419849 420481 428475 430326 435864 437870 443671 445776 449237 454680 457095 458738 461443 464374 465941 470555 473328 475916 477397 477645 479402 479561 481254 482648 483394 483675 485484 487079 487328 489166 501782 505319 513891 520674 531395 556431 556674 557883 557973 559609 560477 564370 566780 566859 570423 576785 577138 581323 585734 586356 596391 597128 603948 604952 605680 606923 608714 612030 614393 618774 627748 631595 636451 645959 648517 652853 654764 655636 663386 664811 666778 666844 668801 668808 679700 681936 684226 697416 702396 705118 708034 709492 715387 716225 717663 718552 721471 721843 726144 731000 732825 733231 754097 757175 773944 775974 776307 785078 788589 789666 792356 796545 798701 801475 801889 809663 812794 816755 818779 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck guy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс guy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс guy"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.84%) |
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.