Query Metrics
7
Database Queries
7
Different statements
165.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.32 ms (86.24%) |
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 232085 384497 389660 397673 401948 423128 492164 501280 509784 534864 535359 535379 535396 535616 536068 540054 541190 542475 542721 551221 552587 560493 562529 562936 573989 575383 581180 589771 592337 606052 608666 611687 614215 614385 618005 618071 618072 618189 618600 619414 621168 627191 627655 627851 629774 635720 649484 650037 659472 673055 692752 695594 695670 696642 696664 696675 696687 696716 697085 701708 702347 702360 702370 707973 716582 717224 718593 720470 722993 733511 736498 741580 746481 751217 751419 753999 754635 758949 761160 768293 771514 773498 775250 775815 776359 777601 778765 779339 779692 780172 780902 781438 784104 785526 785533 787145 788892 789066 790647 791105 791494 791643 793050 795992 797920 804169 807275 811637 812225 813545 814299 824888 826343 827557 828144 828223 828244 828270 ] |
||||||||||||||||||||||||||||||
|
12.01 ms (7.28%) |
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 649484 673055 696716 722993 659472 692752 695670 696675 701708 702347 707973 716582 720470 608666 589771 618071 619414 618600 627191 629774 775250 779339 781438 791105 776359 791643 804169 736498 741580 768293 733511 751217 753999 754635 751419 761160 696664 696687 697085 718593 780902 811637 780172 779692 828009 492164 501280 614215 618005 785533 828244 401948 702360 592337 389660 535379 384497 232085 824888 827557 828223 536068 540054 627655 606052 812225 746481 785526 509784 814299 534864 621168 777601 789066 535616 535359 614385 618072 784104 788892 542721 611687 618189 702370 695594 795992 562936 535396 562529 573989 575383 541190 696642 717224 650037 635720 790647 807275 778765 791494 758949 793050 769831 771514 773498 627851 775815 826343 828270 828144 423128 581180 787145 797920 397673 813545 542475 552587 551221 560493 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.68%) |
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 232085 384497 389660 397673 401948 423128 492164 501280 509784 534864 535359 535379 535396 535616 536068 540054 541190 542475 542721 551221 552587 560493 562529 562936 573989 575383 581180 589771 592337 606052 608666 611687 614215 614385 618005 618071 618072 618189 618600 619414 621168 627191 627655 627851 629774 635720 649484 650037 659472 673055 692752 695594 695670 696642 696664 696675 696687 696716 697085 701708 702347 702360 702370 707973 716582 717224 718593 720470 722993 733511 736498 741580 746481 751217 751419 753999 754635 758949 761160 768293 771514 773498 775250 775815 776359 777601 778765 779339 779692 780172 780902 781438 784104 785526 785533 787145 788892 789066 790647 791105 791494 791643 793050 795992 797920 804169 807275 811637 812225 813545 814299 824888 826343 827557 828144 828223 828244 828270 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц вебкамер"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public webcam"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.99%) |
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.