Query Metrics
7
Database Queries
7
Different statements
169.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.76 ms (74.72%) |
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 57971 233618 274758 382021 395434 396931 397977 401391 425587 426233 487528 533954 536211 536508 550771 555010 569809 590154 591516 593056 625032 625231 626382 627126 630379 633174 638757 644757 654599 689180 693683 698920 702936 703255 703485 710208 711918 712648 713073 714392 715442 716602 717103 717806 723196 724806 724829 725646 728983 729252 731646 733429 734264 734412 734607 737259 738543 738864 738887 740666 742509 742562 744771 746286 747273 748107 751780 753778 757686 758310 758604 760677 761918 762253 763412 763524 763767 763844 764262 765978 766370 766934 767908 768634 768721 768853 769046 770098 770729 771424 772570 773809 774299 777873 778478 779819 782067 783178 783210 787677 789282 794735 795606 796316 797309 797357 800053 800939 801448 801932 801997 802401 803161 803194 804043 804131 804233 804546 824825 827711 ] |
||||||||||||||||||||||||||||||
|
32.43 ms (19.12%) |
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 761918 762253 765978 766370 768634 769046 724829 728983 731646 747273 751780 753778 757686 758604 767908 738543 760677 763412 763524 763844 766934 768721 770098 724806 740666 742509 742562 748107 763767 764262 770729 773809 625032 625231 626382 627126 644757 703255 703485 711918 713073 714392 715442 716602 717103 717806 723196 777873 778478 779819 782067 783178 789282 794735 797309 797357 800939 801997 803161 804131 233618 382021 397977 738864 396931 487528 533954 536211 536508 710208 693683 698920 702936 555010 590154 593056 638757 800053 801932 803194 801448 804233 725646 744771 746286 758310 771424 783210 787677 796316 729252 734264 734412 734607 738887 774299 768853 733429 630379 804043 426233 425587 654599 712648 689180 591516 795606 802401 804546 57971 274758 569809 550771 633174 737259 772570 395434 401391 827711 824825 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife hot"
]
|
||||||||||||||||||||||||||||||
|
2.29 ms (1.35%) |
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 57971 233618 274758 382021 395434 396931 397977 401391 425587 426233 487528 533954 536211 536508 550771 555010 569809 590154 591516 593056 625032 625231 626382 627126 630379 633174 638757 644757 654599 689180 693683 698920 702936 703255 703485 710208 711918 712648 713073 714392 715442 716602 717103 717806 723196 724806 724829 725646 728983 729252 731646 733429 734264 734412 734607 737259 738543 738864 738887 740666 742509 742562 744771 746286 747273 748107 751780 753778 757686 758310 758604 760677 761918 762253 763412 763524 763767 763844 764262 765978 766370 766934 767908 768634 768721 768853 769046 770098 770729 771424 772570 773809 774299 777873 778478 779819 782067 783178 783210 787677 789282 794735 795606 796316 797309 797357 800053 800939 801448 801932 801997 802401 803161 803194 804043 804131 804233 804546 824825 827711 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен hot"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен hot"
]
|
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.