Query Metrics
7
Database Queries
7
Different statements
171.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.48 ms (85.23%) |
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 27514 232085 417046 425405 427214 454707 464137 465429 472799 472812 476971 488984 494270 497660 506514 506544 506978 511047 512932 523286 525931 526974 527602 528675 534335 534628 534958 536066 538905 541815 542916 547581 548840 549363 549883 550107 551524 551562 551899 553167 555695 557531 559343 560121 564860 569530 580978 584014 584293 602222 607177 608679 618657 619259 622029 622036 625679 630749 634745 637301 642979 646929 647203 649830 649839 651916 652357 660279 665206 666054 683570 697558 701770 705802 712570 716361 721270 721755 721882 724405 731705 734218 738651 742126 742668 745223 745998 746038 746095 748126 768999 777591 778505 780702 785526 788609 789037 789065 789078 796338 802316 802917 803698 808299 810105 812239 812243 814302 817549 817639 817671 818738 819124 819195 820536 821215 821538 823515 828201 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (8.16%) |
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 716361 622036 417046 555695 649830 512932 731705 738651 232085 550107 608679 472799 476971 569530 660279 584014 536066 742668 511047 618657 472812 560121 525931 819195 549883 549363 557531 584293 427214 828201 651916 553167 665206 649839 619259 607177 820536 821215 817671 819124 534958 647203 625679 812239 742126 748126 777591 454707 534335 547581 559343 734218 534628 541815 683570 721755 796338 803698 812243 768999 745998 425405 465429 785526 817639 464137 494270 551524 551899 646929 701770 548840 602222 788609 802316 808299 789037 789065 746095 746038 721270 538905 551562 630749 724405 497660 506544 564860 778505 506978 666054 705802 622029 789078 802917 721882 817549 823515 814302 818738 821538 542916 652357 634745 780702 810105 745223 523286 526974 506514 712570 27514 828355 527602 580978 488984 528675 697558 637301 642979 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.91%) |
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 27514 232085 417046 425405 427214 454707 464137 465429 472799 472812 476971 488984 494270 497660 506514 506544 506978 511047 512932 523286 525931 526974 527602 528675 534335 534628 534958 536066 538905 541815 542916 547581 548840 549363 549883 550107 551524 551562 551899 553167 555695 557531 559343 560121 564860 569530 580978 584014 584293 602222 607177 608679 618657 619259 622029 622036 625679 630749 634745 637301 642979 646929 647203 649830 649839 651916 652357 660279 665206 666054 683570 697558 701770 705802 712570 716361 721270 721755 721882 724405 731705 734218 738651 742126 742668 745223 745998 746038 746095 748126 768999 777591 778505 780702 785526 788609 789037 789065 789078 796338 802316 802917 803698 808299 810105 812239 812243 814302 817549 817639 817671 818738 819124 819195 820536 821215 821538 823515 828201 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits public"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.04%) |
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.