Query Metrics
7
Database Queries
7
Different statements
165.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.96 ms (81.78%) |
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 394514 415977 416293 427339 429872 438339 439146 439218 441295 445977 446508 446561 452548 452873 455591 476776 489802 510170 517513 523595 526291 528320 529865 538395 541265 541795 546972 548945 554977 555131 555792 557346 563312 563628 564486 568707 570415 576540 578148 579675 581550 582464 584904 586199 587035 587295 587787 593285 593798 594363 595166 601872 602993 603040 608351 616993 618393 619606 623690 626618 629594 629649 629731 631703 633092 633716 636130 638187 640131 641071 641753 643737 651584 652878 661025 669896 671779 678003 678780 680576 684789 687810 690300 693635 697768 698478 700907 705798 707236 710860 712446 715291 715413 718036 735297 737804 751437 752194 752657 754747 754822 761944 763815 763878 766515 767026 774811 778442 779288 779522 782439 782865 787814 791024 798591 801810 805046 812416 812551 812763 ] |
||||||||||||||||||||||||||||||
|
20.91 ms (12.67%) |
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 538395 529865 548945 563628 541795 576540 579675 581550 652878 671779 684789 700907 651584 687810 707236 710860 715413 718036 669896 678003 678780 698478 712446 593798 623690 638187 641753 593285 595166 618393 629594 631703 636130 587295 587787 616993 619606 601872 774811 782865 778442 779288 782439 751437 763878 812551 737804 752194 752657 754747 761944 766515 767026 735297 754822 763815 633092 633716 640131 643737 697768 705798 779522 787814 791024 798591 801810 805046 812416 690300 587035 427339 445977 446508 510170 517513 570415 582464 584904 812763 452548 476776 429872 439218 526291 489802 564486 563312 715291 394514 416293 438339 439146 441295 415977 446561 452873 455591 523595 528320 557346 546972 554977 568707 541265 555131 661025 680576 693635 555792 578148 626618 594363 603040 629731 586199 602993 608351 629649 641071 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.38%) |
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 394514 415977 416293 427339 429872 438339 439146 439218 441295 445977 446508 446561 452548 452873 455591 476776 489802 510170 517513 523595 526291 528320 529865 538395 541265 541795 546972 548945 554977 555131 555792 557346 563312 563628 564486 568707 570415 576540 578148 579675 581550 582464 584904 586199 587035 587295 587787 593285 593798 594363 595166 601872 602993 603040 608351 616993 618393 619606 623690 626618 629594 629649 629731 631703 633092 633716 636130 638187 640131 641071 641753 643737 651584 652878 661025 669896 671779 678003 678780 680576 684789 687810 690300 693635 697768 698478 700907 705798 707236 710860 712446 715291 715413 718036 735297 737804 751437 752194 752657 754747 754822 761944 763815 763878 766515 767026 774811 778442 779288 779522 782439 782865 787814 791024 798591 801810 805046 812416 812551 812763 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo bathroom masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло ван мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.87%) |
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.