Query Metrics
7
Database Queries
7
Different statements
178.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.46 ms (83.86%) |
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 393742 396224 400461 400471 401344 404059 404366 414110 414795 418411 419492 420439 421175 422503 422511 422661 422908 422929 423261 423280 431161 439844 463889 470839 472921 474766 478853 491286 494304 496356 518472 519646 521357 521779 523125 523544 523976 529565 530025 543829 547366 550207 550430 550609 553720 554472 556015 556022 558131 559942 560411 560439 560445 560635 561703 561826 562626 562886 565055 565170 565249 565481 566621 566925 567142 568579 570708 574179 575085 575106 575123 575162 575202 575729 575768 576399 580727 581695 590731 595775 595853 597263 597266 598590 600078 603077 604507 605338 606738 607125 614023 624179 624505 628365 628376 628420 632033 632314 632565 634510 636998 637023 638985 644996 663785 671619 671676 680112 701498 702164 714436 716032 744293 748147 757928 766852 766858 800421 814266 814562 ] |
||||||||||||||||||||||||||||||
|
18.44 ms (10.35%) |
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 562626 565249 702164 671619 595853 637023 603077 439844 420439 463889 491286 518472 523544 575085 575202 560411 565055 607125 575162 550207 550609 576399 558131 568579 550430 570708 800421 766858 766852 422511 814266 530025 547366 560445 561826 566925 574179 554472 580727 553720 559942 575768 680112 716032 671676 562886 565170 565481 567142 575123 581695 604507 614023 624505 632033 632314 590731 597266 624179 628365 628376 597263 598590 606738 634510 636998 595775 600078 628420 638985 605338 632565 714436 521357 575729 560439 701498 404059 470839 523976 561703 663785 519646 431161 543829 575106 748147 744293 393742 401344 404366 422661 414795 422908 644996 494304 521779 529565 474766 556015 560635 556022 566621 757928 414110 418411 421175 478853 419492 423280 496356 523125 472921 396224 400461 400471 423261 422503 422929 814562 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.75%) |
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 393742 396224 400461 400471 401344 404059 404366 414110 414795 418411 419492 420439 421175 422503 422511 422661 422908 422929 423261 423280 431161 439844 463889 470839 472921 474766 478853 491286 494304 496356 518472 519646 521357 521779 523125 523544 523976 529565 530025 543829 547366 550207 550430 550609 553720 554472 556015 556022 558131 559942 560411 560439 560445 560635 561703 561826 562626 562886 565055 565170 565249 565481 566621 566925 567142 568579 570708 574179 575085 575106 575123 575162 575202 575729 575768 576399 580727 581695 590731 595775 595853 597263 597266 598590 600078 603077 604507 605338 606738 607125 614023 624179 624505 628365 628376 628420 632033 632314 632565 634510 636998 637023 638985 644996 663785 671619 671676 680112 701498 702164 714436 716032 744293 748147 757928 766852 766858 800421 814266 814562 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young маленькая teen"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young small teen"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young маленькая teen"
]
|
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.