Query Metrics
7
Database Queries
7
Different statements
149.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.86 ms (86.15%) |
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 391485 397633 397694 397837 486964 506271 519610 526385 526850 532194 532456 533400 535514 537007 537251 539180 542248 550596 556865 560570 563748 568817 579570 579801 583930 584177 585450 585537 592280 592598 601380 602041 604992 609565 612888 620684 622964 626524 627050 631305 633360 633640 634925 635689 640880 642592 646090 646092 646173 650916 651828 654660 656297 656589 657227 660348 665999 667991 671224 677746 685063 686719 689929 698246 701913 702365 705145 706177 710178 713015 715738 716316 719676 720408 720521 722960 727293 727722 741563 748853 758389 762177 766257 776977 779662 779928 781562 789141 790290 795626 795651 796075 799840 800782 814204 816095 816616 817147 817215 817328 818039 818286 818288 818294 818570 818760 820751 823732 824235 824259 824676 824707 824743 825164 825194 825260 825716 825737 826437 826691 ] |
||||||||||||||||||||||||||||||
|
10.79 ms (7.22%) |
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 532194 526850 535514 537007 533400 650916 715738 710178 601380 592598 609565 790290 795651 795626 796075 799840 781562 727293 762177 727722 748853 741563 766257 612888 705145 800782 579570 391485 486964 506271 526385 519610 537251 556865 818039 789141 758389 713015 779928 397837 635689 397633 397694 823732 826437 826691 816095 816616 817215 818570 824707 824743 825194 825716 817147 818286 818288 818760 820751 824235 824676 825164 814204 817328 818294 824259 825260 825737 532456 539180 542248 560570 584177 550596 563748 568817 646090 646173 656297 667991 677746 698246 702365 720408 646092 654660 656589 657227 665999 671224 686719 689929 716316 719676 720521 722960 651828 660348 685063 701913 706177 579801 583930 622964 626524 633360 620684 633640 602041 642592 585450 585537 592280 604992 627050 631305 634925 640880 776977 779662 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.79%) |
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 391485 397633 397694 397837 486964 506271 519610 526385 526850 532194 532456 533400 535514 537007 537251 539180 542248 550596 556865 560570 563748 568817 579570 579801 583930 584177 585450 585537 592280 592598 601380 602041 604992 609565 612888 620684 622964 626524 627050 631305 633360 633640 634925 635689 640880 642592 646090 646092 646173 650916 651828 654660 656297 656589 657227 660348 665999 667991 671224 677746 685063 686719 689929 698246 701913 702365 705145 706177 710178 713015 715738 716316 719676 720408 720521 722960 727293 727722 741563 748853 758389 762177 766257 776977 779662 779928 781562 789141 790290 795626 795651 796075 799840 800782 814204 816095 816616 817147 817215 817328 818039 818286 818288 818294 818570 818760 820751 823732 824235 824259 824676 824707 824743 825164 825194 825260 825716 825737 826437 826691 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dogging my wife"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dogging my жен"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dogging my жен"
]
|
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.