Query Metrics
7
Database Queries
7
Different statements
210.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.01 ms (87.01%) |
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 9734 61726 88791 233670 233889 270104 365865 381849 388913 397405 398615 401567 405859 409597 411382 412294 417340 418533 418649 418961 419537 420254 423968 424266 425648 428611 433854 441158 441850 441984 442025 442107 443968 444177 448698 454484 455352 455998 456022 456701 459837 466346 466935 467858 479037 481262 484551 488902 489295 495878 496293 501169 508808 514041 514111 517883 522502 522512 523362 527420 527426 527438 531390 543296 546075 551821 553014 569542 586545 594188 597093 599674 603023 611228 624860 626351 637543 640349 644147 644374 664820 666757 667286 667291 671462 712644 725204 725477 728441 728643 729298 730109 731030 733924 734605 735905 735954 735984 739545 741564 745880 746192 747975 748605 749891 750235 754704 757463 759717 769474 794850 794874 794999 800817 800932 803896 804419 806302 812055 824370 ] |
||||||||||||||||||||||||||||||
|
17.23 ms (8.19%) |
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 666757 671462 712644 586545 603023 624860 597093 611228 637543 594188 644147 794874 794999 803896 733924 734605 746192 757463 806302 725204 731030 735984 741564 747975 748605 730109 729298 735905 749891 754704 728643 735954 750235 644374 800817 800932 804419 88791 270104 397405 61726 9734 398615 401567 411382 424266 441984 442025 418533 425648 428611 441158 409597 442107 444177 824370 448698 456022 466935 454484 523362 531390 481262 488902 543296 553014 667286 664820 667291 546075 551821 626351 640349 599674 812055 725477 794850 739545 759717 745880 769474 381849 423968 467858 418961 433854 441850 459837 479037 365865 417340 419537 456701 466346 233670 233889 420254 443968 455998 508808 517883 522512 496293 514041 501169 514111 522502 388913 405859 418649 412294 489295 455352 484551 527426 527420 527438 569542 728441 495878 ] |
||||||||||||||||||||||||||||||
|
3.68 ms (1.75%) |
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 9734 61726 88791 233670 233889 270104 365865 381849 388913 397405 398615 401567 405859 409597 411382 412294 417340 418533 418649 418961 419537 420254 423968 424266 425648 428611 433854 441158 441850 441984 442025 442107 443968 444177 448698 454484 455352 455998 456022 456701 459837 466346 466935 467858 479037 481262 484551 488902 489295 495878 496293 501169 508808 514041 514111 517883 522502 522512 523362 527420 527426 527438 531390 543296 546075 551821 553014 569542 586545 594188 597093 599674 603023 611228 624860 626351 637543 640349 644147 644374 664820 666757 667286 667291 671462 712644 725204 725477 728441 728643 729298 730109 731030 733924 734605 735905 735954 735984 739545 741564 745880 746192 747975 748605 749891 750235 754704 757463 759717 769474 794850 794874 794999 800817 800932 803896 804419 806302 812055 824370 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy chubby"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак chubby"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак chubby"
]
|
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.