Query Metrics
7
Database Queries
7
Different statements
161.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.13 ms (84.42%) |
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 148101 263917 394338 396571 399514 402095 402953 407072 407653 433704 452630 453461 462018 465640 483404 549474 563124 573249 574382 596153 605362 610058 626308 643384 660008 680617 683770 687605 687936 688254 689827 689945 695721 696987 696990 705067 710555 712335 712688 713459 714929 715039 716508 718085 719276 721616 724369 724860 726370 728231 734309 734461 734779 740205 742861 742956 744735 745435 753656 754532 757280 764624 765889 766516 766892 770151 779551 779906 780409 781029 781615 784786 786283 786396 787149 788583 788831 788883 788941 789480 789510 790367 790400 791201 793368 793467 795060 795209 795750 795978 797015 800085 800671 800716 801465 802211 802394 803436 804517 805689 805704 806290 808438 813924 816732 817279 818308 818911 819717 819919 820155 820211 823847 824673 824678 824990 827140 827339 827705 ] |
||||||||||||||||||||||||||||||
|
13.67 ms (8.48%) |
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 734461 790367 801465 402095 263917 407072 433704 817279 818911 823847 818308 819717 828272 696987 689827 689945 788831 795209 797015 787149 808438 764624 728231 765889 781029 789510 148101 407653 462018 465640 483404 563124 683770 790400 800716 766516 742956 744735 745435 820155 712335 779551 757280 805704 452630 396571 399514 816732 819919 824678 827140 827339 827705 824673 813924 824990 573249 574382 549474 680617 688254 710555 716508 687605 687936 714929 660008 695721 712688 718085 605362 643384 786283 786396 800085 804517 779906 788941 795060 795978 800671 802211 805689 734779 754532 788583 793467 803436 806290 734309 740205 753656 724369 724860 726370 770151 610058 626308 696990 705067 713459 715039 719276 780409 788883 802394 596153 784786 791201 742861 781615 766892 795750 394338 402953 820211 721616 789480 453461 793368 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (2.49%) |
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 148101 263917 394338 396571 399514 402095 402953 407072 407653 433704 452630 453461 462018 465640 483404 549474 563124 573249 574382 596153 605362 610058 626308 643384 660008 680617 683770 687605 687936 688254 689827 689945 695721 696987 696990 705067 710555 712335 712688 713459 714929 715039 716508 718085 719276 721616 724369 724860 726370 728231 734309 734461 734779 740205 742861 742956 744735 745435 753656 754532 757280 764624 765889 766516 766892 770151 779551 779906 780409 781029 781615 784786 786283 786396 787149 788583 788831 788883 788941 789480 789510 790367 790400 791201 793368 793467 795060 795209 795750 795978 797015 800085 800671 800716 801465 802211 802394 803436 804517 805689 805704 806290 808438 813924 816732 817279 818308 818911 819717 819919 820155 820211 823847 824673 824678 824990 827140 827339 827705 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom минет оральн секс"
]
|
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.