Query Metrics
7
Database Queries
7
Different statements
169.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.48 ms (86.65%) |
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 420829 435581 435602 435609 438396 439290 444265 450364 452698 452726 457543 457548 463237 496814 508759 512415 514226 542235 544899 544915 545149 546040 546046 548917 549040 550912 550933 554101 557833 560047 560503 565031 576497 576880 581505 585260 585359 587094 587491 588728 598242 600731 604659 605087 605564 608006 610263 613899 620974 620992 630088 636495 642128 642969 644821 647534 652757 656167 656523 660817 668303 672680 673901 683270 686183 692756 693692 704079 708405 709679 710493 710795 717497 718880 735145 737644 741577 742306 745715 747474 749762 760203 765251 765688 767707 768061 773336 774663 775641 775650 777661 779835 785566 786066 787194 792268 793005 795012 796385 796414 797852 800298 801580 802586 804028 804712 806142 806803 807170 809632 809684 812314 812595 812946 816878 818359 824402 824766 827423 827499 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (7.66%) |
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 598242 452698 546046 786066 452726 420829 818359 827499 816878 824402 512415 542235 544899 545149 548917 549040 550933 560047 550912 576880 692756 718880 656167 672680 710795 544915 560503 585260 636495 777661 785566 793005 760203 737644 749762 765251 767707 800298 804028 806803 450364 652757 435581 435609 435602 827423 457543 457548 463237 514226 565031 576497 686183 717497 642128 604659 779835 787194 795012 801580 804712 812314 774663 775650 792268 807170 741577 742306 796385 796414 797852 809684 812595 812946 735145 747474 765688 773336 775641 802586 806142 809632 439290 508759 546040 557833 660817 673901 683270 704079 647534 656523 693692 710493 585359 613899 630088 588728 608006 620974 620992 642969 605564 709679 644821 581505 668303 708405 554101 587491 600731 587094 610263 745715 605087 768061 444265 438396 824766 496814 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.44%) |
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 420829 435581 435602 435609 438396 439290 444265 450364 452698 452726 457543 457548 463237 496814 508759 512415 514226 542235 544899 544915 545149 546040 546046 548917 549040 550912 550933 554101 557833 560047 560503 565031 576497 576880 581505 585260 585359 587094 587491 588728 598242 600731 604659 605087 605564 608006 610263 613899 620974 620992 630088 636495 642128 642969 644821 647534 652757 656167 656523 660817 668303 672680 673901 683270 686183 692756 693692 704079 708405 709679 710493 710795 717497 718880 735145 737644 741577 742306 745715 747474 749762 760203 765251 765688 767707 768061 773336 774663 775641 775650 777661 779835 785566 786066 787194 792268 793005 795012 796385 796414 797852 800298 801580 802586 804028 804712 806142 806803 807170 809632 809684 812314 812595 812946 816878 818359 824402 824766 827423 827499 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"clit homemade"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"clit домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"clit домашн любительск"
]
|
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.