Query Metrics
7
Database Queries
7
Different statements
177.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.87 ms (87.27%) |
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 29295 61399 182340 365293 387080 390230 391150 391440 395373 397431 398218 398299 398928 399965 400032 400050 402634 412551 423539 423821 428793 432442 432502 432517 433596 433792 435355 439522 440992 444168 451532 454049 455553 455605 459298 459532 460319 463591 464840 466420 466460 466560 466759 469459 469598 469787 473113 475374 478258 488023 493529 499412 500260 507787 509225 510714 515046 515614 519574 521853 523746 524124 526831 526919 528228 528322 533715 534419 539405 539438 544808 546767 547880 552806 553315 555137 556496 567248 568598 570865 571940 574300 576686 577315 579174 580329 585455 590502 590527 590763 592635 592810 608787 631481 645339 672821 681261 709533 718062 725523 728096 731544 742039 743445 748496 754303 755897 769467 780771 789259 791029 793136 803734 804312 810809 811496 814765 824138 824450 ] |
||||||||||||||||||||||||||||||
|
13.50 ms (7.61%) |
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 810809 793136 803734 743445 748496 755897 769467 725523 754303 731544 742039 780771 789259 791029 804312 182340 387080 390230 365293 391440 399965 432502 395373 412551 61399 391150 398299 402634 440992 439522 463591 469459 454049 464840 466759 455605 469598 469787 510714 539438 519574 523746 521853 528228 509225 539405 466460 493529 547880 571940 570865 579174 546767 568598 709533 718062 645339 555137 574300 590502 592635 590527 631481 811496 728096 432517 455553 473113 423539 433596 435355 451532 397431 432442 444168 400032 478258 466420 466560 524124 433792 475374 507787 526919 528322 567248 576686 580329 556496 585455 590763 592810 459298 459532 423821 488023 515614 499412 553315 608787 824138 824450 828081 29295 398218 400050 398928 428793 814765 460319 500260 515046 533715 534419 526831 544808 552806 577315 672821 681261 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.32%) |
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 29295 61399 182340 365293 387080 390230 391150 391440 395373 397431 398218 398299 398928 399965 400032 400050 402634 412551 423539 423821 428793 432442 432502 432517 433596 433792 435355 439522 440992 444168 451532 454049 455553 455605 459298 459532 460319 463591 464840 466420 466460 466560 466759 469459 469598 469787 473113 475374 478258 488023 493529 499412 500260 507787 509225 510714 515046 515614 519574 521853 523746 524124 526831 526919 528228 528322 533715 534419 539405 539438 544808 546767 547880 552806 553315 555137 556496 567248 568598 570865 571940 574300 576686 577315 579174 580329 585455 590502 590527 590763 592635 592810 608787 631481 645339 672821 681261 709533 718062 725523 728096 731544 742039 743445 748496 754303 755897 769467 780771 789259 791029 793136 803734 804312 810809 811496 814765 824138 824450 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бел"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"белое"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.87%) |
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.