Query Metrics
7
Database Queries
7
Different statements
240.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.79 ms (89.59%) |
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 177802 287436 382720 385759 386062 386866 398247 398309 398715 400430 405809 411198 414763 420605 423725 424559 443561 445804 448338 448636 451515 453124 461275 461397 461411 468137 476500 481165 481824 486010 496162 496192 501679 501991 503529 505564 512956 517170 518281 526694 531706 534430 540176 543264 550842 551479 551674 551828 551951 552197 559096 559470 560292 560346 560929 561901 565062 569436 569879 570258 570403 571557 584241 585175 586707 587617 588445 589067 594544 597101 600682 605471 605928 607247 618647 618839 622416 629552 641156 642307 643624 652519 653494 653801 666509 681182 681286 688554 693629 695913 709228 710418 718190 720384 724475 728172 729299 753192 755108 755331 758417 759624 762327 765859 770563 778702 780278 783446 784286 787287 792100 795142 802947 808468 809605 811746 813831 815688 825221 825876 ] |
||||||||||||||||||||||||||||||
|
14.87 ms (6.17%) |
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 448338 451515 461275 461411 424559 445804 177802 476500 518281 496192 825221 693629 405809 385759 386866 386062 287436 382720 398247 398309 398715 400430 423725 411198 420605 443561 414763 813831 815688 825876 461397 481165 453124 448636 468137 481824 501991 503529 496162 534430 540176 505564 512956 517170 526694 531706 501679 486010 551674 560346 569436 569879 570258 551951 552197 559470 560929 561901 570403 571557 543264 550842 551479 559096 560292 565062 666509 681286 688554 710418 652519 653494 695913 653801 681182 709228 718190 720384 551828 584241 585175 607247 618839 641156 643624 587617 588445 594544 622416 629552 642307 600682 605471 605928 618647 586707 589067 597101 780278 783446 787287 792100 778702 808468 809605 811746 758417 770563 784286 795142 802947 724475 728172 729299 753192 755108 759624 762327 755331 765859 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.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 177802 287436 382720 385759 386062 386866 398247 398309 398715 400430 405809 411198 414763 420605 423725 424559 443561 445804 448338 448636 451515 453124 461275 461397 461411 468137 476500 481165 481824 486010 496162 496192 501679 501991 503529 505564 512956 517170 518281 526694 531706 534430 540176 543264 550842 551479 551674 551828 551951 552197 559096 559470 560292 560346 560929 561901 565062 569436 569879 570258 570403 571557 584241 585175 586707 587617 588445 589067 594544 597101 600682 605471 605928 607247 618647 618839 622416 629552 641156 642307 643624 652519 653494 653801 666509 681182 681286 688554 693629 695913 709228 710418 718190 720384 724475 728172 729299 753192 755108 755331 758417 759624 762327 765859 770563 778702 780278 783446 784286 787287 792100 795142 802947 808468 809605 811746 813831 815688 825221 825876 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucked hard"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucked hard"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucked hard"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.71%) |
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.