Query Metrics
7
Database Queries
7
Different statements
362.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.18 ms (57.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск огромные"
]
|
||||||||||||||||||||||||||||||
|
130.49 ms (36.04%) |
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 33821 154127 391944 391954 403439 416634 416678 416707 416708 419640 421257 423784 424765 426519 438880 440045 441040 441050 445365 445651 445950 446799 447140 449173 450948 452338 452810 455918 459357 460765 461894 462605 467568 469833 470428 478489 479738 480263 480450 483684 489331 494781 499921 502894 505356 507181 509643 511670 516676 517879 518941 519374 520918 524678 524788 524803 525431 531347 532483 534665 539319 541274 542146 547478 553430 559784 562012 562019 563267 563728 567561 578654 582330 582595 583049 596684 597875 609959 610716 618066 621457 651693 660412 668701 671043 678713 695869 707432 707689 715460 715462 730722 735906 739125 745126 745309 752632 752633 752644 752660 752683 767668 770253 770263 770264 770404 770800 773670 775982 776209 784681 786668 787966 794690 802591 804234 808742 811125 824701 825805 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (4.34%) |
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 752683 770263 770800 784681 811125 752632 745126 773670 770253 770264 735906 752633 752644 770404 707432 775982 403439 423784 440045 446799 469833 421257 524788 426519 517879 518941 489331 678713 618066 154127 391944 416707 441040 445365 445651 452338 455918 470428 479738 511670 499921 524678 507181 494781 516676 519374 532483 483684 541274 578654 553430 567561 582595 542146 671043 715462 660412 651693 668701 695869 715460 563267 596684 804234 776209 787966 808742 739125 745309 730722 752660 391954 416708 419640 462605 450948 478489 452810 480263 480450 441050 445950 509643 502894 582330 583049 563728 707689 597875 610716 621457 609959 33821 825805 794690 539319 416634 524803 459357 525431 786668 824701 767668 802591 416678 438880 424765 467568 449173 447140 460765 505356 534665 520918 531347 461894 547478 562019 559784 562012 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (0.72%) |
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 33821 154127 391944 391954 403439 416634 416678 416707 416708 419640 421257 423784 424765 426519 438880 440045 441040 441050 445365 445651 445950 446799 447140 449173 450948 452338 452810 455918 459357 460765 461894 462605 467568 469833 470428 478489 479738 480263 480450 483684 489331 494781 499921 502894 505356 507181 509643 511670 516676 517879 518941 519374 520918 524678 524788 524803 525431 531347 532483 534665 539319 541274 542146 547478 553430 559784 562012 562019 563267 563728 567561 578654 582330 582595 583049 596684 597875 609959 610716 618066 621457 651693 660412 668701 671043 678713 695869 707432 707689 715460 715462 730722 735906 739125 745126 745309 752632 752633 752644 752660 752683 767668 770253 770263 770264 770404 770800 773670 775982 776209 784681 786668 787966 794690 802591 804234 808742 811125 824701 825805 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade huge"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск огромные"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.