Query Metrics
7
Database Queries
7
Different statements
154.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.75 ms (84.09%) |
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 3561 89480 124361 187353 187735 188456 325846 365880 381862 382610 382690 383367 385014 385088 386667 388193 390918 395145 396941 396971 397209 407748 407767 408415 409126 409276 409330 411985 413283 419839 428141 428907 451466 452238 453092 453462 462963 466318 466914 468920 481915 506836 510819 512046 514920 532365 537111 537147 544465 544479 546928 558284 561047 561459 562645 583306 587184 591531 663423 665867 665893 667266 667314 667656 669023 670185 674091 692805 693032 718552 720007 720530 721421 721466 721482 726330 727935 732742 735484 739620 739955 745453 745844 747073 748146 748213 748222 748504 752703 754436 755960 760211 762669 770097 770237 772554 773543 774326 777417 779199 780720 781646 781850 782287 796450 796957 799020 802453 803070 803106 807637 812742 813685 814866 815722 816085 817957 819238 823613 823806 ] |
||||||||||||||||||||||||||||||
|
13.20 ms (8.55%) |
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 561459 720530 558284 807637 727935 770097 770237 754436 803106 365880 428141 388193 506836 382610 411985 187735 325846 386667 397209 419839 772554 407767 385088 383367 381862 390918 409330 814866 823806 532365 721421 669023 674091 721482 591531 777417 802453 782287 747073 735484 748222 773543 468920 453092 537147 395145 3561 396971 396941 408415 813685 816085 817957 823613 452238 453462 512046 537111 514920 583306 544465 544479 562645 665867 667656 665893 667314 692805 693032 721466 663423 667266 779199 780720 781850 745453 748146 774326 799020 803070 726330 739620 745844 732742 762669 781646 409126 466318 760211 89480 187353 462963 385014 466914 124361 413283 815722 428907 510819 382690 188456 819238 720007 796957 748213 748504 752703 739955 718552 451466 481915 561047 407748 409276 546928 670185 587184 796450 812742 755960 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.39%) |
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 3561 89480 124361 187353 187735 188456 325846 365880 381862 382610 382690 383367 385014 385088 386667 388193 390918 395145 396941 396971 397209 407748 407767 408415 409126 409276 409330 411985 413283 419839 428141 428907 451466 452238 453092 453462 462963 466318 466914 468920 481915 506836 510819 512046 514920 532365 537111 537147 544465 544479 546928 558284 561047 561459 562645 583306 587184 591531 663423 665867 665893 667266 667314 667656 669023 670185 674091 692805 693032 718552 720007 720530 721421 721466 721482 726330 727935 732742 735484 739620 739955 745453 745844 747073 748146 748213 748222 748504 752703 754436 755960 760211 762669 770097 770237 772554 773543 774326 777417 779199 780720 781646 781850 782287 796450 796957 799020 802453 803070 803106 807637 812742 813685 814866 815722 816085 817957 819238 823613 823806 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелые в чулка"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.01%) |
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.