Query Metrics
7
Database Queries
7
Different statements
232.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.61 ms (88.96%) |
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 170069 314006 383036 383733 390809 390955 392489 393444 393783 405494 417240 420319 425275 459627 474829 482525 493007 497701 506843 508996 521718 521771 524727 528062 528712 528740 541695 546296 553417 554599 555010 556617 558889 575269 577673 583346 586197 586320 586324 599703 609967 613204 617496 621491 625086 633252 633300 643927 644138 645623 650118 650364 652699 654286 656494 658540 670010 684705 696198 698704 699902 704942 710212 722552 724107 724369 724804 726192 726240 726435 726578 727329 729302 729738 732975 733007 733649 734124 734907 735617 736298 745568 745884 748075 749710 749993 750043 750768 755035 756003 756435 757754 758392 758394 758395 758416 767557 767998 775625 778743 779928 781108 781492 782130 782403 791694 795094 796189 796316 799795 801448 801706 801807 803196 807059 807549 810022 811592 813848 814241 ] |
||||||||||||||||||||||||||||||
|
14.59 ms (6.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 801448 801706 727329 734124 745884 748075 758394 796316 807059 810022 736298 749710 749993 724369 732975 756003 758392 758416 755035 699902 811592 459627 493007 482525 613204 528712 393444 170069 390809 698704 644138 781492 756435 733649 775625 383733 521771 650364 609967 791694 796189 758395 750043 779928 801807 392489 425275 393783 599703 383036 390955 405494 813848 814241 528740 497701 554599 650118 658540 704942 654286 670010 577673 586324 621491 778743 803196 729738 750768 767998 799795 724804 734907 735617 726240 757754 726435 633252 474829 524727 314006 417240 528062 546296 556617 645623 652699 656494 553417 555010 575269 633300 625086 617496 586197 586320 781108 782403 795094 724107 782130 726192 726578 729302 745568 767557 420319 807549 506843 643927 710212 733007 521718 508996 541695 558889 583346 696198 722552 684705 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (1.48%) |
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 170069 314006 383036 383733 390809 390955 392489 393444 393783 405494 417240 420319 425275 459627 474829 482525 493007 497701 506843 508996 521718 521771 524727 528062 528712 528740 541695 546296 553417 554599 555010 556617 558889 575269 577673 583346 586197 586320 586324 599703 609967 613204 617496 621491 625086 633252 633300 643927 644138 645623 650118 650364 652699 654286 656494 658540 670010 684705 696198 698704 699902 704942 710212 722552 724107 724369 724804 726192 726240 726435 726578 727329 729302 729738 732975 733007 733649 734124 734907 735617 736298 745568 745884 748075 749710 749993 750043 750768 755035 756003 756435 757754 758392 758394 758395 758416 767557 767998 775625 778743 779928 781108 781492 782130 782403 791694 795094 796189 796316 799795 801448 801706 801807 803196 807059 807549 810022 811592 813848 814241 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сосед секс"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сосед секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.74%) |
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.