Query Metrics
7
Database Queries
7
Different statements
200.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.17 ms (87.36%) |
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 131602 382839 392687 406935 414269 416571 418458 420774 423837 424195 425508 428955 429594 431385 432694 438207 439117 443248 444187 444523 451661 455084 458203 466601 466903 469096 475209 476798 477496 484065 493391 493411 493696 493954 499059 500341 506817 510170 513990 514254 516242 520492 522295 524626 526499 531638 531655 546028 546059 549502 550633 554826 559377 561952 561960 563419 565246 572238 577974 580182 580183 580727 583804 590696 590788 595581 596240 596799 599653 601872 613435 614975 623068 624164 625783 627938 629287 629596 636130 651731 677428 678761 679891 690684 692743 696154 698396 705379 705798 707556 717300 744261 752676 754184 754403 756752 765935 766262 769122 769580 771339 776544 779288 780663 781255 782439 785785 797918 799705 801280 803395 803886 808335 815866 816115 817667 817875 821593 827297 827498 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (7.80%) |
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 451661 444187 475209 493954 580727 414269 469096 580182 707556 690684 696154 590696 424195 827498 698396 803395 627938 781255 785785 817875 546028 752676 756752 431385 625783 416571 493696 815866 596799 443248 531638 466903 599653 466601 803886 769122 382839 131602 821593 613435 506817 420774 514254 418458 438207 769580 580183 801280 455084 561960 554826 526499 629287 766262 392687 546059 595581 623068 636130 601872 780663 797918 754403 771339 717300 776544 493411 423837 692743 590788 425508 444523 513990 583804 561952 428955 499059 516242 429594 484065 624164 439117 765935 458203 531655 779288 782439 705798 500341 550633 679891 677428 432694 520492 493391 827297 476798 577974 651731 705379 678761 549502 629596 799705 808335 754184 744261 406935 596240 572238 559377 565246 522295 614975 817667 477496 816115 510170 524626 563419 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.46%) |
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 131602 382839 392687 406935 414269 416571 418458 420774 423837 424195 425508 428955 429594 431385 432694 438207 439117 443248 444187 444523 451661 455084 458203 466601 466903 469096 475209 476798 477496 484065 493391 493411 493696 493954 499059 500341 506817 510170 513990 514254 516242 520492 522295 524626 526499 531638 531655 546028 546059 549502 550633 554826 559377 561952 561960 563419 565246 572238 577974 580182 580183 580727 583804 590696 590788 595581 596240 596799 599653 601872 613435 614975 623068 624164 625783 627938 629287 629596 636130 651731 677428 678761 679891 690684 692743 696154 698396 705379 705798 707556 717300 744261 752676 754184 754403 756752 765935 766262 769122 769580 771339 776544 779288 780663 781255 782439 785785 797918 799705 801280 803395 803886 808335 815866 816115 817667 817875 821593 827297 827498 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shower дилд секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shower dildo sex"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shower дилд секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.