Query Metrics
7
Database Queries
7
Different statements
137.31 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.75 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.19 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мини член"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.37 ms |
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 575435 451576 436139 489679 499471 524317 625223 632699 619126 460995 536259 572731 553204 556973 460731 439931 680193 575324 472712 520728 677801 625450 595489 537771 462930 544012 650325 639027 633782 426802 523813 422656 518018 526492 571696 568502 580321 587416 642777 644636 792610 535620 556835 592408 603724 530884 687257 515071 541846 679029 678135 573926 680255 625524 581423 585431 496865 449784 637030 649578 667985 599861 634778 533370 553054 579389 678532 422398 524897 595923 526363 549990 648837 541854 494694 519198 541853 583139 467608 646176 614995 531488 553272 532680 677784 624173 642662 631593 ] |
||||||||||||||||||||||||||||||
| 4 | 2.34 ms |
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 422398 422656 426802 436139 439931 449784 451576 460731 460995 462930 467608 472712 489679 494694 496865 499471 515071 518018 519198 520728 523813 524317 524897 526363 526492 530884 531488 532680 533370 535620 536259 537771 541846 541853 541854 544012 549990 553054 553204 553272 556835 556973 568502 571696 572731 573926 575324 575435 579389 580321 581423 583139 585431 587416 592408 595489 595923 599861 603724 614995 619126 624173 625223 625450 625524 631593 632699 633782 634778 637030 639027 642662 642777 644636 646176 648837 649578 650325 667985 677784 677801 678135 678532 679029 680193 680255 687257 792610 ] |
||||||||||||||||||||||||||||||
| 5 | 116.61 ms |
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 422398 422656 426802 436139 439931 449784 451576 460731 460995 462930 467608 472712 489679 494694 496865 499471 515071 518018 519198 520728 523813 524317 524897 526363 526492 530884 531488 532680 533370 535620 536259 537771 541846 541853 541854 544012 549990 553054 553204 553272 556835 556973 568502 571696 572731 573926 575324 575435 579389 580321 581423 583139 585431 587416 592408 595489 595923 599861 603724 614995 619126 624173 625223 625450 625524 631593 632699 633782 634778 637030 639027 642662 642777 644636 646176 648837 649578 650325 667985 677784 677801 678135 678532 679029 680193 680255 687257 792610 ] |
||||||||||||||||||||||||||||||
| 6 | 1.56 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мин член"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.50 ms |
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.