Query Metrics
7
Database Queries
7
Different statements
351.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.39 ms (59.28%) |
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 410843 414009 428128 457902 461037 463083 466481 471170 472831 474591 475986 482688 484795 485160 486449 488935 490586 491299 496354 497428 503855 507944 507946 508422 511393 513331 515168 516742 518975 519894 521124 521713 521750 521757 524187 524841 524863 524867 529403 529688 531244 532364 533615 534273 534298 534313 538276 539047 539053 540238 542578 545783 547873 549270 550821 553300 554442 556525 571269 572834 578395 593092 595023 601833 604463 610666 613502 614325 614404 614715 615709 620316 629616 633132 635219 636108 640691 642444 642504 645247 650847 656862 673964 736225 741026 747144 756836 760812 771148 774771 787966 788252 789702 790063 790784 790852 792616 792626 792652 792655 801087 803317 803557 805775 806068 806288 808265 808505 808570 808804 809289 812426 812911 814817 814883 814914 815370 815598 815789 816553 ] |
||||||||||||||||||||||||||||||
|
117.45 ms (33.41%) |
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 410843 414009 428128 457902 461037 463083 466481 471170 472831 474591 475986 482688 484795 485160 486449 488935 490586 491299 496354 497428 503855 507944 507946 508422 511393 513331 515168 516742 518975 519894 521124 521713 521750 521757 524187 524841 524863 524867 529403 529688 531244 532364 533615 534273 534298 534313 538276 539047 539053 540238 542578 545783 547873 549270 550821 553300 554442 556525 571269 572834 578395 593092 595023 601833 604463 610666 613502 614325 614404 614715 615709 620316 629616 633132 635219 636108 640691 642444 642504 645247 650847 656862 673964 736225 741026 747144 756836 760812 771148 774771 787966 788252 789702 790063 790784 790852 792616 792626 792652 792655 801087 803317 803557 805775 806068 806288 808265 808505 808570 808804 809289 812426 812911 814817 814883 814914 815370 815598 815789 816553 ] |
||||||||||||||||||||||||||||||
|
18.77 ms (5.34%) |
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 633132 614325 614404 615709 593092 620316 790063 787966 805775 801087 808265 808505 741026 610666 803317 490586 507944 475986 521750 488935 547873 595023 790784 806288 806068 812426 461037 474591 508422 521757 554442 601833 642444 414009 534313 503855 497428 524867 532364 511393 471170 572834 792616 771148 484795 524187 553300 815598 815789 482688 486449 457902 463083 521713 534298 539047 524863 515168 516742 524841 533615 539053 550821 542578 645247 556525 613502 629616 636108 614715 788252 803557 756836 812911 792652 808804 485160 578395 814914 815370 816553 814817 814883 519894 534273 518975 545783 571269 650847 673964 656862 549270 604463 642504 792655 809289 790852 792626 760812 789702 736225 747144 774771 808570 428128 491299 496354 640691 410843 529403 472831 531244 538276 635219 466481 507946 529688 521124 540238 513331 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ebony big boobs"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожая большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чернокожая большие boobs"
]
|
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.