Query Metrics
7
Database Queries
7
Different statements
171.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.34 ms (86.00%) |
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 3533 73204 79781 188034 387130 396421 423632 425532 433464 448039 450684 461185 467926 481120 502788 504664 519856 522626 529103 529663 549642 570089 597910 619900 630152 645006 660026 662914 692124 698244 701005 710880 713652 714360 714906 716010 718053 723591 724015 725221 725237 725437 726398 726627 726888 727559 728492 728778 728947 730163 731025 731259 734623 738325 740593 741088 744184 745926 746693 746725 754229 757650 758096 759017 759917 759939 761011 761278 761915 764135 765025 765788 766260 766437 768236 768290 776999 778281 778530 779533 780427 782043 782707 788151 789152 790298 791202 791411 791548 792918 794169 794777 795015 795987 796679 797358 797969 798594 800333 801909 802051 803062 803699 803726 804517 812386 815022 817373 823965 824115 825557 826095 826166 827218 827329 827589 828740 828788 828837 828861 ] |
||||||||||||||||||||||||||||||
|
12.42 ms (7.25%) |
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 789152 746725 768236 728947 768290 761915 728492 714360 718053 795015 725221 745926 188034 502788 794777 757650 645006 529103 73204 726398 726627 713652 731259 801909 425532 817373 826095 826166 723591 827589 827329 823965 828788 827218 448039 481120 660026 619900 778530 780427 782043 795987 800333 803699 726888 741088 761011 761278 766260 791548 794169 796679 798594 802051 766437 725237 734623 764135 728778 740593 765788 776999 710880 597910 812386 759017 828837 828861 387130 461185 396421 570089 738325 797358 522626 423632 759917 803726 450684 79781 529663 549642 698244 782707 779533 746693 725437 727559 724015 754229 630152 792918 788151 3533 519856 828740 692124 433464 716010 730163 815022 759939 731025 758096 765025 467926 504664 744184 803062 824115 825557 701005 714906 662914 790298 791202 804517 778281 797969 791411 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (2.20%) |
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 3533 73204 79781 188034 387130 396421 423632 425532 433464 448039 450684 461185 467926 481120 502788 504664 519856 522626 529103 529663 549642 570089 597910 619900 630152 645006 660026 662914 692124 698244 701005 710880 713652 714360 714906 716010 718053 723591 724015 725221 725237 725437 726398 726627 726888 727559 728492 728778 728947 730163 731025 731259 734623 738325 740593 741088 744184 745926 746693 746725 754229 757650 758096 759017 759917 759939 761011 761278 761915 764135 765025 765788 766260 766437 768236 768290 776999 778281 778530 779533 780427 782043 782707 788151 789152 790298 791202 791411 791548 792918 794169 794777 795015 795987 796679 797358 797969 798594 800333 801909 802051 803062 803699 803726 804517 812386 815022 817373 823965 824115 825557 826095 826166 827218 827329 827589 828740 828788 828837 828861 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum in mother"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum мам женщин"
]
|
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.