Query Metrics
7
Database Queries
7
Different statements
380.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.90 ms (55.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"без юбк"
]
|
||||||||||||||||||||||||||||||
|
143.68 ms (37.76%) |
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 183552 186294 203995 366053 382512 386027 391499 393581 395172 395788 401960 411776 417419 417621 419273 420012 428220 428366 431078 432380 434854 449511 452879 453980 454045 458042 461709 463691 465896 472812 485089 489014 490792 492651 492973 494866 503472 507248 513067 513202 516626 521387 521400 529770 530144 532312 532319 532451 536439 537780 538069 542467 552042 552716 554648 555663 555835 559210 559257 560331 560457 561969 563033 579410 584084 590105 592897 593598 600876 618415 620992 624418 625282 627794 631394 640514 649867 650540 662086 669370 672925 679618 683665 699197 701231 701705 711589 713134 713343 725501 725513 728174 731416 735850 738596 740975 741529 753692 758070 758633 759610 759955 759975 761788 761890 764097 766306 766779 774883 775297 779145 783214 791381 795416 795913 796495 796953 807206 807406 814677 ] |
||||||||||||||||||||||||||||||
|
17.82 ms (4.68%) |
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 683665 713343 600876 590105 620992 640514 627794 774883 779145 795416 807406 741529 759610 761890 740975 791381 472812 366053 490792 536439 559210 701705 713134 593598 725501 417419 420012 419273 454045 458042 538069 521400 532451 579410 679618 592897 631394 783214 759975 728174 753692 764097 759955 731416 758633 465896 395788 395172 516626 513202 485089 186294 393581 401960 428366 411776 492651 494866 521387 542467 552042 554648 555835 649867 672925 669370 699197 618415 624418 625282 796495 775297 796953 725513 807206 766306 735850 738596 758070 761788 766779 382512 432380 183552 503472 449511 537780 552716 701231 795913 386027 203995 391499 434854 431078 417621 428220 814677 461709 463691 492973 452879 453980 530144 532312 529770 507248 513067 532319 489014 559257 560331 563033 555663 560457 561969 584084 662086 711589 650540 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.80%) |
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 183552 186294 203995 366053 382512 386027 391499 393581 395172 395788 401960 411776 417419 417621 419273 420012 428220 428366 431078 432380 434854 449511 452879 453980 454045 458042 461709 463691 465896 472812 485089 489014 490792 492651 492973 494866 503472 507248 513067 513202 516626 521387 521400 529770 530144 532312 532319 532451 536439 537780 538069 542467 552042 552716 554648 555663 555835 559210 559257 560331 560457 561969 563033 579410 584084 590105 592897 593598 600876 618415 620992 624418 625282 627794 631394 640514 649867 650540 662086 669370 672925 679618 683665 699197 701231 701705 711589 713134 713343 725501 725513 728174 731416 735850 738596 740975 741529 753692 758070 758633 759610 759955 759975 761788 761890 764097 766306 766779 774883 775297 779145 783214 791381 795416 795913 796495 796953 807206 807406 814677 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"без юбки"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.49%) |
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.