Query Metrics
7
Database Queries
7
Different statements
203.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.82 ms (85.80%) |
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 432650 436690 439606 452282 453365 469272 470561 472914 473240 475333 480411 491403 498582 503255 506495 508179 511391 512049 514601 515339 519230 521367 522342 522862 522863 522875 522898 522918 522939 538681 538949 542070 542627 542923 543478 543480 559006 559123 559127 559378 560085 560086 566889 573763 576631 576639 576686 576698 576703 576707 576712 576966 577357 577363 580254 580258 580579 581295 583581 583837 583871 583885 587795 589968 590954 592388 592444 592450 592492 593365 596753 598348 600492 603273 610047 614745 615748 619082 619468 620135 620148 620153 621305 622364 622382 624154 625901 629898 631058 632502 633875 648256 670102 671735 671764 679380 690832 709654 712775 715670 726881 730479 732087 732823 757906 778541 794807 809308 809346 810336 817115 819860 821422 ] |
||||||||||||||||||||||||||||||
|
18.00 ms (8.83%) |
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 819860 778541 560086 589968 522862 522875 506495 583871 566889 592450 629898 411848 821422 580579 538681 603273 542627 587795 809346 475333 679380 600492 732823 709654 559127 809308 726881 34382 403225 432650 511391 480411 577363 576639 690832 576703 610047 622364 592388 625901 498582 472914 583581 794807 436690 522918 503255 671764 596753 757906 614745 576966 817115 633875 632502 559378 423633 522939 522342 576686 542070 559123 543480 671735 592444 620148 512049 522863 538949 515339 469272 583837 573763 577357 559006 576712 581295 592492 593365 620153 598348 622382 411846 810336 508179 715670 730479 631058 473240 452282 521367 514601 453365 491403 519230 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 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.65%) |
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 432650 436690 439606 452282 453365 469272 470561 472914 473240 475333 480411 491403 498582 503255 506495 508179 511391 512049 514601 515339 519230 521367 522342 522862 522863 522875 522898 522918 522939 538681 538949 542070 542627 542923 543478 543480 559006 559123 559127 559378 560085 560086 566889 573763 576631 576639 576686 576698 576703 576707 576712 576966 577357 577363 580254 580258 580579 581295 583581 583837 583871 583885 587795 589968 590954 592388 592444 592450 592492 593365 596753 598348 600492 603273 610047 614745 615748 619082 619468 620135 620148 620153 621305 622364 622382 624154 625901 629898 631058 632502 633875 648256 670102 671735 671764 679380 690832 709654 712775 715670 726881 730479 732087 732823 757906 778541 794807 809308 809346 810336 817115 819860 821422 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фильм анал"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фильм анал"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"film anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.