Query Metrics
7
Database Queries
7
Different statements
172.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.32 ms (74.24%) |
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 13646 193342 388912 389442 413112 414723 425131 441841 443471 446079 448374 449200 450654 452273 452818 453142 459878 460980 464302 466105 466892 469366 470420 470774 471441 471659 474467 474470 476045 476142 476180 477132 477154 478656 479139 479530 482804 486685 487895 488951 491126 491442 494750 495633 495906 497414 502488 504620 505837 506501 507357 508469 508679 512177 512860 513150 513366 513982 516664 520630 521701 522582 523860 525862 527876 527882 527944 528317 528362 528853 531231 532764 533258 533264 535025 536470 537132 537927 542754 543846 545342 546201 548568 548575 549268 550952 560319 561117 564558 565484 568477 569150 577358 605134 622978 630194 632015 638137 694532 710877 723643 723735 725624 739863 751515 758510 777537 780659 781656 781712 789699 803687 809313 813422 814625 817023 817154 817729 825830 825831 ] |
||||||||||||||||||||||||||||||
|
19.78 ms (11.44%) |
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 825830 723643 817154 478656 450654 453142 469366 446079 448374 522582 497414 525862 494750 507357 476180 487895 545342 543846 560319 569150 548575 694532 632015 605134 638137 781656 781712 777537 803687 813422 723735 725624 758510 739863 751515 630194 710877 780659 789699 809313 443471 479139 466105 477132 479530 13646 491442 512177 414723 425131 523860 520630 495906 542754 561117 546201 622978 527944 486685 535025 531231 470774 193342 388912 389442 413112 441841 817729 814625 817023 825831 452818 464302 476142 482804 452273 460980 470420 471659 474470 476045 488951 449200 466892 471441 474467 491126 495633 504620 505837 508469 512860 513150 513366 527882 528317 532764 502488 513982 516664 528362 528853 536470 537132 506501 527876 508679 521701 533258 533264 537927 459878 477154 549268 550952 577358 548568 564558 565484 568477 ] |
||||||||||||||||||||||||||||||
|
10.04 ms (5.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
7.38 ms (4.27%) |
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 13646 193342 388912 389442 413112 414723 425131 441841 443471 446079 448374 449200 450654 452273 452818 453142 459878 460980 464302 466105 466892 469366 470420 470774 471441 471659 474467 474470 476045 476142 476180 477132 477154 478656 479139 479530 482804 486685 487895 488951 491126 491442 494750 495633 495906 497414 502488 504620 505837 506501 507357 508469 508679 512177 512860 513150 513366 513982 516664 520630 521701 522582 523860 525862 527876 527882 527944 528317 528362 528853 531231 532764 533258 533264 535025 536470 537132 537927 542754 543846 545342 546201 548568 548575 549268 550952 560319 561117 564558 565484 568477 569150 577358 605134 622978 630194 632015 638137 694532 710877 723643 723735 725624 739863 751515 758510 777537 780659 781656 781712 789699 803687 809313 813422 814625 817023 817154 817729 825830 825831 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (2.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bondage mature"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм mature"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм mature"
]
|
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.