Query Metrics
7
Database Queries
7
Different statements
180.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.25 ms (87.58%) |
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 58237 73658 182134 392481 397590 415750 469161 495865 502788 508504 516984 517231 520010 525987 526699 531909 533899 537964 541819 544427 545288 548855 551488 555032 556460 559733 568651 578693 587565 588121 588662 591965 592937 595177 597757 597847 602685 604561 604993 605603 607670 612227 615246 621289 621301 624180 627202 630561 636049 636726 638150 639376 640671 645365 647784 647816 648433 651629 655920 656219 665741 671875 675672 676657 680544 686733 692733 693665 699262 699518 706727 707856 711375 711948 725120 727503 727977 731492 733644 738088 738587 738840 738987 744378 746629 750356 755200 755602 757278 765805 767095 767475 769524 779664 780822 785018 789346 794142 794855 795051 795236 795760 795764 795786 796004 800823 800899 800903 801154 801656 802144 804020 804144 806116 806631 810802 811551 814374 818397 ] |
||||||||||||||||||||||||||||||
|
12.60 ms (6.97%) |
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 559733 615246 627202 605603 818397 795760 804144 755602 746629 671875 686733 810802 802144 555032 588121 607670 779664 520010 711948 525987 795786 533899 541819 551488 789346 795764 800899 801656 806631 727503 794142 794855 795236 800823 811551 738587 738088 744378 755200 738987 767095 727977 731492 750356 767475 796004 806116 733644 537964 415750 545288 469161 656219 182134 392481 73658 397590 578693 58237 757278 795051 508504 785018 738840 769524 780822 602685 495865 647816 651629 647784 648433 655920 548855 639376 587565 595177 630561 597757 636726 638150 640671 804020 531909 502788 517231 526699 568651 645365 665741 675672 692733 699518 706727 713291 676657 680544 693665 699262 707856 556460 591965 636049 604561 612227 621289 624180 588662 597847 604993 621301 801154 725120 765805 711375 516984 814374 800903 544427 592937 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.55%) |
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 58237 73658 182134 392481 397590 415750 469161 495865 502788 508504 516984 517231 520010 525987 526699 531909 533899 537964 541819 544427 545288 548855 551488 555032 556460 559733 568651 578693 587565 588121 588662 591965 592937 595177 597757 597847 602685 604561 604993 605603 607670 612227 615246 621289 621301 624180 627202 630561 636049 636726 638150 639376 640671 645365 647784 647816 648433 651629 655920 656219 665741 671875 675672 676657 680544 686733 692733 693665 699262 699518 706727 707856 711375 711948 725120 727503 727977 731492 733644 738088 738587 738840 738987 744378 746629 750356 755200 755602 757278 765805 767095 767475 769524 779664 780822 785018 789346 794142 794855 795051 795236 795760 795764 795786 796004 800823 800899 800903 801154 801656 802144 804020 804144 806116 806631 810802 811551 814374 818397 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большая жопа домашние"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
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.