Query Metrics
7
Database Queries
7
Different statements
163.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.94 ms (82.38%) |
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 7065 197736 399922 404276 404693 405107 416172 419518 420207 421890 422543 423020 432122 439574 439607 439715 443811 446740 448507 451595 451749 452828 453624 461466 463809 463962 466242 467034 469852 470196 473766 482575 486275 491286 499103 506052 510964 523544 529129 530757 536789 539424 539938 543863 545755 550207 556017 556334 568058 574897 576021 576417 576673 584539 587858 597246 598042 603077 603584 604142 604968 605324 609147 614867 616025 617408 618916 619592 621543 624273 626231 626735 627803 628391 628419 632974 633732 636998 640772 640773 644291 644636 649190 671626 672584 677053 677142 677955 678803 680186 683831 685655 687262 689634 696969 708424 714183 714500 717832 720462 720698 720836 721846 724181 724559 729920 745161 748349 750675 789733 795683 807918 807985 811826 814364 818235 818444 819506 825001 827328 ] |
||||||||||||||||||||||||||||||
|
20.43 ms (12.47%) |
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 677955 687262 568058 587858 603584 621543 597246 617408 604142 640773 644636 795683 807985 729920 632974 714500 473766 419518 404276 443811 448507 486275 499103 451595 584539 818235 819506 671626 678803 748349 724181 627803 463962 422543 721846 556017 598042 461466 399922 405107 7065 683831 619592 467034 439574 439607 404693 420207 469852 510964 539938 539424 529129 574897 543863 689634 636998 603077 463809 491286 523544 439715 825001 482575 720836 750675 470196 576417 680186 717832 685655 609147 633732 724559 745161 466242 550207 677053 452828 530757 536789 677142 614867 628391 628419 640772 616025 818444 827328 708424 696969 649190 720462 604968 644291 618916 624273 626735 789733 807918 453624 423020 720698 605324 714183 626231 545755 421890 197736 446740 506052 576673 811826 416172 432122 814364 451749 576021 556334 672584 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.57%) |
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 7065 197736 399922 404276 404693 405107 416172 419518 420207 421890 422543 423020 432122 439574 439607 439715 443811 446740 448507 451595 451749 452828 453624 461466 463809 463962 466242 467034 469852 470196 473766 482575 486275 491286 499103 506052 510964 523544 529129 530757 536789 539424 539938 543863 545755 550207 556017 556334 568058 574897 576021 576417 576673 584539 587858 597246 598042 603077 603584 604142 604968 605324 609147 614867 616025 617408 618916 619592 621543 624273 626231 626735 627803 628391 628419 632974 633732 636998 640772 640773 644291 644636 649190 671626 672584 677053 677142 677955 678803 680186 683831 685655 687262 689634 696969 708424 714183 714500 717832 720462 720698 720836 721846 724181 724559 729920 745161 748349 750675 789733 795683 807918 807985 811826 814364 818235 818444 819506 825001 827328 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal young tits"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал young сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал young сиськ"
]
|
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.