Query Metrics
7
Database Queries
7
Different statements
180.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.08 ms (84.77%) |
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 281801 388767 391815 393408 394610 395235 398522 398544 400342 433704 460298 468952 470693 477285 484623 488563 490125 493107 497782 514208 523499 531564 536974 537636 538165 541722 544639 548604 552141 556648 567477 586312 599681 603906 616070 620085 620363 621786 627773 641367 641920 642274 643934 643988 650088 650294 662559 663301 671223 676213 684876 694417 695735 699156 699946 701763 706211 707174 709677 709834 710097 710356 712646 713585 713587 714777 715498 717578 718863 726999 727450 730645 731703 733161 739910 743496 746949 747540 749994 751974 752173 755857 759680 761593 764056 764691 766056 769205 769535 771488 771531 776216 777184 777995 779889 783993 784382 786168 788062 788400 788445 789578 790325 791124 791819 793655 794816 795236 795445 796679 798043 802860 804037 804941 805697 806088 807328 810201 813446 813845 ] |
||||||||||||||||||||||||||||||
|
17.34 ms (9.61%) |
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 761593 746949 769535 713585 813446 627773 400342 398544 813845 490125 460298 537636 497782 556648 676213 718863 650088 710356 663301 694417 695735 699946 552141 620363 789578 791124 777184 784382 794816 798043 747540 766056 788062 790325 795236 749994 743496 726999 709677 804037 398522 712646 642274 769205 733161 281801 395235 538165 684876 671223 641367 727450 752173 771531 764691 777995 802860 804941 470693 484623 391815 433704 488563 514208 548604 713587 709834 643934 805697 779889 783993 755857 786168 788445 791819 751974 764056 739910 731703 388767 393408 394610 603906 523499 620085 531564 706211 662559 701763 715498 621786 806088 771488 796679 730645 759680 616070 699156 717578 468952 536974 477285 493107 541722 650294 707174 710097 714777 544639 567477 643988 641920 586312 599681 776216 788400 793655 807328 810201 795445 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.80%) |
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 281801 388767 391815 393408 394610 395235 398522 398544 400342 433704 460298 468952 470693 477285 484623 488563 490125 493107 497782 514208 523499 531564 536974 537636 538165 541722 544639 548604 552141 556648 567477 586312 599681 603906 616070 620085 620363 621786 627773 641367 641920 642274 643934 643988 650088 650294 662559 663301 671223 676213 684876 694417 695735 699156 699946 701763 706211 707174 709677 709834 710097 710356 712646 713585 713587 714777 715498 717578 718863 726999 727450 730645 731703 733161 739910 743496 746949 747540 749994 751974 752173 755857 759680 761593 764056 764691 766056 769205 769535 771488 771531 776216 777184 777995 779889 783993 784382 786168 788062 788400 788445 789578 790325 791124 791819 793655 794816 795236 795445 796679 798043 802860 804037 804941 805697 806088 807328 810201 813446 813845 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сосед секс"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соседи секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сосед секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.84%) |
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.