Query Metrics
7
Database Queries
7
Different statements
164.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.75 ms (84.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 105558 198450 386747 386761 387324 420926 425636 431691 448310 467181 478839 490801 509881 511407 524482 531033 531528 531790 532431 532551 533022 539133 539324 542677 543636 543723 544272 550036 551073 559838 564762 565117 567783 568135 568204 569445 575692 577260 583224 596128 601020 601026 601058 604880 605799 617208 639310 640602 661039 663237 674295 681997 686601 690326 692135 699728 706863 713561 719175 720036 723098 725574 726289 740330 741608 751491 752874 758336 760417 760837 765308 774062 774748 774975 776820 779453 779655 780916 781171 782560 783153 785389 785889 785921 785965 789729 790855 796451 798043 798365 799233 799738 801390 801424 801855 805140 806508 807088 808717 811230 811308 813697 813773 815249 815526 815944 815962 816030 816063 817012 817028 817942 822635 823336 823521 824403 825863 826407 826713 828511 ] |
||||||||||||||||||||||||||||||
|
13.84 ms (8.44%) |
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 801424 725574 741608 387324 386747 828511 448310 531528 511407 799233 431691 425636 478839 569445 559838 601058 639310 798365 785921 815526 779655 807088 760837 813773 815249 816030 815944 815962 817028 531790 544272 542677 681997 720036 699728 713561 706863 605799 596128 785389 785965 726289 640602 719175 723098 790855 740330 386761 817942 823521 816063 565117 690326 686601 692135 801390 782560 467181 524482 551073 509881 198450 823336 568135 564762 568204 663237 661039 617208 604880 811308 765308 774748 774975 105558 420926 824403 826713 817012 813697 822635 825863 826407 531033 539133 539324 532551 533022 532431 490801 567783 575692 577260 550036 583224 543636 543723 674295 601026 601020 779453 780916 783153 805140 806508 811230 776820 781171 785889 798043 751491 758336 760417 774062 789729 796451 799738 801855 808717 752874 ] |
||||||||||||||||||||||||||||||
|
4.02 ms (2.45%) |
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 105558 198450 386747 386761 387324 420926 425636 431691 448310 467181 478839 490801 509881 511407 524482 531033 531528 531790 532431 532551 533022 539133 539324 542677 543636 543723 544272 550036 551073 559838 564762 565117 567783 568135 568204 569445 575692 577260 583224 596128 601020 601026 601058 604880 605799 617208 639310 640602 661039 663237 674295 681997 686601 690326 692135 699728 706863 713561 719175 720036 723098 725574 726289 740330 741608 751491 752874 758336 760417 760837 765308 774062 774748 774975 776820 779453 779655 780916 781171 782560 783153 785389 785889 785921 785965 789729 790855 796451 798043 798365 799233 799738 801390 801424 801855 805140 806508 807088 808717 811230 811308 813697 813773 815249 815526 815944 815962 816030 816063 817012 817028 817942 822635 823336 823521 824403 825863 826407 826713 828511 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty big boobs"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty большие boobs"
]
|
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.