Query Metrics
7
Database Queries
7
Different statements
162.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.95 ms (85.32%) |
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 96530 97763 152479 152883 391186 395242 395499 408701 421438 423761 425561 442611 446934 447826 451450 457354 459593 461445 461851 466299 472785 476510 480807 481379 481852 491643 495311 497463 499348 504210 509500 511637 519768 521054 522234 534788 542099 543365 554333 566662 572276 579838 587711 588977 590423 593985 594415 594760 599490 601243 601664 602405 602475 610672 610831 614985 615426 616629 621267 625233 625421 632734 633839 633917 637701 641160 641463 641464 642657 647302 650456 650789 651102 652358 664097 668012 670821 682248 693468 695159 695182 696158 700966 702852 706912 708433 711673 713329 717665 718388 721988 722227 724604 725774 729999 732148 736905 737893 739278 742348 750724 758089 767996 768186 771251 771398 771819 772000 778681 778784 783392 795483 796825 797375 802799 803814 804927 807486 814105 ] |
||||||||||||||||||||||||||||||
|
13.49 ms (8.28%) |
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 457354 695159 693468 602475 96530 391186 700966 736905 713329 534788 579838 651102 695182 614985 633917 778784 796825 739278 732148 725774 738586 633839 542099 519768 587711 451450 717665 511637 572276 621267 783392 521054 721988 625421 771398 476510 804927 771819 152883 504210 497463 652358 647302 632734 601243 480807 395499 499348 522234 814105 566662 668012 682248 702852 602405 588977 772000 750724 758089 447826 601664 803814 459593 491643 670821 590423 442611 495311 706912 641464 610831 641160 797375 466299 408701 641463 625233 807486 423761 461851 152479 696158 722227 664097 637701 771251 610672 778681 461445 729999 481852 481379 802799 767996 768186 737893 509500 97763 650789 708433 594760 616629 724604 594415 472785 718388 615426 795483 446934 650456 543365 554333 711673 599490 593985 742348 425561 421438 642657 395242 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (2.31%) |
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 96530 97763 152479 152883 391186 395242 395499 408701 421438 423761 425561 442611 446934 447826 451450 457354 459593 461445 461851 466299 472785 476510 480807 481379 481852 491643 495311 497463 499348 504210 509500 511637 519768 521054 522234 534788 542099 543365 554333 566662 572276 579838 587711 588977 590423 593985 594415 594760 599490 601243 601664 602405 602475 610672 610831 614985 615426 616629 621267 625233 625421 632734 633839 633917 637701 641160 641463 641464 642657 647302 650456 650789 651102 652358 664097 668012 670821 682248 693468 695159 695182 696158 700966 702852 706912 708433 711673 713329 717665 718388 721988 722227 724604 725774 729999 732148 736905 737893 739278 742348 750724 758089 767996 768186 771251 771398 771819 772000 778681 778784 783392 795483 796825 797375 802799 803814 804927 807486 814105 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hotel минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hotel blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hotel минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.89%) |
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.