Query Metrics
7
Database Queries
7
Different statements
185.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.00 ms (87.43%) |
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 58313 383169 383390 393453 393775 400878 401960 404600 407320 408644 409408 410995 411236 412099 413455 413474 414200 416377 417647 417940 424227 426129 429105 432685 435468 439650 452369 457458 458777 459378 461098 464058 467162 467854 470251 472249 484088 494672 495669 507661 512547 513280 513326 515097 515222 515847 516793 523154 523532 523806 523808 524146 524455 529565 530632 536766 537163 545739 547649 548538 548655 558409 560157 564132 567146 575473 578410 594863 598871 611299 617660 619221 622392 622923 624291 644959 645003 668540 708741 712987 714494 716073 719918 722718 723175 727393 730270 730758 733138 733598 737070 737093 738070 744082 746445 755810 756074 759906 763522 788573 789741 789957 790888 790896 799801 801368 801868 802554 803057 811019 811909 811923 811938 813919 815785 816513 816561 817048 818915 827982 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (7.83%) |
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 407320 458777 461098 435468 472249 516793 524146 484088 815785 789741 801868 737093 755810 58313 817048 512547 802554 801368 746445 738070 744082 811923 548538 523806 645003 429105 644959 457458 530632 523808 467854 545739 723175 668540 722718 714494 716073 564132 575473 611299 619221 624291 594863 598871 617660 799801 788573 790888 811938 730270 733138 763522 622392 708741 400878 404600 417940 412099 416377 424227 439650 383390 432685 470251 410995 515097 513326 523532 513280 383169 393453 411236 413455 816513 813919 827982 537163 712987 558409 803057 811909 756074 727393 759906 733598 523154 536766 467162 515222 401960 426129 413474 816561 818915 452369 622923 789957 811019 730758 737070 719918 790896 409408 393775 408644 414200 417647 459378 464058 495669 529565 507661 524455 494672 515847 560157 567146 547649 548655 578410 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.22%) |
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 58313 383169 383390 393453 393775 400878 401960 404600 407320 408644 409408 410995 411236 412099 413455 413474 414200 416377 417647 417940 424227 426129 429105 432685 435468 439650 452369 457458 458777 459378 461098 464058 467162 467854 470251 472249 484088 494672 495669 507661 512547 513280 513326 515097 515222 515847 516793 523154 523532 523806 523808 524146 524455 529565 530632 536766 537163 545739 547649 548538 548655 558409 560157 564132 567146 575473 578410 594863 598871 611299 617660 619221 622392 622923 624291 644959 645003 668540 708741 712987 714494 716073 719918 722718 723175 727393 730270 730758 733138 733598 737070 737093 738070 744082 746445 755810 756074 759906 763522 788573 789741 789957 790888 790896 799801 801368 801868 802554 803057 811019 811909 811923 811938 813919 815785 816513 816561 817048 818915 827982 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young cum"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young cum"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young cum"
]
|
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.