Query Metrics
7
Database Queries
7
Different statements
187.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.44 ms (87.00%) |
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 542871 543308 554076 680029 713907 714833 714942 715018 717673 718127 718230 718441 718822 723015 724116 726154 726379 728582 729286 730032 730121 730341 730491 731159 732669 732926 735173 736018 736682 737491 738757 739604 742548 742659 742961 745298 745968 746038 746732 747174 747557 748335 748753 749167 749346 749516 749697 749860 750510 750517 750873 750908 751805 753787 753959 755358 757870 758665 759129 759223 760274 761191 762703 763060 763595 763677 765510 768240 769478 769693 769725 769956 770605 771804 772053 773134 773499 775679 777657 780736 780864 780876 784365 785212 787357 789068 790094 794013 794213 794250 794955 795410 795630 796354 800599 801832 804260 807881 808037 808227 808560 809517 809540 810092 812485 813086 813303 813364 814168 814174 814225 824314 824581 825275 825843 825874 826018 826538 827423 827675 ] |
||||||||||||||||||||||||||||||
|
14.63 ms (7.79%) |
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 769693 750510 750517 723015 554076 804260 813303 809517 745968 763595 824581 827423 827675 717673 718127 784365 753959 773134 748335 749860 757870 749346 758665 730341 738757 739604 761191 763677 768240 770605 759223 726379 794955 732926 542871 742659 748753 825843 813086 728582 730121 742961 746732 760274 730491 732669 747174 749167 715018 746038 714942 780736 785212 794013 762703 769956 735173 826538 737491 771804 755358 769725 775679 826018 814168 825874 814174 814225 824314 825275 543308 680029 714833 718822 718441 718230 789068 794250 795410 795630 807881 809540 812485 780864 780876 787357 800599 726154 747557 753787 759129 790094 796354 801832 808227 808560 749697 751805 765510 769478 773499 730032 736018 736682 742548 749516 724116 729286 731159 750873 750908 772053 777657 794213 808037 810092 813364 763060 745298 713907 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.44%) |
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 542871 543308 554076 680029 713907 714833 714942 715018 717673 718127 718230 718441 718822 723015 724116 726154 726379 728582 729286 730032 730121 730341 730491 731159 732669 732926 735173 736018 736682 737491 738757 739604 742548 742659 742961 745298 745968 746038 746732 747174 747557 748335 748753 749167 749346 749516 749697 749860 750510 750517 750873 750908 751805 753787 753959 755358 757870 758665 759129 759223 760274 761191 762703 763060 763595 763677 765510 768240 769478 769693 769725 769956 770605 771804 772053 773134 773499 775679 777657 780736 780864 780876 784365 785212 787357 789068 790094 794013 794213 794250 794955 795410 795630 796354 800599 801832 804260 807881 808037 808227 808560 809517 809540 810092 812485 813086 813303 813364 814168 814174 814225 824314 824581 825275 825843 825874 826018 826538 827423 827675 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ тикток социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ тикток социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits tiktok"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.78%) |
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.