Query Metrics
7
Database Queries
7
Different statements
156.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.35 ms (84.98%) |
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 10065 14392 33686 95873 96205 96665 151564 154374 161528 187223 187851 192888 193662 205715 341546 381924 382437 383202 383237 383751 384142 386658 386913 388712 388912 393004 395733 397303 398552 399162 399688 400150 400169 401673 403312 408437 408767 409364 409367 411726 420227 427202 444106 448703 454228 487513 489443 500795 509228 531070 533345 536305 549307 563540 566558 568192 577112 590904 599993 606496 610007 623912 628347 638565 641303 644301 644306 649199 649902 650643 653584 666796 670487 671734 671759 675208 676427 681682 683228 686615 693990 714864 714883 717034 717607 720003 721187 721716 731851 732377 738619 747145 752596 770129 770196 770819 770840 784850 788783 789647 789961 791571 794557 794826 798797 800947 801944 802115 802128 803273 805565 805690 805819 809421 815124 816755 817171 817341 818309 823720 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (9.01%) |
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 383237 817341 770840 789961 398552 670487 653584 794826 489443 427202 671759 801944 487513 732377 784850 381924 681682 205715 500795 721187 809421 644306 789647 383751 393004 341546 193662 675208 161528 536305 533345 577112 397303 714864 720003 644301 770196 717034 408437 399688 386658 384142 566558 401673 448703 187851 747145 409367 818309 671734 628347 800947 408767 411726 399162 610007 563540 187223 714883 693990 770129 192888 382437 403312 395733 420227 454228 549307 650643 676427 599993 794557 683228 721716 33686 400169 531070 798797 151564 509228 803273 10065 14392 816755 444106 638565 805565 96205 400150 666796 606496 590904 802115 752596 96665 95873 154374 388912 386913 823720 649199 805690 731851 791571 815124 649902 568192 738619 802128 817171 686615 717607 641303 788783 383202 409364 770819 805819 388712 623912 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.72%) |
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 10065 14392 33686 95873 96205 96665 151564 154374 161528 187223 187851 192888 193662 205715 341546 381924 382437 383202 383237 383751 384142 386658 386913 388712 388912 393004 395733 397303 398552 399162 399688 400150 400169 401673 403312 408437 408767 409364 409367 411726 420227 427202 444106 448703 454228 487513 489443 500795 509228 531070 533345 536305 549307 563540 566558 568192 577112 590904 599993 606496 610007 623912 628347 638565 641303 644301 644306 649199 649902 650643 653584 666796 670487 671734 671759 675208 676427 681682 683228 686615 693990 714864 714883 717034 717607 720003 721187 721716 731851 732377 738619 747145 752596 770129 770196 770819 770840 784850 788783 789647 789961 791571 794557 794826 798797 800947 801944 802115 802128 803273 805565 805690 805819 809421 815124 816755 817171 817341 818309 823720 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женщины втроем"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женщин секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"женщин секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.93%) |
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.