Query Metrics
7
Database Queries
7
Different statements
358.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.58 ms (58.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мо жен секс"
]
|
||||||||||||||||||||||||||||||
|
123.14 ms (34.40%) |
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 503655 506428 509678 513626 529575 535405 536983 547609 557707 564096 564691 591851 593854 603680 606555 606888 609986 613853 616094 618124 618668 621500 621634 623822 628727 631025 641293 641427 643530 645381 655553 656841 663539 677881 687458 690697 693689 694334 702155 702372 704981 705079 709337 712775 716452 719746 723831 723950 724921 725590 726522 726699 728502 729136 729681 730413 730923 730985 731279 732906 733260 733468 734318 735992 737509 737882 744172 744480 745901 747247 748082 748430 751483 752923 759019 760173 760789 762282 762301 763905 764798 764983 765823 766616 767513 767816 767829 768247 768742 772355 773419 778437 778650 780217 780392 784481 787245 788673 788674 790332 793247 795338 795767 795880 795973 796520 797411 798405 800989 801050 801551 802039 802050 802336 803647 803792 807899 809466 810330 813083 ] |
||||||||||||||||||||||||||||||
|
16.17 ms (4.52%) |
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 557707 618668 616094 536983 641293 677881 591851 606888 693689 747247 663539 809466 778650 735992 732906 535405 621500 788673 656841 603680 618124 744480 790332 733468 764983 609986 613853 726699 716452 503655 784481 731279 796520 694334 645381 621634 631025 730413 759019 767513 795880 795973 762282 729136 767816 712775 724921 628727 787245 723831 751483 506428 655553 704981 643530 780392 737509 745901 760789 564691 766616 807899 513626 730985 702372 641427 795338 728502 719746 803792 690697 810330 798405 795767 801551 729681 748082 767829 723950 773419 802050 705079 748430 606555 793247 797411 800989 802039 726522 760173 764798 802336 768247 709337 564096 623822 593854 788674 780217 725590 730923 733260 734318 744172 752923 509678 687458 702155 768742 801050 765823 737882 547609 778437 762301 772355 813083 529575 803647 763905 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (0.87%) |
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 503655 506428 509678 513626 529575 535405 536983 547609 557707 564096 564691 591851 593854 603680 606555 606888 609986 613853 616094 618124 618668 621500 621634 623822 628727 631025 641293 641427 643530 645381 655553 656841 663539 677881 687458 690697 693689 694334 702155 702372 704981 705079 709337 712775 716452 719746 723831 723950 724921 725590 726522 726699 728502 729136 729681 730413 730923 730985 731279 732906 733260 733468 734318 735992 737509 737882 744172 744480 745901 747247 748082 748430 751483 752923 759019 760173 760789 762282 762301 763905 764798 764983 765823 766616 767513 767816 767829 768247 768742 772355 773419 778437 778650 780217 780392 784481 787245 788673 788674 790332 793247 795338 795767 795880 795973 796520 797411 798405 800989 801050 801551 802039 802050 802336 803647 803792 807899 809466 810330 813083 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мою жену трахает"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.