Query Metrics
7
Database Queries
7
Different statements
173.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.34 ms (83.63%) |
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 386858 406172 408332 408439 408458 414364 420624 426249 426354 428235 451246 452987 458783 460396 460402 461704 461714 463118 464919 465302 475933 480210 485151 487937 488363 488377 493763 494697 496780 498555 506836 508750 511387 515481 522970 523556 523562 523564 530646 530713 535591 536289 537915 547237 548153 551107 554792 560985 572702 578208 583724 586931 589103 593842 597518 600016 600225 601622 603156 604597 606489 612070 619531 620775 621794 626887 627740 630018 631607 632570 637098 640388 641687 643396 647935 648534 653216 667026 668490 669340 670826 670839 698773 700990 705817 716760 716903 721999 725634 731279 735966 737114 741187 744618 744987 745353 754127 755573 759785 761290 765714 766590 766880 770276 776973 777065 779193 789647 790239 790409 794702 795396 795690 796703 797080 800533 805504 811128 811863 815033 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (9.91%) |
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 506836 578208 606489 725634 797080 480210 653216 776973 737114 745353 548153 698773 420624 508750 777065 811128 485151 493763 619531 721999 643396 603156 795690 755573 794702 761290 612070 779193 428235 426354 460396 770276 593842 406172 535591 741187 522970 551107 572702 426249 487937 488377 523556 796703 511387 621794 744987 632570 386858 759785 589103 648534 601622 637098 789647 744618 716760 790239 670826 463118 530713 667026 716903 669340 620775 735966 515481 408458 488363 670839 627740 630018 464919 631607 554792 461704 461714 451246 700990 668490 586931 790409 800533 805504 766880 795396 811863 754127 604597 458783 465302 530646 408332 547237 498555 523564 494697 496780 560985 641687 597518 640388 765714 460402 731279 536289 600225 475933 583724 523562 414364 537915 408439 766590 815033 626887 452987 705817 647935 600016 ] |
||||||||||||||||||||||||||||||
|
3.63 ms (2.09%) |
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 386858 406172 408332 408439 408458 414364 420624 426249 426354 428235 451246 452987 458783 460396 460402 461704 461714 463118 464919 465302 475933 480210 485151 487937 488363 488377 493763 494697 496780 498555 506836 508750 511387 515481 522970 523556 523562 523564 530646 530713 535591 536289 537915 547237 548153 551107 554792 560985 572702 578208 583724 586931 589103 593842 597518 600016 600225 601622 603156 604597 606489 612070 619531 620775 621794 626887 627740 630018 631607 632570 637098 640388 641687 643396 647935 648534 653216 667026 668490 669340 670826 670839 698773 700990 705817 716760 716903 721999 725634 731279 735966 737114 741187 744618 744987 745353 754127 755573 759785 761290 765714 766590 766880 770276 776973 777065 779193 789647 790239 790409 794702 795396 795690 796703 797080 800533 805504 811128 811863 815033 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"destroyed anal sex"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"destroyed анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"destroyed анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.