Query Metrics
7
Database Queries
7
Different statements
204.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.22 ms (86.19%) |
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 387690 395602 408563 416200 423317 424254 424460 440620 440680 445687 445735 449715 451301 451931 452161 452681 454713 455316 456764 457419 467702 472655 472817 473691 475009 477389 480929 482317 485560 487133 489866 490244 490279 490866 491738 492370 493818 493842 494001 498285 498786 499772 501426 504829 505818 506478 507430 507584 508479 509727 510341 513500 514013 515565 515858 517849 517945 518053 518248 519055 520744 521675 523333 523653 523711 523859 523860 523868 523996 524378 524633 524937 525411 527249 528625 529373 534159 540802 545209 546993 550353 551817 551847 555118 555429 555972 557449 557569 559480 559485 559606 561273 564013 564194 565281 567648 573597 573728 574519 575814 575815 576312 578451 584945 591069 591909 593193 598464 598828 599979 601456 601650 608716 620985 622233 624587 626478 630993 656477 813281 ] |
||||||||||||||||||||||||||||||
|
17.98 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 485560 490279 490866 514013 523711 524937 525411 534159 492370 518053 523653 528625 387690 493818 449715 490244 498285 555972 559606 567648 575814 559485 573728 557569 561273 578451 551817 559480 564013 601456 622233 591909 591069 813281 473691 475009 395602 455316 424254 456764 452681 482317 467702 472817 515858 517849 523333 487133 493842 517945 501426 504829 519055 527249 491738 494001 505818 509727 521675 524633 416200 440680 440620 445687 451931 472655 489866 445735 523860 550353 557449 656477 551847 555118 573597 575815 584945 598828 423317 452161 451301 477389 480929 408563 457419 506478 507430 515565 510341 513500 540802 507584 508479 520744 524378 498786 499772 518248 523859 523996 454713 529373 523868 555429 565281 574519 545209 546993 564194 576312 598464 608716 599979 620985 593193 624587 630993 601650 626478 424460 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.44%) |
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 387690 395602 408563 416200 423317 424254 424460 440620 440680 445687 445735 449715 451301 451931 452161 452681 454713 455316 456764 457419 467702 472655 472817 473691 475009 477389 480929 482317 485560 487133 489866 490244 490279 490866 491738 492370 493818 493842 494001 498285 498786 499772 501426 504829 505818 506478 507430 507584 508479 509727 510341 513500 514013 515565 515858 517849 517945 518053 518248 519055 520744 521675 523333 523653 523711 523859 523860 523868 523996 524378 524633 524937 525411 527249 528625 529373 534159 540802 545209 546993 550353 551817 551847 555118 555429 555972 557449 557569 559480 559485 559606 561273 564013 564194 565281 567648 573597 573728 574519 575814 575815 576312 578451 584945 591069 591909 593193 598464 598828 599979 601456 601650 608716 620985 622233 624587 626478 630993 656477 813281 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зал"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зал"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.76%) |
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.