Query Metrics
7
Database Queries
7
Different statements
434.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
404.61 ms (93.03%) |
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 55349 389711 397533 402977 416455 416924 432716 434950 437816 444573 456894 460883 472366 473621 485067 496310 496394 499710 506818 510728 514590 528465 528679 535101 542043 542185 565014 572231 575002 577762 579725 585246 586739 596919 599584 599667 612518 613390 616728 617588 619856 623460 626843 637301 656808 659197 669507 675390 678732 689056 689073 692531 696567 706759 709503 712542 714571 716921 720443 721469 721598 725160 726390 730904 736191 737037 741523 741824 744431 745072 745603 746645 748346 751215 755723 756755 756797 759013 759316 764268 764426 764703 769550 772444 773326 773797 775271 776088 776491 778714 780201 783627 784120 784794 785103 785255 787251 788039 789065 789083 789286 789471 789721 792607 793528 793973 796942 797292 798930 800637 801988 802230 807364 808107 812457 813572 818602 827968 ] |
||||||||||||||||||||||||||||||
|
20.44 ms (4.70%) |
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 801988 812457 780201 788039 789083 789721 802230 746645 789065 796942 808107 736191 748346 751215 745603 759316 764268 773326 776088 783627 784120 785103 789286 789471 792607 793528 807364 473621 55349 416455 472366 485067 496310 389711 514590 528679 577762 712542 721598 619856 586739 775271 741824 737037 745072 726390 772444 741523 776491 434950 416924 432716 542185 572231 542043 575002 675390 706759 720443 689056 689073 716921 692531 721469 579725 637301 585246 613390 599584 599667 612518 616728 626843 784794 787251 778714 725160 744431 755723 759013 785255 730904 764703 756755 769550 773797 756797 764426 617588 623460 714571 797292 444573 402977 506818 528465 596919 709503 565014 669507 696567 662145 678732 697943 397533 818602 813572 456894 496394 798930 793973 800637 460883 437816 827968 499710 510728 535101 656808 659197 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (0.59%) |
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 55349 389711 397533 402977 416455 416924 432716 434950 437816 444573 456894 460883 472366 473621 485067 496310 496394 499710 506818 510728 514590 528465 528679 535101 542043 542185 565014 572231 575002 577762 579725 585246 586739 596919 599584 599667 612518 613390 616728 617588 619856 623460 626843 637301 656808 659197 669507 675390 678732 689056 689073 692531 696567 706759 709503 712542 714571 716921 720443 721469 721598 725160 726390 730904 736191 737037 741523 741824 744431 745072 745603 746645 748346 751215 755723 756755 756797 759013 759316 764268 764426 764703 769550 772444 773326 773797 775271 776088 776491 778714 780201 783627 784120 784794 785103 785255 787251 788039 789065 789083 789286 789471 789721 792607 793528 793973 796942 797292 798930 800637 801988 802230 807364 808107 812457 813572 818602 827968 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur caught"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск caught"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск caught"
]
|
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.