Query Metrics
7
Database Queries
7
Different statements
187.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.88 ms (87.26%) |
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 6640 34884 77013 92019 107348 145660 151455 321858 338487 339821 382816 383671 387226 395833 395841 398128 400442 400465 400467 402042 405100 406203 411954 413296 417692 417851 422450 430333 430650 434167 435289 442353 447862 448930 450778 451438 454250 462244 466874 467073 470359 471527 474251 480808 494706 495030 498876 509066 512247 512326 515828 517605 521033 521989 522845 523262 523532 526033 536993 539469 542941 542947 560219 560853 569666 571686 573065 573321 580646 587309 588274 588625 596468 598444 605137 607103 607203 614717 618757 635346 641094 663463 663524 666779 667513 670341 670566 688019 694537 704727 705362 712441 722916 724910 726019 726650 727801 732396 732871 734268 734638 738379 743126 744312 748742 759120 764880 785476 794333 795293 795458 795505 800563 804001 805909 810177 811777 813785 814142 820592 ] |
||||||||||||||||||||||||||||||
|
14.10 ms (7.51%) |
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 526033 663524 587309 395833 474251 813785 151455 542947 618757 732871 748742 641094 704727 417692 580646 614717 480808 521989 467073 387226 705362 794333 795458 400465 406203 417851 430333 450778 539469 670566 712441 800563 727801 732396 744312 434167 466874 395841 451438 454250 495030 515828 522845 743126 77013 738379 471527 521033 107348 400467 494706 573321 688019 666779 724910 726019 726650 795293 382816 470359 383671 405100 402042 435289 422450 811777 92019 413296 560853 569666 571686 667513 694537 588625 607203 607103 6640 670341 398128 321858 338487 34884 814142 820592 462244 509066 517605 536993 663463 596468 605137 810177 804001 759120 805909 734268 734638 764880 635346 785476 795505 560219 339821 400442 411954 442353 447862 498876 512247 512326 542941 573065 588274 598444 722916 448930 145660 430650 523262 523532 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.49%) |
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 6640 34884 77013 92019 107348 145660 151455 321858 338487 339821 382816 383671 387226 395833 395841 398128 400442 400465 400467 402042 405100 406203 411954 413296 417692 417851 422450 430333 430650 434167 435289 442353 447862 448930 450778 451438 454250 462244 466874 467073 470359 471527 474251 480808 494706 495030 498876 509066 512247 512326 515828 517605 521033 521989 522845 523262 523532 526033 536993 539469 542941 542947 560219 560853 569666 571686 573065 573321 580646 587309 588274 588625 596468 598444 605137 607103 607203 614717 618757 635346 641094 663463 663524 666779 667513 670341 670566 688019 694537 704727 705362 712441 722916 724910 726019 726650 727801 732396 732871 734268 734638 738379 743126 744312 748742 759120 764880 785476 794333 795293 795458 795505 800563 804001 805909 810177 811777 813785 814142 820592 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин жоп"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин жоп"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man to ass"
]
|
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.