Query Metrics
7
Database Queries
7
Different statements
179.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.17 ms (87.66%) |
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 508689 543741 546988 550147 551657 553212 553533 562392 573916 577273 588214 589113 591099 592864 595808 601716 602597 605938 612661 615534 617446 617609 618147 621642 634841 637549 643211 645754 648201 653646 654888 657864 669321 670701 670729 670738 671251 678458 679628 681657 681736 682714 689829 692180 696145 696149 696521 698340 704996 706227 711060 711154 715434 718168 720680 725766 732202 733368 734920 735999 736025 736185 738949 741189 744199 745292 745860 747247 748517 752323 754025 759833 760399 766885 768674 769023 777483 777543 778121 780660 780886 783207 784160 787290 791230 792414 792973 794086 794523 794537 795452 795803 796528 796533 804205 804917 806808 811545 814502 816719 818378 818840 818927 822706 823601 823894 824385 824426 825130 825599 825752 825927 825942 826044 826702 827529 827856 828148 828738 ] |
||||||||||||||||||||||||||||||
|
12.19 ms (6.80%) |
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 692180 595808 823894 823601 706227 615534 826044 681657 816719 741189 682714 508689 577273 795803 715434 795452 827529 720680 670729 589113 760399 734920 696149 777543 787290 818378 824426 696145 792414 735999 824385 670738 671251 634841 698340 822706 826702 818840 553212 612661 784160 733368 637549 827856 543741 562392 602597 617609 794086 804917 736025 745292 748517 769023 736185 752323 825927 825942 828148 718168 654888 689829 551657 591099 732202 796533 811545 745860 747247 768674 780660 825130 825752 550147 553533 573916 670701 681736 696521 704996 657864 669321 678458 546988 643211 777483 796528 754025 794523 766885 725766 744199 711060 778121 783207 601716 804205 814502 818927 828738 827841 653646 711154 806808 738949 759833 617446 780886 792973 825599 648201 679628 645754 588214 618147 621642 605938 592864 791230 794537 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.36%) |
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 508689 543741 546988 550147 551657 553212 553533 562392 573916 577273 588214 589113 591099 592864 595808 601716 602597 605938 612661 615534 617446 617609 618147 621642 634841 637549 643211 645754 648201 653646 654888 657864 669321 670701 670729 670738 671251 678458 679628 681657 681736 682714 689829 692180 696145 696149 696521 698340 704996 706227 711060 711154 715434 718168 720680 725766 732202 733368 734920 735999 736025 736185 738949 741189 744199 745292 745860 747247 748517 752323 754025 759833 760399 766885 768674 769023 777483 777543 778121 780660 780886 783207 784160 787290 791230 792414 792973 794086 794523 794537 795452 795803 796528 796533 804205 804917 806808 811545 814502 816719 818378 818840 818927 822706 823601 823894 824385 824426 825130 825599 825752 825927 825942 826044 826702 827529 827856 828148 828738 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home girl"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home девушк"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home девушк"
]
|
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.