Query Metrics
7
Database Queries
7
Different statements
173.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.09 ms (87.11%) |
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 3671 383249 388023 397665 424243 435891 463295 468176 468298 470020 471172 473112 475027 480133 488393 496344 497739 499439 499685 502298 503977 505290 506308 506785 508004 509130 509829 512138 514454 519166 520233 520844 524494 526668 526977 529030 531683 533217 534084 535330 535885 536930 537781 538559 539111 539493 539968 540059 540135 542980 544920 545189 545738 545880 546085 547266 549516 550165 551065 551523 553333 553482 554540 554657 555439 555725 556318 556603 559343 561377 561471 561489 564403 565446 566091 567215 568728 569951 571076 571288 572095 573186 576188 577638 579694 580967 585021 587493 589766 589805 589820 591395 591868 593249 596315 599589 599831 600197 600847 600980 602290 603232 604244 606113 608311 610171 610300 611331 613956 614469 621537 624941 627946 631920 632177 632931 637517 641548 646031 666401 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (7.79%) |
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 538559 499685 502298 503977 505290 520844 534084 524494 509829 531683 473112 545880 551065 555439 556318 579694 567215 571076 577638 646031 666401 554540 556603 564403 602290 631920 604244 610171 614469 621537 587493 600847 627946 589820 600197 603232 632931 641548 397665 475027 526668 529030 435891 509130 512138 551523 553333 565446 545189 561489 593249 611331 624941 613956 610300 480133 508004 540059 589766 540135 539111 559343 506308 471172 535885 561377 572095 576188 550165 637517 596315 599831 383249 566091 539493 526977 514454 520233 535330 536930 544920 569951 571288 546085 580967 547266 561471 589805 591395 608311 599589 600980 606113 632177 388023 470020 496344 554657 591868 3671 424243 585021 468298 488393 463295 519166 533217 539968 497739 499439 506785 537781 468176 542980 545738 553482 555725 568728 573186 549516 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.56%) |
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 3671 383249 388023 397665 424243 435891 463295 468176 468298 470020 471172 473112 475027 480133 488393 496344 497739 499439 499685 502298 503977 505290 506308 506785 508004 509130 509829 512138 514454 519166 520233 520844 524494 526668 526977 529030 531683 533217 534084 535330 535885 536930 537781 538559 539111 539493 539968 540059 540135 542980 544920 545189 545738 545880 546085 547266 549516 550165 551065 551523 553333 553482 554540 554657 555439 555725 556318 556603 559343 561377 561471 561489 564403 565446 566091 567215 568728 569951 571076 571288 572095 573186 576188 577638 579694 580967 585021 587493 589766 589805 589820 591395 591868 593249 596315 599589 599831 600197 600847 600980 602290 603232 604244 606113 608311 610171 610300 611331 613956 614469 621537 624941 627946 631920 632177 632931 637517 641548 646031 666401 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на руке"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на рук"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.18 ms (0.68%) |
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.