Query Metrics
7
Database Queries
7
Different statements
188.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.67 ms (86.31%) |
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 524969 538865 538892 538945 541313 541651 542493 542500 543475 544274 544325 546447 548297 549767 556597 556842 561033 561615 562838 563133 563137 563139 563198 563213 563221 563383 563423 563445 566673 567396 568362 571241 573392 574222 576625 576647 576651 576676 576694 577370 580258 580852 581119 581269 583882 589640 589700 589747 592463 592494 593236 593447 593820 595842 598058 598373 600712 605305 615741 615744 619082 619468 619482 620142 620156 621312 621322 622372 624154 624790 624792 628312 633161 644280 644331 644639 648204 648256 649498 649560 650494 651210 651684 652876 669566 670107 671734 672117 672745 677706 681059 690902 694203 694563 695249 695276 695613 695626 697368 697369 697790 698550 703048 703511 706611 707306 708422 711903 711907 716409 717859 719873 724241 727828 731305 734493 744294 748471 789844 808093 ] |
||||||||||||||||||||||||||||||
|
16.54 ms (8.77%) |
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 581269 563221 576625 576676 576694 580258 690902 707306 648204 648256 649498 711903 670107 562838 577370 592463 619082 589747 615741 605305 619468 628312 589640 624154 615744 621312 644280 644639 581119 697790 593820 624792 538945 556597 556842 567396 583882 542500 544274 574222 561615 563445 649560 650494 695276 716409 677706 694563 697369 706611 717859 719873 671734 695249 708422 561033 563137 563213 563423 598058 622372 620142 595842 620156 593236 619482 789844 808093 727828 734493 698550 568362 563198 524969 538865 538892 541313 573392 580852 563383 566673 542493 544325 563139 651210 651684 652876 669566 672117 681059 672745 694203 695613 695626 703048 711907 697368 576647 598373 589700 592494 593447 633161 600712 621322 744294 724241 731305 748471 624790 644331 703511 548297 546447 541651 543475 549767 576651 563133 571241 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.76%) |
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 524969 538865 538892 538945 541313 541651 542493 542500 543475 544274 544325 546447 548297 549767 556597 556842 561033 561615 562838 563133 563137 563139 563198 563213 563221 563383 563423 563445 566673 567396 568362 571241 573392 574222 576625 576647 576651 576676 576694 577370 580258 580852 581119 581269 583882 589640 589700 589747 592463 592494 593236 593447 593820 595842 598058 598373 600712 605305 615741 615744 619082 619468 619482 620142 620156 621312 621322 622372 624154 624790 624792 628312 633161 644280 644331 644639 648204 648256 649498 649560 650494 651210 651684 652876 669566 670107 671734 672117 672745 677706 681059 690902 694203 694563 695249 695276 695613 695626 697368 697369 697790 698550 703048 703511 706611 707306 708422 711903 711907 716409 717859 719873 724241 727828 731305 734493 744294 748471 789844 808093 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ретро зрелой"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.