Query Metrics
7
Database Queries
7
Different statements
210.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.20 ms (89.10%) |
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 398057 412180 412852 414062 414082 416668 416692 416703 417783 431439 432283 439033 441042 466745 469221 469602 478489 483742 493715 500313 512486 514876 527920 529638 530953 534772 538289 548957 551556 554100 576314 584164 590795 598141 604659 609804 612997 629711 629732 630449 639315 642048 642165 644036 648679 656148 656816 656875 656879 656888 656893 657527 657562 658774 658785 658850 660580 661455 661653 663317 664572 664717 664747 666858 675858 680797 691286 697614 702341 703277 706133 708570 709542 711611 712342 717543 717553 719431 720448 723204 723266 729327 731595 735248 737055 738820 740269 740935 749603 750565 751438 752592 753023 758806 760513 761430 761646 765569 765647 770219 770381 770400 776057 782511 782791 783702 785813 787514 790399 792092 793255 793280 793281 793283 800799 803092 808328 821035 823224 ] |
||||||||||||||||||||||||||||||
|
13.40 ms (6.38%) |
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 711611 712342 648679 656879 656893 661653 664572 656888 663317 719431 720448 723266 609804 639315 629732 629711 604659 785813 776057 731595 740935 729327 749603 758806 740269 760513 765647 770381 723204 595376 709542 590795 735248 514876 412852 431439 466745 469221 792092 432283 416692 530953 534772 675858 598141 753023 800799 478489 416668 512486 414082 823224 656148 717553 554100 630449 793255 761430 737055 752592 787514 803092 398057 414062 469602 551556 584164 657527 658850 658774 658785 661455 664747 691286 697614 706133 657562 664717 717543 548957 612997 642165 783702 790399 793281 793283 808328 751438 761646 738820 765569 770219 750565 770400 642048 644036 703277 782511 782791 793280 412180 416703 527920 576314 417783 441042 439033 500313 483742 821035 493715 529638 538289 656816 666858 702341 680797 708570 656875 660580 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.49%) |
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 398057 412180 412852 414062 414082 416668 416692 416703 417783 431439 432283 439033 441042 466745 469221 469602 478489 483742 493715 500313 512486 514876 527920 529638 530953 534772 538289 548957 551556 554100 576314 584164 590795 598141 604659 609804 612997 629711 629732 630449 639315 642048 642165 644036 648679 656148 656816 656875 656879 656888 656893 657527 657562 658774 658785 658850 660580 661455 661653 663317 664572 664717 664747 666858 675858 680797 691286 697614 702341 703277 706133 708570 709542 711611 712342 717543 717553 719431 720448 723204 723266 729327 731595 735248 737055 738820 740269 740935 749603 750565 751438 752592 753023 758806 760513 761430 761646 765569 765647 770219 770381 770400 776057 782511 782791 783702 785813 787514 790399 792092 793255 793280 793281 793283 800799 803092 808328 821035 823224 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen anal solo"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen анал соло"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.