Query Metrics
7
Database Queries
7
Different statements
183.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.33 ms (88.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 396237 414723 417828 425131 432359 435207 461111 479314 484787 486975 489712 490740 494740 495522 495906 504613 506444 516771 516844 520630 523860 528713 533056 535013 537243 539788 540317 541556 542754 543872 544910 545312 546010 546201 546816 552298 554859 559179 559569 560090 560460 560871 561117 563473 563876 565890 566316 567389 572219 575075 575437 575596 576055 576836 587436 589221 590505 600575 601500 603564 612765 613319 614566 616082 622978 624159 624355 627666 630479 637486 653561 683560 686739 687021 690144 694213 697494 700895 704955 709804 714457 715826 716744 719046 719537 722345 722464 722520 726291 727610 727788 731893 732806 734413 735028 740534 741047 742712 746298 748615 753696 753939 758915 778734 784215 790197 790921 792326 793739 794945 794995 797724 802106 802516 806331 807685 807971 808217 811666 813099 ] |
||||||||||||||||||||||||||||||
|
12.70 ms (6.93%) |
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 539788 540317 494740 506444 516844 533056 537243 479314 484787 490740 545312 552298 554859 560090 566316 575596 576055 544910 559179 563876 572219 541556 546010 546816 565890 576836 694213 700895 715826 716744 719537 722520 686739 687021 722345 653561 683560 690144 697494 704955 709804 719046 722464 560460 560871 567389 575075 600575 603564 612765 614566 624159 630479 637486 589221 624355 627666 601500 616082 792326 793739 794945 807971 813099 790197 807685 740534 741047 753939 758915 784215 797724 802106 802516 806331 808217 811666 726291 734413 746298 732806 742712 748615 753696 727610 727788 731893 735028 778734 790921 794995 396237 461111 504613 486975 535013 417828 435207 414723 425131 432359 489712 516771 523860 520630 528713 495906 495522 542754 561117 563473 543872 559569 546201 575437 590505 622978 587436 613319 714457 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (1.78%) |
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 396237 414723 417828 425131 432359 435207 461111 479314 484787 486975 489712 490740 494740 495522 495906 504613 506444 516771 516844 520630 523860 528713 533056 535013 537243 539788 540317 541556 542754 543872 544910 545312 546010 546201 546816 552298 554859 559179 559569 560090 560460 560871 561117 563473 563876 565890 566316 567389 572219 575075 575437 575596 576055 576836 587436 589221 590505 600575 601500 603564 612765 613319 614566 616082 622978 624159 624355 627666 630479 637486 653561 683560 686739 687021 690144 694213 697494 700895 704955 709804 714457 715826 716744 719046 719537 722345 722464 722520 726291 727610 727788 731893 732806 734413 735028 740534 741047 742712 746298 748615 753696 753939 758915 778734 784215 790197 790921 792326 793739 794945 794995 797724 802106 802516 806331 807685 807971 808217 811666 813099 ] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм cock"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm cock"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм cock"
]
|
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.