Query Metrics
7
Database Queries
7
Different statements
199.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.49 ms (78.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 129640 382485 383801 387344 387562 388746 396336 399738 403141 404175 405061 405181 408332 408458 408462 410076 410353 414364 418897 419483 420762 422732 422735 425004 425892 430161 430975 435454 443043 443232 445513 445733 446555 446870 447452 452109 456120 457077 465034 467030 468849 472849 475262 478534 481047 482811 488894 491771 495273 503105 508426 512029 512057 512937 517609 518766 522160 522196 523536 527408 529320 538276 539147 543613 545857 550563 551222 551748 553296 556480 558199 559946 573113 590165 593444 595805 601039 604537 604569 605606 610292 610563 625444 625804 630913 633171 636539 663367 663438 679856 681053 690786 697368 710872 714549 715553 720406 723509 732468 738854 740617 741307 750062 751817 771827 774029 775833 780620 785686 787608 788234 790988 795516 798399 805112 805827 812673 817131 817344 821739 ] |
||||||||||||||||||||||||||||||
|
25.35 ms (12.71%) |
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 382485 399738 410353 482811 387562 446870 435454 491771 472849 551748 559946 543613 430161 527408 512937 573113 446555 551222 556480 604569 495273 129640 388746 404175 422735 443232 422732 443043 452109 456120 445733 475262 478534 512029 539147 503105 512057 517609 538276 553296 625444 595805 604537 420762 457077 481047 419483 425004 405061 518766 445513 387344 403141 408332 414364 408458 488894 714549 430975 468849 408462 508426 405181 447452 383801 396336 410076 418897 425892 817131 821739 817344 467030 465034 522196 523536 522160 529320 545857 550563 663438 663367 679856 681053 690786 710872 697368 720406 723509 558199 605606 610563 633171 593444 636539 590165 601039 610292 625804 630913 775833 790988 795516 798399 805112 805827 788234 812673 740617 787608 741307 738854 751817 732468 750062 771827 774029 715553 780620 785686 ] |
||||||||||||||||||||||||||||||
|
7.96 ms (3.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.46%) |
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 129640 382485 383801 387344 387562 388746 396336 399738 403141 404175 405061 405181 408332 408458 408462 410076 410353 414364 418897 419483 420762 422732 422735 425004 425892 430161 430975 435454 443043 443232 445513 445733 446555 446870 447452 452109 456120 457077 465034 467030 468849 472849 475262 478534 481047 482811 488894 491771 495273 503105 508426 512029 512057 512937 517609 518766 522160 522196 523536 527408 529320 538276 539147 543613 545857 550563 551222 551748 553296 556480 558199 559946 573113 590165 593444 595805 601039 604537 604569 605606 610292 610563 625444 625804 630913 633171 636539 663367 663438 679856 681053 690786 697368 710872 714549 715553 720406 723509 732468 738854 740617 741307 750062 751817 771827 774029 775833 780620 785686 787608 788234 790988 795516 798399 805112 805827 812673 817131 817344 821739 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings interracial"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.79%) |
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.