Query Metrics
7
Database Queries
7
Different statements
171.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.20 ms (85.98%) |
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 416007 418128 418671 418730 449319 450038 451106 463420 469408 478101 500320 530429 533099 533276 541755 541757 550926 551543 567514 572978 576448 577023 581392 584460 584577 584987 586891 598220 605742 618267 627472 629771 636414 657197 666680 668305 669945 672850 678838 683062 686138 692743 695470 705478 706765 712286 714083 724438 724987 725602 729204 738460 739930 740848 741220 741222 747483 750653 751705 752780 756713 762147 767695 768508 770254 773016 773056 773059 773076 773183 774878 775227 776065 776081 777807 777926 777989 778230 778808 780038 780080 780239 780553 783920 783937 784456 784513 785073 785170 785340 785670 785678 785780 786088 786368 786858 787124 787812 790463 792025 793259 794674 794931 796194 797032 798287 798674 801532 801628 801827 806597 806991 807010 807066 808262 808651 810150 811343 820020 824879 ] |
||||||||||||||||||||||||||||||
|
14.45 ms (8.44%) |
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 572978 478101 576448 672850 714083 794674 806597 775227 777926 780038 740848 786088 773056 773059 724438 741220 773076 778808 785073 807066 541757 636414 605742 586891 756713 792025 768508 785678 584460 463420 450038 706765 598220 820020 577023 551543 581392 776081 777807 780239 794931 798674 797032 767695 786858 729204 773016 739930 725602 773183 750653 752780 618267 776065 783937 785170 787812 584577 780080 416007 418730 469408 449319 451106 686138 669945 786368 784513 796194 811343 741222 747483 751705 770254 807010 418128 584987 530429 541755 801532 692743 785670 774878 762147 500320 533099 567514 787124 793259 798287 801827 785340 790463 806991 783920 784456 808651 810150 724987 824879 533276 666680 683062 705478 712286 695470 629771 418671 550926 657197 668305 678838 627472 777989 778230 780553 785780 738460 801628 808262 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.47%) |
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 416007 418128 418671 418730 449319 450038 451106 463420 469408 478101 500320 530429 533099 533276 541755 541757 550926 551543 567514 572978 576448 577023 581392 584460 584577 584987 586891 598220 605742 618267 627472 629771 636414 657197 666680 668305 669945 672850 678838 683062 686138 692743 695470 705478 706765 712286 714083 724438 724987 725602 729204 738460 739930 740848 741220 741222 747483 750653 751705 752780 756713 762147 767695 768508 770254 773016 773056 773059 773076 773183 774878 775227 776065 776081 777807 777926 777989 778230 778808 780038 780080 780239 780553 783920 783937 784456 784513 785073 785170 785340 785670 785678 785780 786088 786368 786858 787124 787812 790463 792025 793259 794674 794931 796194 797032 798287 798674 801532 801628 801827 806597 806991 807010 807066 808262 808651 810150 811343 820020 824879 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женский оргазм домашка"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женск оргазм домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.89%) |
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.