Query Metrics
7
Database Queries
7
Different statements
183.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.72 ms (87.75%) |
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 6813 13250 107311 119687 155530 176969 239495 357604 385964 386430 401640 401992 403999 405446 405832 435502 439634 442050 442912 451883 456721 459483 471780 479719 503742 517708 529525 530118 535947 537497 547312 548074 554436 560359 562574 563177 591023 600564 604667 624178 628030 631314 634436 637458 646869 669223 670584 700158 717196 721138 730938 734624 735639 736029 738104 745034 745953 746623 752943 753784 771336 772581 775682 781819 785118 785432 788478 794488 796537 801047 801080 802464 805289 806091 806966 808307 809053 809412 810445 810802 813409 814199 814702 816397 817312 817569 817881 818483 818717 818922 819356 819972 820687 823444 824211 824269 825168 825204 825265 825446 825911 826178 826381 826395 826465 827880 828255 828259 828311 828312 828416 828486 828599 828708 828711 828719 828831 828832 828866 ] |
||||||||||||||||||||||||||||||
|
13.03 ms (7.11%) |
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 745034 772581 736029 738104 745953 753784 717196 721138 801080 809053 810445 107311 442912 13250 826178 752943 806966 403999 239495 529525 155530 819356 818717 828832 828312 828831 828259 828866 828255 828711 828708 537497 535947 560359 562574 796537 801047 730938 385964 386430 119687 357604 405446 405832 817569 823444 825265 825446 818922 825911 816397 817312 818483 825204 548074 563177 788478 805289 785432 802464 808307 813409 735639 634436 700158 775682 401992 6813 442050 530118 554436 794488 806091 734624 785118 451883 456721 669223 624178 604667 435502 439634 459483 471780 401640 517708 503742 646869 670584 810802 547312 600564 809412 176969 824211 814199 826381 826395 814702 820687 824269 826465 817881 819972 825168 828416 828311 827880 828298 828719 828599 828486 479719 591023 637458 628030 631314 781819 771336 746623 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.69%) |
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 6813 13250 107311 119687 155530 176969 239495 357604 385964 386430 401640 401992 403999 405446 405832 435502 439634 442050 442912 451883 456721 459483 471780 479719 503742 517708 529525 530118 535947 537497 547312 548074 554436 560359 562574 563177 591023 600564 604667 624178 628030 631314 634436 637458 646869 669223 670584 700158 717196 721138 730938 734624 735639 736029 738104 745034 745953 746623 752943 753784 771336 772581 775682 781819 785118 785432 788478 794488 796537 801047 801080 802464 805289 806091 806966 808307 809053 809412 810445 810802 813409 814199 814702 816397 817312 817569 817881 818483 818717 818922 819356 819972 820687 823444 824211 824269 825168 825204 825265 825446 825911 826178 826381 826395 826465 827880 828255 828259 828311 828312 828416 828486 828599 828708 828711 828719 828831 828832 828866 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs ass"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs жоп"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs жоп"
]
|
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.