Query Metrics
7
Database Queries
7
Different statements
188.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.54 ms (85.60%) |
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 397686 398009 421762 421763 441301 449472 450929 451879 452737 452744 452756 459090 464655 469768 485220 493079 496467 499911 507481 508696 529124 536216 538619 546850 550913 551662 554846 558265 559318 571946 587967 588731 592066 600235 614900 616312 617552 622304 624649 627362 628942 644883 647249 669309 675159 678238 699519 699543 703314 714953 715779 716934 719233 719972 720083 720084 730341 732200 732752 733594 734293 734465 736112 738463 738514 739887 740280 740814 741266 742987 748642 749303 757914 759791 760278 761437 761784 762525 762529 762564 765386 767663 767740 769057 772345 772362 772364 772389 773757 779946 780260 781441 783830 783876 784958 785299 786729 787647 790558 790769 791780 793971 795698 795862 797174 797929 797948 798619 799393 805256 805258 808601 809590 811027 813193 813214 824336 825452 825891 ] |
||||||||||||||||||||||||||||||
|
15.77 ms (8.35%) |
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 767663 767740 749303 761437 614900 715779 791780 811027 450929 398009 785299 805256 587967 742987 421762 464655 529124 538619 571946 554846 699519 647249 703314 719233 699543 714953 716934 719972 622304 616312 600235 783830 797174 779946 797929 760278 761784 769057 772345 781441 738514 740280 741266 762525 772389 738463 757914 772364 730341 732200 736112 762529 765386 773757 624649 720084 780260 793971 798619 813214 496467 825452 828018 644883 536216 628942 809590 787647 732752 739887 452756 397686 824336 783876 795698 762564 813193 825891 805258 627362 733594 421763 441301 449472 459090 485220 451879 452737 469768 452744 499911 507481 508696 493079 546850 551662 558265 550913 559318 669309 675159 678238 720083 592066 617552 588731 790769 795862 799393 808601 784958 734465 740814 772362 790558 797948 734293 748642 759791 786729 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (2.16%) |
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 397686 398009 421762 421763 441301 449472 450929 451879 452737 452744 452756 459090 464655 469768 485220 493079 496467 499911 507481 508696 529124 536216 538619 546850 550913 551662 554846 558265 559318 571946 587967 588731 592066 600235 614900 616312 617552 622304 624649 627362 628942 644883 647249 669309 675159 678238 699519 699543 703314 714953 715779 716934 719233 719972 720083 720084 730341 732200 732752 733594 734293 734465 736112 738463 738514 739887 740280 740814 741266 742987 748642 749303 757914 759791 760278 761437 761784 762525 762529 762564 765386 767663 767740 769057 772345 772362 772364 772389 773757 779946 780260 781441 783830 783876 784958 785299 786729 787647 790558 790769 791780 793971 795698 795862 797174 797929 797948 798619 799393 805256 805258 808601 809590 811027 813193 813214 824336 825452 825891 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"close up cum"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"close up cum"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"close up cum"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.91%) |
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.