Query Metrics
7
Database Queries
7
Different statements
195.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.19 ms (85.64%) |
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 398038 399473 399621 413236 413960 416153 422152 424145 424671 425578 427339 427498 434676 436452 438735 440644 441910 448172 450377 450707 451669 453028 455375 456281 457891 457965 458713 459094 461788 462817 463677 464425 465553 467532 467548 468736 479781 480239 482718 485441 488100 488295 493138 495769 499581 501909 503989 505254 506218 509872 510206 510418 511235 511368 511545 511635 513507 515906 516588 516969 517599 518901 520520 521875 522249 522310 523731 523959 525469 526947 526967 527438 527950 528562 536913 542021 555017 557058 558849 561454 562463 564172 565790 567384 568818 570747 574369 575714 575746 579458 579726 580251 591910 592222 595163 599748 601844 602416 607926 614088 622592 648112 659460 673791 674240 693939 723616 725565 726547 726696 727032 731681 741699 750072 750831 784662 796090 812751 812763 814914 ] |
||||||||||||||||||||||||||||||
|
17.33 ms (8.88%) |
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 568818 648112 693939 599748 614088 607926 812751 731681 750072 750831 602416 399621 438735 509872 516588 513507 814914 562463 659460 557058 592222 416153 424671 723616 468736 511368 567384 459094 510206 525469 398038 427339 441910 450707 457965 493138 536913 579458 555017 575714 674240 574369 591910 622592 796090 725565 726547 726696 741699 727032 812763 424145 448172 485441 511635 413960 451669 503989 521875 506218 516969 526967 575746 580251 565790 425578 434676 458713 455375 517599 511235 482718 479781 510418 527950 467548 480239 542021 561454 673791 564172 436452 463677 465553 511545 495769 515906 523731 499581 505254 518901 523959 427498 450377 453028 457891 462817 526947 527438 558849 570747 579726 595163 601844 784662 413236 461788 399473 501909 488100 488295 522249 522310 440644 456281 520520 528562 422152 464425 467532 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.32%) |
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 398038 399473 399621 413236 413960 416153 422152 424145 424671 425578 427339 427498 434676 436452 438735 440644 441910 448172 450377 450707 451669 453028 455375 456281 457891 457965 458713 459094 461788 462817 463677 464425 465553 467532 467548 468736 479781 480239 482718 485441 488100 488295 493138 495769 499581 501909 503989 505254 506218 509872 510206 510418 511235 511368 511545 511635 513507 515906 516588 516969 517599 518901 520520 521875 522249 522310 523731 523959 525469 526947 526967 527438 527950 528562 536913 542021 555017 557058 558849 561454 562463 564172 565790 567384 568818 570747 574369 575714 575746 579458 579726 580251 591910 592222 595163 599748 601844 602416 607926 614088 622592 648112 659460 673791 674240 693939 723616 725565 726547 726696 727032 731681 741699 750072 750831 784662 796090 812751 812763 814914 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck in shower"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс shower"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс shower"
]
|
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.