Query Metrics
7
Database Queries
7
Different statements
146.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.57 ms (85.75%) |
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 408694 435879 436450 441814 454749 480979 488633 489131 505958 510288 517097 527332 537086 537379 537454 540208 542429 546367 548161 556719 557218 558541 560808 560895 565701 567902 567969 575885 577751 579056 592326 598681 598778 598955 603751 604807 609089 610826 613245 613400 614063 626613 627669 645078 647259 647453 652092 652958 655507 655575 656958 657508 659477 660266 660667 661522 661529 661540 662803 663345 666502 671142 671187 671204 673513 673910 675185 677337 678548 679073 680014 682880 682884 684411 686469 686481 686540 688536 690027 690712 691362 692822 701855 701909 703807 704635 705028 705029 705106 706143 708321 708846 709046 711712 712398 713024 715190 715353 715377 716948 717322 718333 719425 719437 813631 814466 816127 816176 817993 818112 818241 819273 820071 820090 821593 825133 826665 826953 827159 828128 ] |
||||||||||||||||||||||||||||||
|
12.50 ms (8.54%) |
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 436450 454749 408694 435879 517097 505958 488633 489131 441814 817993 818241 813631 821593 826953 827159 814466 816127 819273 820090 816176 818112 820071 825133 828128 826665 480979 537379 510288 537086 537454 540208 527332 565701 542429 556719 560895 567902 575885 577751 557218 560808 645078 655507 661529 661540 663345 666502 673910 678548 682884 686469 688536 690027 691362 701855 701909 705028 705029 706143 708321 709046 712398 715353 715377 652958 655575 659477 661522 662803 671142 671187 671204 675185 679073 684411 686481 686540 690712 705106 715190 716948 718333 647259 647453 652092 656958 657508 660266 660667 673513 677337 680014 682880 692822 703807 704635 708846 711712 713024 717322 719425 719437 546367 548161 558541 567969 579056 592326 603751 610826 613400 614063 626613 598681 598778 598955 609089 613245 604807 627669 ] |
||||||||||||||||||||||||||||||
|
2.51 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 408694 435879 436450 441814 454749 480979 488633 489131 505958 510288 517097 527332 537086 537379 537454 540208 542429 546367 548161 556719 557218 558541 560808 560895 565701 567902 567969 575885 577751 579056 592326 598681 598778 598955 603751 604807 609089 610826 613245 613400 614063 626613 627669 645078 647259 647453 652092 652958 655507 655575 656958 657508 659477 660266 660667 661522 661529 661540 662803 663345 666502 671142 671187 671204 673513 673910 675185 677337 678548 679073 680014 682880 682884 684411 686469 686481 686540 688536 690027 690712 691362 692822 701855 701909 703807 704635 705028 705029 705106 706143 708321 708846 709046 711712 712398 713024 715190 715353 715377 716948 717322 718333 719425 719437 813631 814466 816127 816176 817993 818112 818241 819273 820071 820090 821593 825133 826665 826953 827159 828128 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мастурбация русской молодой"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац русск молодой"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.27 ms (0.87%) |
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.