Query Metrics
7
Database Queries
7
Different statements
153.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.00 ms (86.13%) |
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 35136 386569 396415 419344 424238 427031 432490 433878 435610 438935 445864 456764 468299 472683 475387 490607 507104 510819 511163 513023 522052 526664 540072 541720 544727 552275 553315 559935 560044 560059 563551 566421 577725 586135 586220 592196 592382 594510 595484 595613 599577 614842 619924 622521 630983 631542 632824 645528 653481 660028 666155 675132 675723 679200 680432 687755 695714 702238 702307 706041 707851 709586 712939 723716 724043 725524 726414 730530 737889 739841 742078 742089 742556 746176 749384 751327 754883 755152 758354 763033 767429 767782 768141 768289 768670 768751 770041 773797 775234 783081 783577 783735 784966 785012 785041 786083 787994 788003 793230 794438 795753 796657 800978 801410 803944 804329 809921 814297 818286 818771 819484 823369 824337 825639 825877 826034 826802 827937 828438 ] |
||||||||||||||||||||||||||||||
|
11.75 ms (7.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 35136 419344 814297 475387 522052 513023 507104 526664 468299 560059 577725 541720 559935 560044 645528 653481 675132 712939 706041 660028 666155 680432 695714 707851 592196 586135 599577 595484 595613 619924 630983 632824 594510 622521 627449 783081 784966 787994 783735 786083 795753 800978 809921 725524 758354 767429 793230 794438 801410 742078 754883 755152 768751 723716 724043 726414 730530 742556 746176 763033 767782 768670 739841 768141 768289 770041 773797 737889 751327 614842 631542 702238 702307 709586 775234 785012 785041 788003 803944 804329 427031 432490 435610 433878 386569 396415 819484 818771 824337 825639 825877 826802 818286 823369 827937 540072 783577 749384 742089 687755 796657 511163 566421 472683 456764 826034 828438 553315 552275 544727 424238 675723 592382 445864 490607 510819 563551 679200 586220 438935 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.90%) |
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 35136 386569 396415 419344 424238 427031 432490 433878 435610 438935 445864 456764 468299 472683 475387 490607 507104 510819 511163 513023 522052 526664 540072 541720 544727 552275 553315 559935 560044 560059 563551 566421 577725 586135 586220 592196 592382 594510 595484 595613 599577 614842 619924 622521 630983 631542 632824 645528 653481 660028 666155 675132 675723 679200 680432 687755 695714 702238 702307 706041 707851 709586 712939 723716 724043 725524 726414 730530 737889 739841 742078 742089 742556 746176 749384 751327 754883 755152 758354 763033 767429 767782 768141 768289 768670 768751 770041 773797 775234 783081 783577 783735 784966 785012 785041 786083 787994 788003 793230 794438 795753 796657 800978 801410 803944 804329 809921 814297 818286 818771 819484 823369 824337 825639 825877 826034 826802 827937 828438 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties wife"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел жен"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.87%) |
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.