Query Metrics
7
Database Queries
7
Different statements
356.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.31 ms (58.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
125.58 ms (35.25%) |
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 20031 146855 381871 383234 390125 390380 391144 391266 395276 395389 398022 398908 400956 401824 402128 404267 404339 405112 408447 411133 415487 417758 418083 418530 419625 420091 420507 420685 426944 427526 428685 430737 431687 443351 443440 444005 454674 455009 458713 459496 460179 460215 460801 461482 461532 464688 464713 465950 467134 467384 470341 470509 471342 471723 473549 475444 476632 476681 477876 478715 478828 481340 483620 484952 485641 488135 488137 489148 491026 494350 495387 499957 500736 500862 500905 506144 510203 510796 510985 512974 516301 523155 524365 525543 525823 525893 526841 538936 542072 551370 552971 557486 560642 565564 566063 567566 570231 571793 571884 573925 575426 587247 591073 591248 593341 598066 600191 601142 606817 620475 654446 670190 679091 715402 715478 779267 784237 805027 805031 807345 ] |
||||||||||||||||||||||||||||||
|
14.61 ms (4.10%) |
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 525543 494350 510796 516301 526841 670190 405112 391266 567566 408447 381871 476632 510203 538936 552971 565564 571793 571884 542072 557486 593341 591073 601142 606817 419625 426944 427526 443351 460179 471723 395276 443440 470509 471342 390125 418530 420685 458713 478715 478828 485641 488137 499957 500736 512974 483620 500862 523155 524365 491026 525823 525893 715478 383234 146855 398022 401824 402128 430737 460215 484952 489148 467134 488135 495387 510985 500905 506144 551370 566063 570231 575426 654446 715402 679091 560642 573925 598066 591248 600191 587247 779267 807345 784237 805031 805027 620475 411133 415487 420507 431687 461482 475444 477876 481340 390380 395389 398908 404267 418083 420091 428685 455009 459496 460801 461532 465950 473549 20031 391144 400956 417758 444005 454674 464688 464713 467384 470341 476681 404339 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (0.72%) |
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 20031 146855 381871 383234 390125 390380 391144 391266 395276 395389 398022 398908 400956 401824 402128 404267 404339 405112 408447 411133 415487 417758 418083 418530 419625 420091 420507 420685 426944 427526 428685 430737 431687 443351 443440 444005 454674 455009 458713 459496 460179 460215 460801 461482 461532 464688 464713 465950 467134 467384 470341 470509 471342 471723 473549 475444 476632 476681 477876 478715 478828 481340 483620 484952 485641 488135 488137 489148 491026 494350 495387 499957 500736 500862 500905 506144 510203 510796 510985 512974 516301 523155 524365 525543 525823 525893 526841 538936 542072 551370 552971 557486 560642 565564 566063 567566 570231 571793 571884 573925 575426 587247 591073 591248 593341 598066 600191 601142 606817 620475 654446 670190 679091 715402 715478 779267 784237 805027 805031 807345 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие красивая"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие красивая"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big beautiful"
]
|
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.