Query Metrics
7
Database Queries
7
Different statements
196.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.49 ms (85.95%) |
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 31583 49767 232085 391101 398016 401814 415309 425694 429022 443617 446481 457264 459531 467096 472814 476365 485158 488038 499681 501039 507009 518520 521122 530277 532253 533756 534663 535396 535408 538316 539962 540054 548889 551099 552020 554702 554717 554766 562529 568739 571025 573989 577026 577679 580379 583068 589362 598515 606052 606206 615650 618009 618600 619457 619737 625750 627191 633408 633480 633664 635720 643668 644857 650037 652959 655545 660364 661339 661371 663549 664655 666978 669874 680612 684055 691899 696053 696058 696642 696664 696716 697085 705469 705709 707973 708671 709512 710042 713951 717224 718593 722993 736498 738950 746481 750345 751217 751242 753999 758942 760298 765796 767437 771514 774350 775250 776359 778765 787485 791494 793050 799017 802927 811637 825860 827557 828223 828244 828265 828377 ] |
||||||||||||||||||||||||||||||
|
16.25 ms (8.29%) |
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 232085 827557 828223 828244 540054 606052 746481 534663 828265 663549 705469 825860 507009 580379 398016 532253 583068 661339 664655 589362 429022 713951 787485 767437 738950 765796 802927 49767 459531 425694 535408 577679 633408 530277 552020 598515 457264 446481 521122 415309 472814 443617 708671 391101 644857 533756 539962 499681 577026 655545 666978 669874 684055 696053 696058 705709 709512 680612 696716 710042 722993 707973 571025 633664 619737 625750 618600 627191 775250 776359 736498 751217 753999 696664 697085 718593 811637 488038 652959 548889 828377 401814 538316 554702 554717 485158 643668 31583 476365 467096 518520 551099 660364 568739 618009 615650 606206 760298 774350 535396 562529 573989 696642 717224 650037 635720 778765 791494 751242 793050 758942 771514 501039 661371 799017 750345 554766 619457 691899 633480 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.72%) |
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 31583 49767 232085 391101 398016 401814 415309 425694 429022 443617 446481 457264 459531 467096 472814 476365 485158 488038 499681 501039 507009 518520 521122 530277 532253 533756 534663 535396 535408 538316 539962 540054 548889 551099 552020 554702 554717 554766 562529 568739 571025 573989 577026 577679 580379 583068 589362 598515 606052 606206 615650 618009 618600 619457 619737 625750 627191 633408 633480 633664 635720 643668 644857 650037 652959 655545 660364 661339 661371 663549 664655 666978 669874 680612 684055 691899 696053 696058 696642 696664 696716 697085 705469 705709 707973 708671 709512 710042 713951 717224 718593 722993 736498 738950 746481 750345 751217 751242 753999 758942 760298 765796 767437 771514 774350 775250 776359 778765 787485 791494 793050 799017 802927 811637 825860 827557 828223 828244 828265 828377 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public asian girls"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц азиатк девушк"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.84%) |
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.