Query Metrics
7
Database Queries
7
Different statements
201.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.70 ms (86.87%) |
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 34382 157194 403225 411846 411848 416975 423633 424564 432650 436690 439606 447127 452282 452283 469272 470561 472914 473240 475333 480411 491403 498582 503255 508179 511391 512049 513032 514601 515339 519230 522342 522863 522898 522918 522939 524949 538681 538949 542070 542627 542923 543478 543480 549314 559006 559123 559127 559378 560085 566889 571442 573763 576631 576639 576686 576698 576703 576707 576712 576966 577357 577363 580254 580258 580579 581295 583581 583837 583885 587795 590954 592003 592388 592444 592450 592492 593365 598348 600492 603273 610047 614745 615743 615748 619082 619468 620135 620148 620153 620157 621305 622364 622382 624154 625901 629898 631058 632502 633875 648204 648256 670102 671735 671764 679380 690832 709654 712775 715670 726881 730479 732087 732823 757906 766928 794807 809308 809346 817115 821422 ] |
||||||||||||||||||||||||||||||
|
17.68 ms (8.79%) |
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 566889 592450 629898 411848 821422 580579 538681 603273 424564 542627 587795 809346 475333 679380 600492 732823 709654 559127 809308 726881 34382 403225 432650 511391 480411 577363 576639 690832 576703 610047 592003 622364 592388 625901 498582 472914 447127 583581 794807 436690 522918 503255 671764 615743 757906 614745 766928 576966 817115 633875 632502 559378 423633 522939 522342 576686 542070 559123 543480 671735 592444 620148 512049 522863 538949 515339 469272 583837 573763 577357 549314 559006 576712 581295 592492 593365 620153 598348 622382 411846 508179 648204 715670 730479 631058 473240 452282 514601 491403 513032 519230 524949 522898 576707 543478 560085 576698 580258 648256 712775 576631 580254 590954 619082 620135 619468 621305 624154 615748 157194 470561 416975 583885 439606 542923 670102 732087 620157 452283 571442 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.37%) |
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 34382 157194 403225 411846 411848 416975 423633 424564 432650 436690 439606 447127 452282 452283 469272 470561 472914 473240 475333 480411 491403 498582 503255 508179 511391 512049 513032 514601 515339 519230 522342 522863 522898 522918 522939 524949 538681 538949 542070 542627 542923 543478 543480 549314 559006 559123 559127 559378 560085 566889 571442 573763 576631 576639 576686 576698 576703 576707 576712 576966 577357 577363 580254 580258 580579 581295 583581 583837 583885 587795 590954 592003 592388 592444 592450 592492 593365 598348 600492 603273 610047 614745 615743 615748 619082 619468 620135 620148 620153 620157 621305 622364 622382 624154 625901 629898 631058 632502 633875 648204 648256 670102 671735 671764 679380 690832 709654 712775 715670 726881 730479 732087 732823 757906 766928 794807 809308 809346 817115 821422 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал фильм"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal films"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.67%) |
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.