Query Metrics
7
Database Queries
7
Different statements
183.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.02 ms (87.39%) |
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 97276 129857 382017 384253 393771 395612 396540 399668 409174 419850 422817 434747 445781 446963 446992 448042 448089 448565 450370 451515 456288 456366 457257 460408 461274 462273 467360 469326 469720 474072 474807 477521 479710 480546 483962 487680 491521 493043 495644 496561 499720 500013 501404 501567 504024 504853 512932 524618 526404 529292 533867 542535 548239 550472 551570 554889 555206 561753 563399 565167 565432 586452 587058 588774 595792 596692 605654 606089 609793 612534 613465 621424 622681 625945 627639 649860 660649 660725 662169 664562 672355 681222 684574 700834 704966 706601 712123 717856 718520 720390 723982 725864 731994 738909 743811 748154 756504 757661 764037 767983 772425 772693 775591 789067 789424 790158 793623 797508 801322 801608 802864 805383 810547 812120 813549 816036 816894 823591 826628 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (7.42%) |
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 621424 596692 586452 627639 797508 789424 790158 764037 725864 757661 609793 706601 793623 810547 384253 595792 382017 456366 565432 555206 565167 467360 767983 704966 524618 456288 512932 660725 588774 812120 775591 563399 462273 504853 625945 409174 826628 823591 816036 816894 700834 772693 97276 434747 446992 660649 772425 801608 802864 684574 756504 448042 504024 526404 548239 469720 446963 422817 450370 419850 457257 483962 479710 551570 649860 681222 718520 672355 717856 588719 606089 738909 731994 605654 622681 480546 451515 460408 474072 396540 477521 491521 813549 448565 662169 664562 129857 393771 395612 496561 533867 550472 554889 720390 613465 723982 789067 748154 743811 712123 801322 493043 487680 501567 399668 500013 499720 529292 461274 542535 469326 474807 495644 561753 445781 448089 612534 587058 501404 805383 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.51%) |
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 97276 129857 382017 384253 393771 395612 396540 399668 409174 419850 422817 434747 445781 446963 446992 448042 448089 448565 450370 451515 456288 456366 457257 460408 461274 462273 467360 469326 469720 474072 474807 477521 479710 480546 483962 487680 491521 493043 495644 496561 499720 500013 501404 501567 504024 504853 512932 524618 526404 529292 533867 542535 548239 550472 551570 554889 555206 561753 563399 565167 565432 586452 587058 588774 595792 596692 605654 606089 609793 612534 613465 621424 622681 625945 627639 649860 660649 660725 662169 664562 672355 681222 684574 700834 704966 706601 712123 717856 718520 720390 723982 725864 731994 738909 743811 748154 756504 757661 764037 767983 772425 772693 775591 789067 789424 790158 793623 797508 801322 801608 802864 805383 810547 812120 813549 816036 816894 823591 826628 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public pussy lick"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на pussy улиц лиза"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на pussy улиц лиза"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.79%) |
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.