Query Metrics
7
Database Queries
7
Different statements
151.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.56 ms (85.43%) |
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 382527 384979 398926 410811 418659 426467 444098 499668 515751 532084 548725 554745 558026 558459 560613 560767 565665 566222 566522 567755 568580 569852 569853 569854 569857 570348 570588 571227 571447 571769 571887 572062 572382 573045 573225 573544 573663 573682 573774 573963 574497 574601 574812 574904 574920 575078 575089 575100 575137 575510 575755 576279 576307 576410 577130 578393 579691 580648 581668 583671 595388 596545 598592 598812 606691 606749 612106 618456 620141 623812 624240 624296 638357 656466 657066 659605 660523 662483 665221 670495 679040 679372 680616 692645 697558 698818 699678 718561 720822 721202 722848 729141 730446 740331 748272 750560 753728 753831 761872 765208 766042 790966 791990 793583 795104 800504 803184 804373 804753 806045 811028 811814 811832 812082 817824 818408 820406 820416 827081 ] |
||||||||||||||||||||||||||||||
|
12.96 ms (8.55%) |
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 699678 720822 659605 573544 618456 624296 811832 793583 598592 568580 679372 790966 418659 554745 804373 566522 750560 574812 384979 765208 721202 573225 569853 665221 670495 569857 426467 730446 748272 571447 382527 680616 806045 811814 761872 410811 575100 576410 574601 573663 811028 398926 820416 569852 569854 657066 718561 656466 571887 576307 598812 596545 606749 624240 804753 740331 612106 573045 572062 573682 560767 571769 595388 638357 827081 572382 662483 698818 803184 795104 766042 753728 697558 812082 623812 499668 791990 817824 548725 567755 679040 606691 729141 620141 575755 578393 581668 558026 574904 574920 579691 444098 571227 565665 558459 570588 570348 692645 660523 573963 800504 722848 515751 818408 532084 761934 820406 753831 573774 574497 575078 575510 566222 575137 577130 560613 575089 576279 580648 583671 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.48%) |
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 382527 384979 398926 410811 418659 426467 444098 499668 515751 532084 548725 554745 558026 558459 560613 560767 565665 566222 566522 567755 568580 569852 569853 569854 569857 570348 570588 571227 571447 571769 571887 572062 572382 573045 573225 573544 573663 573682 573774 573963 574497 574601 574812 574904 574920 575078 575089 575100 575137 575510 575755 576279 576307 576410 577130 578393 579691 580648 581668 583671 595388 596545 598592 598812 606691 606749 612106 618456 620141 623812 624240 624296 638357 656466 657066 659605 660523 662483 665221 670495 679040 679372 680616 692645 697558 698818 699678 718561 720822 721202 722848 729141 730446 740331 748272 750560 753728 753831 761872 765208 766042 790966 791990 793583 795104 800504 803184 804373 804753 806045 811028 811814 811832 812082 817824 818408 820406 820416 827081 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small pussy fuck"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая pussy секс"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая pussy секс"
]
|
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.