Query Metrics
7
Database Queries
7
Different statements
174.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.74 ms (85.94%) |
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 77013 281567 386893 390910 392449 396013 396307 396836 400418 400441 405082 405288 416377 417373 429565 432107 442353 447862 448516 453553 456929 463129 466966 467372 468756 473797 479749 482695 486185 487921 492552 492601 492610 493015 495147 497515 498876 499891 504145 508818 509369 512049 512103 515195 519969 523262 523532 526033 534112 545521 545528 555885 559602 562314 569523 569861 570048 570056 570065 570071 573065 573743 577794 578131 578477 586761 587309 594173 594929 596470 596669 598210 598444 598545 599095 600060 600516 606822 611907 612023 620200 622411 645618 654785 657878 663174 663524 664842 667855 672753 674108 679386 699480 702904 712249 713840 714415 720761 722676 722694 724137 725762 726461 727767 732888 734638 736411 737445 737673 741953 741983 747461 757976 759484 759596 761675 764880 768944 789187 816232 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (8.77%) |
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 732888 734638 725762 727767 741983 741953 761675 764880 611907 699480 789187 392449 396013 417373 432107 442353 429565 448516 473797 447862 453553 486185 515195 498876 512049 495147 519969 526033 463129 545528 555885 570048 570065 570071 562314 569523 569861 577794 578477 663524 545521 570056 573065 596669 594929 596470 598444 599095 587309 586761 594173 416377 466966 396836 400441 405288 468756 396307 405082 499891 509369 487921 492552 512103 523262 492601 492610 497515 523532 493015 508818 281567 400418 482695 456929 645618 672753 737445 736411 726461 737673 504145 606822 598545 600060 77013 386893 390910 816232 467372 479749 534112 573743 559602 667855 702904 712249 713840 720761 664842 674108 722676 654785 657878 663174 679386 714415 722694 578131 600516 622411 598210 620200 724137 747461 759596 757976 759484 768944 612023 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.43%) |
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 77013 281567 386893 390910 392449 396013 396307 396836 400418 400441 405082 405288 416377 417373 429565 432107 442353 447862 448516 453553 456929 463129 466966 467372 468756 473797 479749 482695 486185 487921 492552 492601 492610 493015 495147 497515 498876 499891 504145 508818 509369 512049 512103 515195 519969 523262 523532 526033 534112 545521 545528 555885 559602 562314 569523 569861 570048 570056 570065 570071 573065 573743 577794 578131 578477 586761 587309 594173 594929 596470 596669 598210 598444 598545 599095 600060 600516 606822 611907 612023 620200 622411 645618 654785 657878 663174 663524 664842 667855 672753 674108 679386 699480 702904 712249 713840 714415 720761 722676 722694 724137 725762 726461 727767 732888 734638 736411 737445 737673 741953 741983 747461 757976 759484 759596 761675 764880 768944 789187 816232 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man cock"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин cock"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин cock"
]
|
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.