Query Metrics
7
Database Queries
7
Different statements
191.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.29 ms (84.87%) |
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 14940 33260 40835 148793 155198 191487 249637 383075 385461 386477 386545 387160 388774 393095 396723 396866 397781 397849 398528 401115 402876 405848 409066 416236 444703 453194 454331 474852 480929 483573 497414 497806 499274 499556 516655 516686 516760 517610 517870 519766 523367 527750 529957 530767 536309 540528 548575 558440 569929 571015 584214 585365 586407 587272 589576 589674 591162 604083 604480 604597 604952 605022 606718 607459 607507 611530 618036 644309 650793 651601 663367 663895 664389 666582 667484 673767 675010 681637 690786 695879 715551 724283 727751 728738 731276 737554 741733 741752 742364 743066 744597 747879 751571 755222 761116 770115 772465 777008 781697 784740 789514 790963 799646 799695 802467 803449 805122 805607 809257 811826 812385 812759 817365 817786 818768 824900 824938 825039 826177 826521 ] |
||||||||||||||||||||||||||||||
|
17.64 ms (9.23%) |
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 523367 530767 650793 586407 781697 805122 741752 741733 744597 727751 618036 416236 517870 527750 516760 569929 681637 386477 386545 40835 824938 826177 817786 818768 824900 483573 536309 571015 673767 667484 695879 606718 607507 605022 799646 812759 789514 772465 737554 747879 770115 755222 715551 809257 387160 401115 398528 529957 516686 675010 651601 558440 811826 385461 396866 409066 817365 826521 664389 666582 585365 604952 790963 799695 803449 805607 812385 743066 802467 742364 724283 728738 751571 731276 761116 604480 777008 784740 148793 393095 497806 383075 191487 397849 402876 405848 825039 474852 516655 663895 589576 604083 604597 249637 587272 589674 444703 480929 155198 33260 14940 388774 396723 397781 453194 454331 517610 497414 519766 499274 499556 540528 584214 548575 663367 690786 644309 591162 607459 611530 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.53%) |
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 14940 33260 40835 148793 155198 191487 249637 383075 385461 386477 386545 387160 388774 393095 396723 396866 397781 397849 398528 401115 402876 405848 409066 416236 444703 453194 454331 474852 480929 483573 497414 497806 499274 499556 516655 516686 516760 517610 517870 519766 523367 527750 529957 530767 536309 540528 548575 558440 569929 571015 584214 585365 586407 587272 589576 589674 591162 604083 604480 604597 604952 605022 606718 607459 607507 611530 618036 644309 650793 651601 663367 663895 664389 666582 667484 673767 675010 681637 690786 695879 715551 724283 727751 728738 731276 737554 741733 741752 742364 743066 744597 747879 751571 755222 761116 770115 772465 777008 781697 784740 789514 790963 799646 799695 802467 803449 805122 805607 809257 811826 812385 812759 817365 817786 818768 824900 824938 825039 826177 826521 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black and mature"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black mature"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black mature"
]
|
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.