Query Metrics
7
Database Queries
7
Different statements
158.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.72 ms (82.44%) |
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 14328 14534 97688 161485 326134 360065 381941 382662 383439 385784 391386 395402 395503 395504 396594 396614 399320 399710 402153 410057 410780 411681 412419 414681 416869 419483 419862 419989 420307 420695 420762 422732 424937 428432 429088 433047 433762 435515 435624 436118 445733 445740 447143 448200 448987 449933 450204 450224 451560 452282 452283 456109 458625 459668 460501 462390 464194 464345 465698 466552 466858 467583 467632 468009 468035 471723 475630 478527 478672 479709 480417 481663 481664 482800 486214 487747 488897 490132 490574 494277 494290 496314 496330 499332 499336 507944 511713 512903 513005 513736 524859 525948 527447 527659 529360 535013 536910 543881 545828 554392 554525 557557 565916 567139 567141 568059 582376 584720 584754 588285 597121 605545 612792 620499 621612 657296 657361 658082 658405 792627 ] |
||||||||||||||||||||||||||||||
|
17.37 ms (10.95%) |
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 481663 513005 436118 496314 396594 14328 360065 658082 512903 447143 448200 449933 433047 467632 161485 382662 395504 416869 468035 422732 435515 490132 465698 466858 452283 499336 468009 487747 420762 481664 14534 486214 475630 657361 620499 527447 513736 490574 554525 381941 419862 588285 448987 452282 450224 529360 499332 524859 402153 424937 460501 428432 399320 567141 496330 597121 419483 419989 420695 395503 395402 458625 459668 399710 414681 511713 525948 658405 567139 568059 582376 479709 535013 97688 396614 433762 494277 557557 565916 464194 450204 456109 494290 584720 584754 507944 383439 326134 410057 410780 462390 464345 792627 385784 420307 480417 451560 471723 412419 488897 536910 554392 657296 612792 435624 467583 445733 466552 527659 543881 545828 605545 429088 482800 445740 411681 621612 478672 478527 391386 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.74%) |
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 14328 14534 97688 161485 326134 360065 381941 382662 383439 385784 391386 395402 395503 395504 396594 396614 399320 399710 402153 410057 410780 411681 412419 414681 416869 419483 419862 419989 420307 420695 420762 422732 424937 428432 429088 433047 433762 435515 435624 436118 445733 445740 447143 448200 448987 449933 450204 450224 451560 452282 452283 456109 458625 459668 460501 462390 464194 464345 465698 466552 466858 467583 467632 468009 468035 471723 475630 478527 478672 479709 480417 481663 481664 482800 486214 487747 488897 490132 490574 494277 494290 496314 496330 499332 499336 507944 511713 512903 513005 513736 524859 525948 527447 527659 529360 535013 536910 543881 545828 554392 554525 557557 565916 567139 567141 568059 582376 584720 584754 588285 597121 605545 612792 620499 621612 657296 657361 658082 658405 792627 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð©ðÀð╝ðÁð¢ð©ð╗ð░ ð╝ÐâðÂÐâ Ðü ð¢ðÁð│ÐÇð¥ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен жен чернокожий"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.07%) |
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.