Query Metrics
7
Database Queries
7
Different statements
239.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.49 ms (90.13%) |
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 3793 6690 17190 203645 384289 385111 386883 389585 389823 390775 392599 396777 396841 396990 407746 408790 417844 422201 427373 428470 432470 441597 441988 442012 444208 444819 444943 450821 454472 456023 456077 458068 462887 464347 468872 469685 474605 478088 479519 479528 483969 485855 486044 489849 492754 493755 496003 496412 501690 507008 508535 508666 509264 509366 514202 514237 515961 518259 518956 530349 532396 534430 540724 541203 541528 543123 543994 545030 545403 554614 554862 559733 560288 561617 562318 571420 575344 577739 578513 578742 580439 584088 585846 588439 591820 592123 592997 594608 597932 601814 603589 604332 611948 617490 617509 626002 627349 651810 657804 664105 664260 665293 667860 670570 675671 698474 715907 717367 731449 738566 758992 777260 788242 792011 795574 796637 797818 803347 814356 816853 ] |
||||||||||||||||||||||||||||||
|
13.83 ms (5.78%) |
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 444943 441597 385111 428470 545403 664105 731449 6690 816853 518956 530349 468872 578513 611948 603589 795574 514237 575344 597932 592123 617509 738566 441988 534430 541528 541203 657804 626002 203645 492754 464347 796637 788242 408790 514202 617490 442012 540724 715907 458068 384289 675671 717367 792011 444819 407746 396841 17190 777260 392599 422201 456023 814356 450821 501690 496412 545030 580439 651810 664260 665293 667860 698474 562318 594608 469685 532396 577739 585846 627349 509264 389823 386883 417844 462887 396777 396990 454472 456077 486044 515961 584088 554862 758992 427373 518259 571420 670570 478088 509366 604332 390775 489849 474605 559733 560288 543123 561617 591820 432470 479519 797818 479528 496003 507008 508535 543994 578742 554614 601814 588439 592997 3793 444208 483969 485855 508666 493755 389585 803347 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.28%) |
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 3793 6690 17190 203645 384289 385111 386883 389585 389823 390775 392599 396777 396841 396990 407746 408790 417844 422201 427373 428470 432470 441597 441988 442012 444208 444819 444943 450821 454472 456023 456077 458068 462887 464347 468872 469685 474605 478088 479519 479528 483969 485855 486044 489849 492754 493755 496003 496412 501690 507008 508535 508666 509264 509366 514202 514237 515961 518259 518956 530349 532396 534430 540724 541203 541528 543123 543994 545030 545403 554614 554862 559733 560288 561617 562318 571420 575344 577739 578513 578742 580439 584088 585846 588439 591820 592123 592997 594608 597932 601814 603589 604332 611948 617490 617509 626002 627349 651810 657804 664105 664260 665293 667860 670570 675671 698474 715907 717367 731449 738566 758992 777260 788242 792011 795574 796637 797818 803347 814356 816853 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трахают раком"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс рак"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.54%) |
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.