Query Metrics
7
Database Queries
7
Different statements
161.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.59 ms (80.75%) |
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 423816 424325 440987 444346 459710 464887 477335 481803 484249 484498 485315 499878 508554 510186 515601 515605 516087 520124 520426 522414 524119 527292 529293 543198 546757 546932 551012 551539 556327 557387 558223 559279 561582 561973 562768 563007 563695 564412 564985 565105 565653 567242 568072 568587 568676 571033 571333 576308 577102 577720 577888 584634 585101 585405 588473 588532 588991 590596 590628 591198 594490 595494 595504 595703 596622 597070 597542 597559 599184 599249 599342 599361 599368 601886 601941 602574 602778 603102 603963 605534 605552 605668 606439 607045 607797 608226 608347 609892 610303 610694 611369 612008 613268 613282 615060 616469 617069 617367 617431 618806 619065 619783 620048 620638 622408 623206 623235 623326 624150 625312 625395 627638 652610 655471 659182 659419 661547 663372 663930 681514 ] |
||||||||||||||||||||||||||||||
|
21.45 ms (13.26%) |
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 595494 599184 605534 615060 588473 608347 602778 612008 423816 424325 459710 440987 508554 520124 515605 520426 571033 568587 655471 681514 588532 602574 606439 613268 596622 616469 597559 605668 622408 623326 444346 481803 499878 515601 516087 484249 524119 522414 529293 551539 571333 565105 577102 659182 659419 546932 567242 617367 594490 595504 618806 623206 591198 605552 620638 627638 611369 617069 617431 477335 464887 527292 510186 484498 485315 585101 551012 559279 563007 584634 546757 556327 558223 563695 564985 565653 568676 577720 577888 543198 564412 576308 663372 663930 661547 652610 557387 561582 561973 562768 568072 599342 607045 608226 610694 613282 619065 623235 625312 625395 590596 590628 599249 599368 609892 624150 585405 588991 595703 597070 597542 599361 601886 601941 603102 603963 607797 610303 619783 620048 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.78%) |
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 423816 424325 440987 444346 459710 464887 477335 481803 484249 484498 485315 499878 508554 510186 515601 515605 516087 520124 520426 522414 524119 527292 529293 543198 546757 546932 551012 551539 556327 557387 558223 559279 561582 561973 562768 563007 563695 564412 564985 565105 565653 567242 568072 568587 568676 571033 571333 576308 577102 577720 577888 584634 585101 585405 588473 588532 588991 590596 590628 591198 594490 595494 595504 595703 596622 597070 597542 597559 599184 599249 599342 599361 599368 601886 601941 602574 602778 603102 603963 605534 605552 605668 606439 607045 607797 608226 608347 609892 610303 610694 611369 612008 613268 613282 615060 616469 617069 617367 617431 618806 619065 619783 620048 620638 622408 623206 623235 623326 624150 625312 625395 627638 652610 655471 659182 659419 661547 663372 663930 681514 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стороны"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сторон"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.87%) |
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.