Query Metrics
7
Database Queries
7
Different statements
171.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.27 ms (82.32%) |
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 6768 51420 70659 381789 384758 385466 385608 393460 396088 396235 400126 404388 409590 413584 413735 414116 420439 430802 432698 433827 436316 441917 447654 448643 451827 454642 458920 465315 468797 475168 486698 491800 493834 495364 513145 515795 517254 533029 539233 550601 552998 564152 566764 567805 578041 590365 592197 593581 604171 605319 618843 619134 630685 637428 639092 643008 649114 665921 670227 684063 690516 708909 709185 709589 713279 713513 720079 720365 720379 720703 724102 731971 731990 737298 737400 749468 750126 750444 751496 752289 757442 761494 765573 765698 766819 767220 769320 777074 778393 784742 785512 787563 792016 793448 794809 795710 800856 804015 807123 810210 810249 810307 812010 813883 814430 817196 817215 817245 817372 818860 819230 820716 820860 821015 821062 822714 823491 825018 825808 ] |
||||||||||||||||||||||||||||||
|
20.58 ms (11.99%) |
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 684063 818860 825018 690516 794809 737298 765573 810210 396235 458920 447654 436316 413584 51420 618843 619134 752289 766819 750444 441917 820716 813883 821062 517254 515795 639092 385608 381789 400126 432698 454642 486698 451827 468797 539233 533029 475168 564152 567805 578041 550601 670227 649114 665921 720379 566764 592197 793448 731990 767220 810249 769320 731971 630685 800856 70659 385466 393460 409590 817245 817372 822714 821015 720703 709185 713279 713513 637428 593581 795710 785512 787563 804015 761494 812010 737400 751496 765698 750126 792016 810307 777074 749468 709589 448643 491800 513145 493834 590365 604171 605319 807123 724102 643008 384758 404388 413735 433827 420439 823491 465315 552998 708909 720079 720365 784742 757442 778393 396088 430802 495364 414116 6768 814430 816642 817215 819230 825808 817196 820860 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.77%) |
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 6768 51420 70659 381789 384758 385466 385608 393460 396088 396235 400126 404388 409590 413584 413735 414116 420439 430802 432698 433827 436316 441917 447654 448643 451827 454642 458920 465315 468797 475168 486698 491800 493834 495364 513145 515795 517254 533029 539233 550601 552998 564152 566764 567805 578041 590365 592197 593581 604171 605319 618843 619134 630685 637428 639092 643008 649114 665921 670227 684063 690516 708909 709185 709589 713279 713513 720079 720365 720379 720703 724102 731971 731990 737298 737400 749468 750126 750444 751496 752289 757442 761494 765573 765698 766819 767220 769320 777074 778393 784742 785512 787563 792016 793448 794809 795710 800856 804015 807123 810210 810249 810307 812010 813883 814430 817196 817215 817245 817372 818860 819230 820716 820860 821015 821062 822714 823491 825018 825808 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen latina"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen латинская"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen латинская"
]
|
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.