Query Metrics
7
Database Queries
7
Different statements
153.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.04 ms (83.66%) |
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 73280 73421 389499 396406 407491 417849 420212 423571 425360 438208 442647 442985 443669 443941 446134 449611 450995 451703 451711 457661 459783 460679 460724 466685 467078 467638 479114 480833 481047 486234 486961 487101 496066 497473 497478 498077 499870 502300 503852 506014 510132 510953 516490 518877 519190 520711 521355 523142 527434 533187 539133 539137 540222 540232 541118 541316 542600 543446 544362 547303 548592 549400 550498 551090 554528 558197 559158 568410 575692 583817 587202 589462 589629 592489 592839 595068 596149 601026 605028 605119 605149 605163 606583 606611 610235 612959 619501 634481 644448 648466 650011 650408 681313 692222 698981 705740 742246 746578 756212 759240 772600 775739 788178 788576 789016 789725 789962 790024 791589 799663 802700 803129 804171 804943 805356 805374 808655 809477 819238 825296 ] |
||||||||||||||||||||||||||||||
|
14.60 ms (9.54%) |
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 634481 605119 605149 789016 804943 73280 73421 417849 539137 396406 442985 467638 498077 527434 466685 423571 540222 583817 541118 559158 558197 606583 592839 595068 619501 808655 791589 803129 772600 788576 756212 389499 497478 520711 521355 497473 523142 496066 610235 438208 425360 825296 446134 460724 539133 533187 575692 543446 544362 705740 692222 650408 601026 605028 605163 596149 589629 789725 799663 805356 802700 742246 746578 775739 789962 790024 443941 819238 460679 450995 487101 540232 554528 542600 547303 549400 550498 568410 650011 587202 612959 804171 788178 805374 759240 644448 442647 451711 467078 407491 451703 459783 443669 449611 457661 480833 503852 486234 506014 510132 502300 486961 499870 510953 551090 518877 519190 541316 548592 648466 681313 589462 592489 606611 809477 698981 420212 481047 479114 516490 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.95%) |
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 73280 73421 389499 396406 407491 417849 420212 423571 425360 438208 442647 442985 443669 443941 446134 449611 450995 451703 451711 457661 459783 460679 460724 466685 467078 467638 479114 480833 481047 486234 486961 487101 496066 497473 497478 498077 499870 502300 503852 506014 510132 510953 516490 518877 519190 520711 521355 523142 527434 533187 539133 539137 540222 540232 541118 541316 542600 543446 544362 547303 548592 549400 550498 551090 554528 558197 559158 568410 575692 583817 587202 589462 589629 592489 592839 595068 596149 601026 605028 605119 605149 605163 606583 606611 610235 612959 619501 634481 644448 648466 650011 650408 681313 692222 698981 705740 742246 746578 756212 759240 772600 775739 788178 788576 789016 789725 789962 790024 791589 799663 802700 803129 804171 804943 805356 805374 808655 809477 819238 825296 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation mom"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк mom"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"подборк mom"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.17%) |
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.