Query Metrics
7
Database Queries
7
Different statements
366.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.45 ms (57.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
130.99 ms (35.78%) |
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 383158 386684 410741 412706 413593 413816 417821 425541 426331 442632 443492 444338 448345 450659 458612 460295 468644 471990 475507 485079 485500 493616 494436 494442 494689 497877 498634 506579 511481 511689 514400 519083 522041 523540 534112 534590 534600 535637 538259 541686 544844 547530 549070 549076 549079 549092 551461 551892 554137 554868 561861 562120 564348 564554 567129 567137 568547 568938 572709 572755 578361 579011 579469 579875 584721 587573 589729 590081 595512 595545 597747 598012 598874 602762 604222 604329 606633 608165 609277 610121 612441 614935 620115 623175 623201 626860 643008 657143 657228 666661 670296 683303 688404 709014 728745 758188 765339 765703 768957 770612 778949 780706 786522 792116 801565 802508 814081 814527 815087 815092 815121 815125 818527 820542 820604 821556 823529 826001 827883 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (4.29%) |
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 567137 683303 765703 413816 460295 822676 815125 821556 827883 534112 522041 564554 549076 666661 688404 595545 608165 792116 802508 801565 728745 426331 598874 778949 554868 815121 826001 494689 572709 623175 587573 770612 780706 458612 448345 578361 410741 383158 494442 814527 820604 538259 758188 786522 493616 511481 534600 568938 561861 572755 541686 589729 597747 626860 485079 485500 523540 417821 814081 823529 549070 657143 443492 386684 413593 519083 623201 815087 534590 579469 562120 564348 549079 551892 670296 579875 610121 595512 604222 604329 606633 614935 620115 768957 425541 511689 818527 609277 657228 442632 709014 765339 602762 444338 494436 497877 820542 815092 535637 544844 567129 549092 584721 643008 475507 412706 506579 514400 471990 498634 547530 554137 551461 568547 579011 590081 598012 612441 468644 450659 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (0.74%) |
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 383158 386684 410741 412706 413593 413816 417821 425541 426331 442632 443492 444338 448345 450659 458612 460295 468644 471990 475507 485079 485500 493616 494436 494442 494689 497877 498634 506579 511481 511689 514400 519083 522041 523540 534112 534590 534600 535637 538259 541686 544844 547530 549070 549076 549079 549092 551461 551892 554137 554868 561861 562120 564348 564554 567129 567137 568547 568938 572709 572755 578361 579011 579469 579875 584721 587573 589729 590081 595512 595545 597747 598012 598874 602762 604222 604329 606633 608165 609277 610121 612441 614935 620115 623175 623201 626860 643008 657143 657228 666661 670296 683303 688404 709014 728745 758188 765339 765703 768957 770612 778949 780706 786522 792116 801565 802508 814081 814527 815087 815092 815121 815125 818527 820542 820604 821556 823529 826001 827883 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny anal pov"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые анал пов"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.