Query Metrics
7
Database Queries
7
Different statements
176.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.79 ms (84.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 58201 197982 338311 381952 385181 386761 391722 399164 417077 420235 431496 444428 457199 458528 506302 507844 513766 515030 515810 528999 529692 532105 532439 534183 534232 543749 544002 545143 548919 550107 555167 563572 575415 575997 580519 583265 587996 590652 592930 593798 598805 602680 608679 621291 624922 627335 627577 628020 629387 630222 638544 641330 642045 643405 643520 649093 651128 652169 661444 665823 665827 666518 668331 669343 672836 681674 688500 690830 690934 692013 692248 693028 694455 694507 695246 695613 695635 696358 697840 697879 698028 698483 699744 699781 709710 712582 714089 714737 716270 716502 717137 722336 724644 728887 728945 738300 738447 741877 749397 751469 756399 761929 763103 765162 780765 782314 787330 788311 788938 789017 789269 792427 794206 794236 794964 802483 810028 814407 823889 828128 ] |
||||||||||||||||||||||||||||||
|
16.53 ms (9.37%) |
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 696358 690830 693028 724644 728945 507844 629387 789269 391722 543749 699781 694507 695613 697840 598805 749397 751469 792427 641330 381952 534232 642045 763103 756399 699744 385181 58201 548919 621291 780765 698483 197982 592930 420235 575997 417077 828128 532105 528999 666518 669343 688500 665827 672836 697879 643520 590652 788938 782314 738300 458528 823889 529692 580519 714089 698028 716270 555167 789017 794964 709710 714737 794206 794236 810028 444428 532439 544002 545143 550107 692248 652169 661444 681674 722336 593798 627577 628020 643405 638544 728887 787330 738447 608679 802483 431496 515030 649093 695246 587996 515810 575415 457199 513766 399164 563572 651128 694455 712582 668331 690934 695635 716502 741877 761929 627335 630222 717137 506302 583265 692013 665823 624922 788311 765162 602680 386761 338311 534183 814407 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.81%) |
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 58201 197982 338311 381952 385181 386761 391722 399164 417077 420235 431496 444428 457199 458528 506302 507844 513766 515030 515810 528999 529692 532105 532439 534183 534232 543749 544002 545143 548919 550107 555167 563572 575415 575997 580519 583265 587996 590652 592930 593798 598805 602680 608679 621291 624922 627335 627577 628020 629387 630222 638544 641330 642045 643405 643520 649093 651128 652169 661444 665823 665827 666518 668331 669343 672836 681674 688500 690830 690934 692013 692248 693028 694455 694507 695246 695613 695635 696358 697840 697879 698028 698483 699744 699781 709710 712582 714089 714737 716270 716502 717137 722336 724644 728887 728945 738300 738447 741877 749397 751469 756399 761929 763103 765162 780765 782314 787330 788311 788938 789017 789269 792427 794206 794236 794964 802483 810028 814407 823889 828128 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"video большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"video big tits"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"video большие сиськ"
]
|
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.