Query Metrics
7
Database Queries
7
Different statements
138.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.99 ms (84.50%) |
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 3599 88760 145635 233618 238244 387477 396903 438560 464060 512142 530546 534628 537276 611312 624390 628878 630011 631334 636877 640293 641367 645058 651591 667058 696526 698608 701174 702906 705117 712171 715846 717801 718910 725196 727902 727910 732594 733334 734015 734515 734699 734726 734775 737208 738167 739087 744770 745616 745876 746174 747196 748044 748183 750671 751780 755565 756761 757240 758074 758146 758310 759083 759927 761259 762623 763895 764203 765085 765387 767141 768630 769566 773971 780686 783210 784128 786106 789470 790242 792969 794108 795646 795823 796698 797254 797853 799533 800056 800140 800461 800973 801080 802401 804857 805130 806813 811708 812441 813309 816734 817575 817740 817775 818693 818949 819155 819181 821988 823464 824366 824489 824674 824799 824839 825366 825478 825579 826048 826205 ] |
||||||||||||||||||||||||||||||
|
11.62 ms (8.40%) |
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 628878 636877 789470 790242 792969 800973 811708 813309 796698 797853 800140 800461 812441 727910 733334 737208 739087 744770 750671 762623 764203 800056 804857 725196 727902 734515 745616 745876 746174 748044 748183 756761 761259 765085 734775 751780 755565 758146 759927 763895 765387 747196 768442 768630 769566 758074 630011 705117 712171 717801 780686 784128 795646 801080 805130 806813 233618 238244 438560 718910 3599 396903 818949 824366 645058 651591 667058 786106 702906 696526 738167 534628 715846 701174 640293 611312 641367 794108 795823 799533 734726 758310 759083 767141 783210 734015 757240 732594 734699 631334 698608 797254 512142 624390 802401 773971 145635 88760 387477 819181 824674 826048 826205 823464 824839 825366 816734 817575 817775 818693 824489 817740 819155 821988 824799 825478 825579 464060 530546 537276 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.25%) |
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 3599 88760 145635 233618 238244 387477 396903 438560 464060 512142 530546 534628 537276 611312 624390 628878 630011 631334 636877 640293 641367 645058 651591 667058 696526 698608 701174 702906 705117 712171 715846 717801 718910 725196 727902 727910 732594 733334 734015 734515 734699 734726 734775 737208 738167 739087 744770 745616 745876 746174 747196 748044 748183 750671 751780 755565 756761 757240 758074 758146 758310 759083 759927 761259 762623 763895 764203 765085 765387 767141 768630 769566 773971 780686 783210 784128 786106 789470 790242 792969 794108 795646 795823 796698 797254 797853 799533 800056 800140 800461 800973 801080 802401 804857 805130 806813 811708 812441 813309 816734 817575 817740 817775 818693 818949 819155 819181 821988 823464 824366 824489 824674 824799 824839 825366 825478 825579 826048 826205 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife sexy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен sexy"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен sexy"
]
|
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.