Query Metrics
7
Database Queries
7
Different statements
210.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.03 ms (86.56%) |
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 7981 184985 187786 187954 191048 203528 384234 385742 388557 389623 392605 399568 400162 400932 404429 406062 406899 407809 408157 408765 409215 410937 411540 411643 411745 415579 415582 415636 415834 416989 418759 418883 420774 423966 424646 428202 428500 432663 434325 435659 438401 443105 445936 449038 452246 454627 454886 460315 460829 462450 462489 462708 466130 467469 467484 467517 467522 467668 470848 479836 480792 485065 485738 491322 493260 495665 495844 504889 506438 507530 507651 510617 511524 513696 513755 518439 518992 520319 522480 522710 523295 523820 525498 525838 527754 528849 530456 530690 550648 551059 559030 565276 565426 580631 587311 590724 590802 599497 600069 608534 624471 627806 631196 636249 641127 669218 693949 698102 707368 716980 719391 720871 759724 788767 795757 799971 804427 807141 808470 810926 ] |
||||||||||||||||||||||||||||||
|
18.28 ms (8.69%) |
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 392605 424646 462708 522480 507530 495665 203528 415636 432663 438401 452246 460315 518439 495844 559030 624471 808470 411540 504889 587311 608534 415579 485065 480792 795757 804427 388557 467668 416989 631196 428202 462450 600069 530690 411745 513696 719391 720871 565426 423966 399568 418759 530456 493260 799971 698102 400162 410937 510617 408765 420774 528849 693949 434325 385742 523820 400932 415582 551059 807141 404429 7981 415834 184985 191048 470848 518992 590724 599497 187954 428500 467484 445936 525498 520319 527754 716980 580631 462489 389623 467522 522710 511524 485738 513755 523295 525838 507651 384234 407809 435659 411643 454886 460829 590802 636249 788767 187786 408157 449038 409215 418883 467469 454627 443105 467517 479836 506438 627806 641127 565276 406062 406899 550648 707368 669218 810926 759724 466130 491322 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.20%) |
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 7981 184985 187786 187954 191048 203528 384234 385742 388557 389623 392605 399568 400162 400932 404429 406062 406899 407809 408157 408765 409215 410937 411540 411643 411745 415579 415582 415636 415834 416989 418759 418883 420774 423966 424646 428202 428500 432663 434325 435659 438401 443105 445936 449038 452246 454627 454886 460315 460829 462450 462489 462708 466130 467469 467484 467517 467522 467668 470848 479836 480792 485065 485738 491322 493260 495665 495844 504889 506438 507530 507651 510617 511524 513696 513755 518439 518992 520319 522480 522710 523295 523820 525498 525838 527754 528849 530456 530690 550648 551059 559030 565276 565426 580631 587311 590724 590802 599497 600069 608534 624471 627806 631196 636249 641127 669218 693949 698102 707368 716980 719391 720871 759724 788767 795757 799971 804427 807141 808470 810926 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck hard young"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс hard young"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс hard young"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.77%) |
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.