Query Metrics
7
Database Queries
7
Different statements
160.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.37 ms (81.62%) |
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 79942 104130 213316 381860 381983 382420 391439 397856 410308 422819 424001 424427 426771 427660 432425 432431 432436 432467 432504 432534 432540 433045 433385 433594 433707 433751 433768 433822 433829 436393 441188 445187 448781 461620 465887 470120 483855 490543 498169 500890 504014 505992 514996 519055 524089 524136 526880 527983 546890 546970 561916 568643 568655 572889 580027 583538 584483 585939 588373 599487 601446 603406 607304 626642 627182 657831 677860 686862 689388 695759 699533 699908 704281 710093 710854 711990 723655 723668 725139 725466 730742 732166 735834 735864 735959 740716 742110 742713 749461 750890 750922 751244 753500 753506 755138 758693 759951 760881 761834 767634 767639 767984 768691 768695 779177 782969 791750 791753 791758 792127 794730 795528 797034 799021 812446 812461 812464 812728 ] |
||||||||||||||||||||||||||||||
|
18.61 ms (11.56%) |
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 740716 750922 753506 792127 797034 750890 755138 767634 749461 760878 730742 732166 753500 758693 699533 779177 397856 382420 601446 761834 432534 422819 483855 514996 568655 448781 527983 519055 441188 432425 677860 657831 695759 627182 812446 723668 759951 699908 812461 433594 599487 588373 742110 607304 213316 104130 427660 461620 490543 470120 546970 572889 568643 436393 433829 424001 424427 432436 445187 410308 524136 381860 381983 391439 432467 433045 723655 504014 465887 711990 710854 689388 791753 799021 791750 794730 795528 812728 725466 751244 735864 742713 768695 767639 757577 704281 812464 505992 580027 583538 626642 433385 500890 498169 584483 433768 546890 603406 725139 561916 710093 782969 791758 735959 760881 768691 735834 767984 79942 433751 433822 432431 432504 432540 426771 433707 526880 686862 585939 524089 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (2.31%) |
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 79942 104130 213316 381860 381983 382420 391439 397856 410308 422819 424001 424427 426771 427660 432425 432431 432436 432467 432504 432534 432540 433045 433385 433594 433707 433751 433768 433822 433829 436393 441188 445187 448781 461620 465887 470120 483855 490543 498169 500890 504014 505992 514996 519055 524089 524136 526880 527983 546890 546970 561916 568643 568655 572889 580027 583538 584483 585939 588373 599487 601446 603406 607304 626642 627182 657831 677860 686862 689388 695759 699533 699908 704281 710093 710854 711990 723655 723668 725139 725466 730742 732166 735834 735864 735959 740716 742110 742713 749461 750890 750922 751244 753500 753506 755138 758693 759951 760881 761834 767634 767639 767984 768691 768695 779177 782969 791750 791753 791758 792127 794730 795528 797034 799021 812446 812461 812464 812728 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в колготках сперма"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"колготк сперм"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.86%) |
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.