Query Metrics
7
Database Queries
7
Different statements
163.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.25 ms (84.78%) |
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 83312 237950 382017 383775 385633 387115 396408 402999 408830 420250 428518 441427 452210 454300 456097 458101 458754 464270 469803 476481 481801 494379 495100 497276 506216 508845 517300 520629 523598 530855 544453 545456 548720 551607 553125 561655 561669 561718 563528 564215 564908 565812 570410 575474 576311 580629 582121 585953 589181 599448 604084 605850 606038 606227 608426 609381 615497 615996 617869 624759 626609 632279 632318 640517 648513 651926 652519 653229 659448 663240 666449 669769 670997 671085 672472 673860 676191 677006 677048 679372 681204 682463 682683 683587 695754 696896 701131 703713 707357 716168 721417 722890 733875 736973 740508 742088 754175 758887 760471 765130 769329 771389 773253 774833 775237 786044 786354 787898 789033 792309 799980 804993 806577 806597 806882 808411 810171 810247 816326 ] |
||||||||||||||||||||||||||||||
|
13.87 ms (8.51%) |
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 676191 679372 653229 663240 707357 669769 681204 695754 721417 553125 561655 605850 608426 615497 615996 604084 606038 626609 632279 632318 585953 589181 606227 774833 775237 789033 799980 806597 810247 792309 806577 806882 736973 786044 808411 810171 733875 742088 758887 763469 765130 769329 740508 754175 760471 771389 773253 617869 640517 701131 786354 787898 804993 385633 387115 402999 458754 383775 237950 420250 456097 464270 83312 396408 408830 476481 382017 428518 441427 816326 481801 452210 458101 469803 454300 523598 530855 495100 508845 520629 494379 506216 517300 497276 544453 565812 564908 570410 576311 580629 545456 561669 563528 648513 670997 671085 672472 677006 677048 682463 682683 696896 722890 652519 659448 666449 673860 683587 651926 703713 716168 548720 551607 561718 564215 575474 582121 609381 624759 599448 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.70%) |
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 83312 237950 382017 383775 385633 387115 396408 402999 408830 420250 428518 441427 452210 454300 456097 458101 458754 464270 469803 476481 481801 494379 495100 497276 506216 508845 517300 520629 523598 530855 544453 545456 548720 551607 553125 561655 561669 561718 563528 564215 564908 565812 570410 575474 576311 580629 582121 585953 589181 599448 604084 605850 606038 606227 608426 609381 615497 615996 617869 624759 626609 632279 632318 640517 648513 651926 652519 653229 659448 663240 666449 669769 670997 671085 672472 673860 676191 677006 677048 679372 681204 682463 682683 683587 695754 696896 701131 703713 707357 716168 721417 722890 733875 736973 740508 742088 754175 758887 760471 765130 769329 771389 773253 774833 775237 786044 786354 787898 789033 792309 799980 804993 806577 806597 806882 808411 810171 810247 816326 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful sweet"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая милая"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.11%) |
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.