Query Metrics
7
Database Queries
7
Different statements
410.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.37 ms (52.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"vintage длинные"
]
|
||||||||||||||||||||||||||||||
|
168.53 ms (41.10%) |
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 492442 538862 538931 540446 541309 541361 542487 544257 544264 544272 544312 546625 550036 550328 551681 560087 563452 565123 566293 566299 567995 568018 571837 573321 573919 574227 574282 576122 581279 581339 583858 592391 592470 592539 592543 594186 608040 614321 614354 614741 614989 620175 625757 625796 626556 628319 629286 629324 629902 643033 644287 644953 646337 648209 648912 649933 651205 651603 651681 652252 652269 653577 668160 670067 671705 672717 673493 673531 674131 677738 685220 687192 690774 690823 690850 691509 691521 691527 692214 692222 692418 693060 693863 693991 694110 694127 694214 695204 695242 695921 695950 696248 696358 696554 698513 698579 699383 699540 699698 699708 708785 709720 716786 718489 718518 722142 725176 730225 730272 730524 733299 733539 740296 742138 742803 744443 744566 746581 752728 790407 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (3.83%) |
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 746581 730272 742803 744566 629286 629902 718489 581339 668160 592470 628319 709720 541309 644953 538862 538931 565123 567995 573321 581279 542487 544257 544312 550036 574282 653577 695242 695950 699383 699698 651603 651681 677738 691509 692222 694110 695204 695921 716786 722142 648209 649933 651205 670067 672717 674131 687192 690823 690850 691521 692214 693060 576122 592539 592391 614321 614989 620175 626556 643033 614354 644287 740296 742138 544264 573919 583858 685220 540446 544272 560087 571837 566299 546625 566293 568018 646337 652252 690774 693863 696554 648912 673493 673531 693991 694127 694214 696358 698513 698579 699540 652269 671705 691527 692418 696248 708785 550328 551681 563452 574227 592543 594186 614741 625796 790407 730225 725176 730524 733299 744443 733539 752728 608040 625757 629324 699708 718518 492442 541361 ] |
||||||||||||||||||||||||||||||
|
4.28 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 492442 538862 538931 540446 541309 541361 542487 544257 544264 544272 544312 546625 550036 550328 551681 560087 563452 565123 566293 566299 567995 568018 571837 573321 573919 574227 574282 576122 581279 581339 583858 592391 592470 592539 592543 594186 608040 614321 614354 614741 614989 620175 625757 625796 626556 628319 629286 629324 629902 643033 644287 644953 646337 648209 648912 649933 651205 651603 651681 652252 652269 653577 668160 670067 671705 672717 673493 673531 674131 677738 685220 687192 690774 690823 690850 691509 691521 691527 692214 692222 692418 693060 693863 693991 694110 694127 694214 695204 695242 695921 695950 696248 696358 696554 698513 698579 699383 699540 699698 699708 708785 709720 716786 718489 718518 722142 725176 730225 730272 730524 733299 733539 740296 742138 742803 744443 744566 746581 752728 790407 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vintage long"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"vintage длинные"
]
|
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.