Query Metrics
7
Database Queries
7
Different statements
174.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.21 ms (84.28%) |
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 398634 418453 423563 425118 443383 447452 447810 451563 453345 463105 465619 474830 476107 479002 483368 483487 492762 493477 496100 496269 502277 505132 509321 510396 511812 514119 514820 515972 516029 516684 522157 522351 523856 524850 524853 524860 524878 525731 529794 530275 530369 530479 530805 531097 531201 531251 531419 532655 532680 532745 533463 533557 533738 533915 534988 534994 535584 535597 536262 537114 540339 540437 541721 541848 541872 543652 543858 543860 544825 545437 546860 548228 554392 556025 559111 565247 568482 588244 596082 597170 597216 598057 599835 599902 600011 604369 617410 617418 630552 630756 631163 631202 632680 632694 632708 634138 634185 634784 637413 639706 639748 641667 645016 647877 647936 648241 648252 648254 648257 648861 649596 650127 651162 665328 674943 677798 680255 789665 ] |
||||||||||||||||||||||||||||||
|
18.22 ms (10.43%) |
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 535597 483368 541872 546860 548228 568482 645016 648252 648861 651162 677798 565247 634185 598057 617418 639706 596082 599902 604369 641667 632694 443383 447452 425118 523856 514119 483487 423563 463105 476107 492762 522157 533738 531419 536262 530805 535584 647877 680255 650127 639748 789665 617410 631163 632708 451563 418453 453345 511812 496269 502277 509321 637413 465619 474830 479002 530479 540339 514820 524850 530275 534988 531251 531097 537114 544825 559111 647936 649596 648254 632680 631202 634138 496100 516029 493477 447810 515972 524878 525731 505132 510396 524860 543652 543858 543860 541848 630756 597170 634784 532680 540437 524853 532655 532745 648241 674943 545437 588244 599835 630552 522351 516684 529794 554392 531201 534994 541721 648257 597216 556025 533915 530369 600011 398634 533463 533557 665328 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.58%) |
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 398634 418453 423563 425118 443383 447452 447810 451563 453345 463105 465619 474830 476107 479002 483368 483487 492762 493477 496100 496269 502277 505132 509321 510396 511812 514119 514820 515972 516029 516684 522157 522351 523856 524850 524853 524860 524878 525731 529794 530275 530369 530479 530805 531097 531201 531251 531419 532655 532680 532745 533463 533557 533738 533915 534988 534994 535584 535597 536262 537114 540339 540437 541721 541848 541872 543652 543858 543860 544825 545437 546860 548228 554392 556025 559111 565247 568482 588244 596082 597170 597216 598057 599835 599902 600011 604369 617410 617418 630552 630756 631163 631202 632680 632694 632708 634138 634185 634784 637413 639706 639748 641667 645016 647877 647936 648241 648252 648254 648257 648861 649596 650127 651162 665328 674943 677798 680255 789665 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"групповое наручники"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"группов бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.81%) |
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.