Query Metrics
7
Database Queries
7
Different statements
230.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.95 ms (91.79%) |
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 441646 448078 449327 456807 459295 459556 460040 467880 475462 479277 481102 482615 500583 501615 503642 507263 509051 511418 518245 519403 519624 532718 542056 546728 555909 559672 563691 586266 587997 601407 605058 607981 613678 614805 621348 633934 650514 663433 666418 680585 685676 692592 698375 700915 704917 707927 710007 715281 716158 724475 725519 726468 726596 726723 729001 732698 733269 734343 739899 744142 747959 748398 750218 752740 755416 757280 757512 758659 764153 766236 772423 772430 775564 779928 780546 782765 786205 788407 789237 791095 792003 793314 793517 793713 794524 794798 794860 795052 795080 795086 795914 796090 797852 802290 803577 808690 810052 810058 811989 812316 813349 813501 817943 818148 818485 818976 818981 819297 819431 819754 820095 823551 824306 824411 825056 826054 826079 826381 826980 827040 ] |
||||||||||||||||||||||||||||||
|
10.79 ms (4.67%) |
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 733269 704917 685676 795086 758659 772423 795080 752740 750218 732698 766236 747959 715281 716158 803577 692592 680585 729001 500583 542056 511418 546728 698375 802290 724475 726596 739899 519624 818148 827040 817943 818485 482615 532718 507263 613678 786205 813349 810058 792003 795052 811989 812316 726723 772430 824411 555909 587997 796090 813501 475462 700915 559672 764153 601407 748398 621348 818981 819431 448078 459556 707927 780546 793314 795914 725519 734343 757280 794798 797852 755416 779928 826079 826381 663433 782765 818976 819754 825056 826054 824306 826980 819297 820095 823551 563691 710007 775564 793713 794860 789237 794524 744142 607981 793517 441646 449327 456807 467880 518245 501615 650514 666418 586266 614805 791095 726468 757512 808690 810052 481102 460040 479277 459295 633934 788407 509051 519403 503642 605058 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.04%) |
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 441646 448078 449327 456807 459295 459556 460040 467880 475462 479277 481102 482615 500583 501615 503642 507263 509051 511418 518245 519403 519624 532718 542056 546728 555909 559672 563691 586266 587997 601407 605058 607981 613678 614805 621348 633934 650514 663433 666418 680585 685676 692592 698375 700915 704917 707927 710007 715281 716158 724475 725519 726468 726596 726723 729001 732698 733269 734343 739899 744142 747959 748398 750218 752740 755416 757280 757512 758659 764153 766236 772423 772430 775564 779928 780546 782765 786205 788407 789237 791095 792003 793314 793517 793713 794524 794798 794860 795052 795080 795086 795914 796090 797852 802290 803577 808690 810052 810058 811989 812316 813349 813501 817943 818148 818485 818976 818981 819297 819431 819754 820095 823551 824306 824411 825056 826054 826079 826381 826980 827040 ] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick my pussy"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза my pussy"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза my pussy"
]
|
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.