Query Metrics
7
Database Queries
7
Different statements
138.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.16 ms (85.97%) |
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 466902 481193 483811 489763 504242 507099 522503 532678 533667 533700 533712 534514 535371 535378 535381 535407 535409 535601 536082 541662 542943 544181 547602 552785 552870 566969 573312 578836 578884 586353 598231 600809 602922 608487 609831 613988 614955 615827 616958 618633 618757 618946 619311 620705 620708 623407 626192 626793 629941 631317 634236 636874 639889 643605 647185 648221 648656 653355 654409 655108 655473 655547 657920 658586 659226 659241 661425 662585 665872 666996 671894 673457 675359 676509 678423 678544 679603 688789 691936 691943 692032 694990 695359 695362 695375 695393 696386 697678 698233 703705 706177 706410 707943 708204 709774 711378 711647 712545 714829 714922 715261 716200 717675 718214 718967 721440 721488 722221 722282 723256 777269 778084 778851 779908 779981 784327 786272 786905 828547 828771 ] |
||||||||||||||||||||||||||||||
|
9.53 ms (6.87%) |
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 828771 828547 489763 481193 466902 483811 507099 533667 533712 535409 536082 533700 534514 535371 535601 535407 504242 522503 532678 535378 535381 544181 547602 552785 552870 573312 578836 578884 542943 541662 566969 657920 658586 666996 688789 691943 695375 695393 703705 707943 709774 711378 714829 714922 722282 723256 648221 648656 653355 655473 661425 662585 665872 673457 676509 695359 695362 706410 712545 718214 721440 721488 647185 654409 655108 655547 659226 659241 671894 675359 678423 678544 679603 691936 692032 694990 696386 697678 698233 706177 708204 711647 715261 716200 717675 718967 722221 600809 609831 613988 619311 626192 636874 643605 598231 614955 618633 623407 602922 616958 620705 620708 629941 639889 586353 608487 615827 618757 618946 626793 631317 634236 777269 778084 778851 779908 779981 784327 786272 786905 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (2.20%) |
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 466902 481193 483811 489763 504242 507099 522503 532678 533667 533700 533712 534514 535371 535378 535381 535407 535409 535601 536082 541662 542943 544181 547602 552785 552870 566969 573312 578836 578884 586353 598231 600809 602922 608487 609831 613988 614955 615827 616958 618633 618757 618946 619311 620705 620708 623407 626192 626793 629941 631317 634236 636874 639889 643605 647185 648221 648656 653355 654409 655108 655473 655547 657920 658586 659226 659241 661425 662585 665872 666996 671894 673457 675359 676509 678423 678544 679603 688789 691936 691943 692032 694990 695359 695362 695375 695393 696386 697678 698233 703705 706177 706410 707943 708204 709774 711378 711647 712545 714829 714922 715261 716200 717675 718214 718967 721440 721488 722221 722282 723256 777269 778084 778851 779908 779981 784327 786272 786905 828547 828771 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп русск"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass ukrainian"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.