Query Metrics
7
Database Queries
7
Different statements
559.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
534.17 ms (95.48%) |
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 3561 8867 31563 122634 215337 382281 382483 390642 391668 392104 393498 397876 406012 439521 439591 445943 452640 452936 452964 457998 460208 466198 467929 468675 471081 473391 473479 474126 474138 485773 490380 506142 509995 512503 513568 518598 524612 526494 527409 533655 534035 538791 546988 547609 553753 554235 555248 555408 556875 562465 563343 563912 571123 573801 596025 603322 604906 606071 619385 619628 645921 668827 704992 710585 715037 717125 720540 726543 726553 731357 733455 744213 744350 744769 744807 745991 754649 761121 770040 770174 772621 776425 776455 780824 784162 795648 796319 799880 803201 803393 803505 804457 807209 808302 812522 817277 817576 819233 819250 820366 820688 821005 824073 824341 824361 824529 824779 824835 825360 826702 826768 827092 827289 827400 827438 827479 827609 827619 827686 827721 ] |
||||||||||||||||||||||||||||||
|
14.91 ms (2.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 573801 726543 726553 439521 391668 390642 439591 452936 506142 526494 3561 382281 824529 826702 824073 817576 825360 533655 538791 555248 562465 668827 720540 563912 603322 812522 799880 804457 744769 754649 770040 772621 807209 744350 761121 733455 770174 744213 731357 776425 808302 509995 474126 474138 485773 445943 452640 468675 473479 512503 534035 518598 554235 556875 619385 596025 457998 467929 397876 452964 471081 406012 460208 466198 490380 513568 524612 527409 473391 215337 122634 393498 392104 382483 31563 8867 819250 820688 824835 817277 819233 824341 824779 826768 827092 827289 827438 827479 827619 827400 821005 824361 820366 827721 827609 827686 547609 553753 555408 563343 571123 645921 710585 715037 704992 717125 546988 604906 606071 619628 776455 795648 803201 803393 803505 780824 784162 796319 744807 745991 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.50%) |
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 3561 8867 31563 122634 215337 382281 382483 390642 391668 392104 393498 397876 406012 439521 439591 445943 452640 452936 452964 457998 460208 466198 467929 468675 471081 473391 473479 474126 474138 485773 490380 506142 509995 512503 513568 518598 524612 526494 527409 533655 534035 538791 546988 547609 553753 554235 555248 555408 556875 562465 563343 563912 571123 573801 596025 603322 604906 606071 619385 619628 645921 668827 704992 710585 715037 717125 720540 726543 726553 731357 733455 744213 744350 744769 744807 745991 754649 761121 770040 770174 772621 776425 776455 780824 784162 795648 796319 799880 803201 803393 803505 804457 807209 808302 812522 817277 817576 819233 819250 820366 820688 821005 824073 824341 824361 824529 824779 824835 825360 826702 826768 827092 827289 827400 827438 827479 827609 827619 827686 827721 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation mature"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац mature"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац mature"
]
|
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.