Query Metrics
7
Database Queries
7
Different statements
453.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
430.15 ms (94.90%) |
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 129916 181454 382285 386062 386678 393693 395583 395664 395698 398157 399380 411218 411507 445665 455311 460090 468749 503359 511378 532212 552068 554070 554188 557250 560514 563328 565383 585540 586612 596584 598111 600182 604625 606641 607253 609240 612438 613929 620685 620711 624653 625408 628651 633615 633722 634541 637527 637690 638727 639178 640033 649276 666654 677347 681490 682080 682964 683587 686357 693489 708919 717656 718877 719728 720458 720873 722597 722646 724690 727797 732261 734388 734461 741996 743331 745250 747181 747368 749456 756488 756523 757549 760816 761970 763199 767857 767861 771015 775852 776219 777190 777674 777948 778839 779417 785776 786824 790256 795826 798766 799016 799276 800196 800387 800410 803342 804478 805695 806192 807396 809211 817244 817272 817748 820977 821189 823454 823720 823721 827971 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (2.98%) |
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 786824 807396 743331 799276 806192 724690 732261 761970 749456 756488 785776 398157 677347 734461 455311 554070 640033 181454 745250 717656 596584 633615 445665 734388 800196 511378 604625 563328 720458 666654 682080 557250 625408 586612 606641 609240 620685 628651 639178 777674 795826 777948 778839 779417 798766 727797 747181 760816 763199 777190 805695 720873 411507 612438 386062 686357 771015 620711 799016 411218 607253 386678 395664 821189 827971 683587 613929 129916 817748 823720 747368 708919 598111 638727 532212 565383 382285 722646 649276 800410 767857 767861 681490 393693 817272 820977 817244 693489 637690 600182 634541 809211 741996 757549 624653 633722 823721 722597 803342 800387 503359 552068 460090 395698 399380 775852 804478 823454 560514 554188 718877 682964 719728 585540 790256 756523 395583 776219 468749 637527 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (0.55%) |
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 129916 181454 382285 386062 386678 393693 395583 395664 395698 398157 399380 411218 411507 445665 455311 460090 468749 503359 511378 532212 552068 554070 554188 557250 560514 563328 565383 585540 586612 596584 598111 600182 604625 606641 607253 609240 612438 613929 620685 620711 624653 625408 628651 633615 633722 634541 637527 637690 638727 639178 640033 649276 666654 677347 681490 682080 682964 683587 686357 693489 708919 717656 718877 719728 720458 720873 722597 722646 724690 727797 732261 734388 734461 741996 743331 745250 747181 747368 749456 756488 756523 757549 760816 761970 763199 767857 767861 771015 775852 776219 777190 777674 777948 778839 779417 785776 786824 790256 795826 798766 799016 799276 800196 800387 800410 803342 804478 805695 806192 807396 809211 817244 817272 817748 820977 821189 823454 823720 823721 827971 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob first"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс first"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс first"
]
|
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.