Query Metrics
7
Database Queries
7
Different statements
176.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.00 ms (85.89%) |
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 394670 407130 421077 451022 461870 462849 473366 484052 493681 495059 526849 529337 531767 532763 534094 539500 540032 540868 542701 544878 545245 555081 559300 559403 564294 564521 565234 575341 576496 589519 590847 593576 605503 617645 618843 630369 630399 636960 641126 643590 649916 651770 655143 655214 656530 656569 657193 657222 660042 665747 668510 677972 683323 684404 689146 692505 711112 712782 713909 715289 717728 720680 720888 735448 736237 738532 739776 742637 744446 744602 746703 747457 750261 751435 758971 761494 761713 761758 764840 764876 766985 767042 768361 771575 776023 776030 777637 778133 778901 778922 783345 785830 789465 790446 790566 790941 791200 794196 794900 797159 799880 799914 800352 800402 804695 804814 807059 807084 807926 808724 815991 817287 819411 821132 824672 825585 826277 827564 ] |
||||||||||||||||||||||||||||||
|
14.01 ms (7.92%) |
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 576496 767042 789465 540868 825585 542701 665747 808724 800402 807059 761713 790941 668510 451022 484052 473366 589519 407130 559300 655214 540032 555081 715289 751435 531767 539500 526849 656530 712782 783345 630369 559403 764840 819411 655143 746703 735448 651770 683323 778922 776023 750261 807084 827917 738532 421077 824672 826277 827564 461870 462849 684404 794900 815991 692505 785830 768361 758971 630399 744602 720680 711112 656569 689146 720888 778133 790446 791200 777637 761494 807926 771575 565234 804695 739776 394670 817287 778901 776030 641126 545245 605503 794196 593576 764876 493681 529337 532763 495059 534094 544878 564521 575341 649916 657193 677972 657222 717728 564294 617645 618843 636960 590847 643590 790566 799914 804814 799880 736237 744446 769790 742637 766985 713909 797159 761758 800352 747457 821132 660042 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.73%) |
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 394670 407130 421077 451022 461870 462849 473366 484052 493681 495059 526849 529337 531767 532763 534094 539500 540032 540868 542701 544878 545245 555081 559300 559403 564294 564521 565234 575341 576496 589519 590847 593576 605503 617645 618843 630369 630399 636960 641126 643590 649916 651770 655143 655214 656530 656569 657193 657222 660042 665747 668510 677972 683323 684404 689146 692505 711112 712782 713909 715289 717728 720680 720888 735448 736237 738532 739776 742637 744446 744602 746703 747457 750261 751435 758971 761494 761713 761758 764840 764876 766985 767042 768361 771575 776023 776030 777637 778133 778901 778922 783345 785830 789465 790446 790566 790941 791200 794196 794900 797159 799880 799914 800352 800402 804695 804814 807059 807084 807926 808724 815991 817287 819411 821132 824672 825585 826277 827564 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal close-up"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал close up"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал close up"
]
|
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.