Query Metrics
7
Database Queries
7
Different statements
184.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.23 ms (88.99%) |
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 187842 384288 454537 461680 461767 468349 472877 480718 483561 489848 489849 491583 491584 495437 496730 497635 501510 505441 511481 522705 529331 535384 536421 536440 537264 538259 543629 551892 552584 553996 555282 556469 559996 560961 566770 567952 568068 571126 572707 574173 576505 577576 586853 587296 589070 589487 591736 592361 592686 593207 593985 594463 600539 600540 604206 604226 604360 605585 608122 609989 611206 612960 617683 619582 624196 626144 650726 660418 666364 668533 676642 683028 695911 696722 702038 703582 703584 709819 714895 715123 721329 727736 727743 729337 730315 730347 730479 733700 734324 739855 749909 752708 757395 759641 759917 761048 765279 765313 765699 765774 767315 767607 771324 774696 775180 777734 780873 782940 786048 786537 788851 790861 792645 793770 795701 796668 798183 805287 813537 814232 ] |
||||||||||||||||||||||||||||||
|
10.78 ms (5.84%) |
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 560961 592686 591736 574173 553996 752708 489849 468349 491584 497635 535384 511481 566770 576505 714895 624196 593207 587296 774696 727743 782940 805287 729337 730315 611206 617683 454537 604206 489848 765279 730479 605585 790861 771324 461767 187842 814232 505441 536440 537264 522705 536421 555282 551892 577576 715123 650726 676642 702038 703584 592361 786048 798183 727736 749909 608122 538259 543629 721329 775180 759917 757395 604226 568068 589487 600539 660418 695911 813537 612960 668533 703582 709819 626144 593985 786537 788851 733700 767607 793770 734324 761048 739855 777734 792645 795701 796668 496730 767315 730347 480718 572707 491583 552584 586853 483561 589070 501510 529331 556469 571126 666364 683028 594463 619582 600540 604360 567952 765699 384288 472877 609989 780873 765313 759641 765774 696722 559996 461680 495437 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.22%) |
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 187842 384288 454537 461680 461767 468349 472877 480718 483561 489848 489849 491583 491584 495437 496730 497635 501510 505441 511481 522705 529331 535384 536421 536440 537264 538259 543629 551892 552584 553996 555282 556469 559996 560961 566770 567952 568068 571126 572707 574173 576505 577576 586853 587296 589070 589487 591736 592361 592686 593207 593985 594463 600539 600540 604206 604226 604360 605585 608122 609989 611206 612960 617683 619582 624196 626144 650726 660418 666364 668533 676642 683028 695911 696722 702038 703582 703584 709819 714895 715123 721329 727736 727743 729337 730315 730347 730479 733700 734324 739855 749909 752708 757395 759641 759917 761048 765279 765313 765699 765774 767315 767607 771324 774696 775180 777734 780873 782940 786048 786537 788851 790861 792645 793770 795701 796668 798183 805287 813537 814232 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм анал"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм анал"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончает в жопку"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
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.