Query Metrics
7
Database Queries
7
Different statements
142.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.15 ms (82.04%) |
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 330565 391241 401660 416843 417931 425864 426256 430293 435737 443145 444630 447965 448680 454008 456397 459130 459400 459923 466449 469021 470132 472635 472967 476694 479649 481665 483853 484749 486547 489793 492453 499305 500601 506349 506403 506849 511112 515764 515860 517444 523796 526548 526986 527913 537018 537322 541101 541113 543125 543254 544286 547026 548324 548474 552986 554933 555838 556585 556814 557168 557772 557877 557962 558813 563445 565785 566231 566878 568216 570153 570421 572668 574217 574694 576441 584190 588400 588458 590177 591594 593093 594409 594623 597544 598737 599247 603390 606192 619773 620498 622459 623811 629804 631697 666489 667631 671688 676125 692156 709425 716293 717155 723437 723459 737526 737681 738212 757550 774056 783494 790326 791203 794223 797802 802758 803370 805322 807851 811271 824278 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (11.77%) |
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 716293 466449 330565 484749 774056 459923 783494 803370 805322 807851 391241 416843 430293 426256 435737 454008 483853 472635 472967 476694 486547 511112 537322 499305 506349 506403 527913 537018 548474 552986 556585 572668 574694 576441 547026 554933 556814 566878 570153 574217 544286 557168 557962 563445 566231 568216 584190 666489 676125 557772 570421 590177 594409 619773 588458 593093 599247 606192 603390 620498 588400 591594 623811 629804 790326 791203 738212 794223 757550 622459 797802 443145 444630 459400 470132 425864 456397 417931 515860 500601 526986 631697 811271 506849 479649 447965 448680 489793 492453 526548 523796 517444 515764 541101 541113 543125 543254 565785 555838 558813 594623 459130 481665 469021 824278 401660 548324 557877 667631 692156 717155 671688 709425 598737 597544 802758 737681 737526 723437 723459 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.71%) |
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 330565 391241 401660 416843 417931 425864 426256 430293 435737 443145 444630 447965 448680 454008 456397 459130 459400 459923 466449 469021 470132 472635 472967 476694 479649 481665 483853 484749 486547 489793 492453 499305 500601 506349 506403 506849 511112 515764 515860 517444 523796 526548 526986 527913 537018 537322 541101 541113 543125 543254 544286 547026 548324 548474 552986 554933 555838 556585 556814 557168 557772 557877 557962 558813 563445 565785 566231 566878 568216 570153 570421 572668 574217 574694 576441 584190 588400 588458 590177 591594 593093 594409 594623 597544 598737 599247 603390 606192 619773 620498 622459 623811 629804 631697 666489 667631 671688 676125 692156 709425 716293 717155 723437 723459 737526 737681 738212 757550 774056 783494 790326 791203 794223 797802 802758 803370 805322 807851 811271 824278 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большие сиськи скачать"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ скача"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.