Query Metrics
8
Database Queries
8
Different statements
165.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.93 ms (84.04%) |
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 382073 385828 386339 390209 392785 408248 414736 423584 433740 438020 440047 443468 453262 453263 461360 463621 468883 477886 481338 483421 494561 496632 506942 508101 513579 528859 529647 529903 531747 536508 542185 542206 544511 546580 551016 552247 559321 561838 569222 570392 571010 578657 591121 592747 600499 603733 606854 615359 615932 617436 623624 624013 641213 702400 707605 715071 718279 718329 719977 722024 724685 724688 725055 730311 732821 734534 736276 737085 737588 739060 739648 742820 744780 744920 748436 750890 754145 756070 759997 760898 761259 761378 761399 761504 761546 764254 766953 768463 768464 771380 774105 774116 775859 781344 789471 790709 794057 794566 795293 796263 799054 799991 800140 801432 802247 803738 810544 819263 819820 824698 824893 825069 825083 825344 826434 827115 828569 828581 ] |
||||||||||||||||||||||||||||||
|
12.02 ms (7.27%) |
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 825083 603733 781344 774116 768463 766953 796263 801432 803738 624013 617436 463621 438020 468883 827115 819263 826434 824893 542206 799991 800140 736276 774105 794057 724688 742820 761259 768464 724685 771380 775859 531747 559321 561838 571010 506942 552247 544511 707605 739060 737588 461360 528859 542185 551016 764254 823221 453262 453263 496632 718279 715071 615932 790709 802247 744780 756070 761378 732821 750890 761399 702400 794566 795293 386339 385828 414736 382073 481338 825344 718329 641213 591121 760898 761546 408248 546580 606854 477886 828569 536508 810544 483421 508101 443468 825069 819820 824698 828581 780166 722024 623624 761504 754145 737085 748436 789471 570392 615359 494561 390209 423584 529647 569222 719977 739648 759997 392785 513579 433740 592747 578657 440047 529903 725055 734534 730311 744920 799054 600499 ] |
||||||||||||||||||||||||||||||
|
4.55 ms (2.75%) |
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 382073 385828 386339 390209 392785 408248 414736 423584 433740 438020 440047 443468 453262 453263 461360 463621 468883 477886 481338 483421 494561 496632 506942 508101 513579 528859 529647 529903 531747 536508 542185 542206 544511 546580 551016 552247 559321 561838 569222 570392 571010 578657 591121 592747 600499 603733 606854 615359 615932 617436 623624 624013 641213 702400 707605 715071 718279 718329 719977 722024 724685 724688 725055 730311 732821 734534 736276 737085 737588 739060 739648 742820 744780 744920 748436 750890 754145 756070 759997 760898 761259 761378 761399 761504 761546 764254 766953 768463 768464 771380 774105 774116 775859 781344 789471 790709 794057 794566 795293 796263 799054 799991 800140 801432 802247 803738 810544 819263 819820 824698 824893 825069 825083 825344 826434 827115 828569 828581 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.36%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01ô@Éá×paü3à╔┬P\x0F¦"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf handjob"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.87%) |
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.