Query Metrics
7
Database Queries
7
Different statements
168.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.99 ms (84.46%) |
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 382014 385645 391977 401177 416751 417246 417389 418697 419822 427539 436230 439020 439158 440094 441073 443496 447160 450679 454039 454814 454983 469437 471330 474044 474848 475646 475947 493398 493679 500787 510822 513746 515490 524802 527871 529617 543930 544108 547778 547805 548836 554091 554385 557828 563687 564104 564303 568031 568292 573207 576221 579432 586375 587987 588379 598310 600358 601189 605725 606081 606402 616296 618238 619670 619699 622658 623171 627146 631245 633134 634044 634741 634902 641571 642134 642957 647839 666045 666876 670783 672780 697236 708131 711699 713440 716960 720635 728388 730343 731821 734554 734828 740636 742293 746187 747404 747981 752645 753187 761354 767474 775653 776094 782789 783355 783414 784133 786880 786920 787816 788531 792715 793534 793839 794871 796939 802365 803311 804351 808448 ] |
||||||||||||||||||||||||||||||
|
16.12 ms (9.59%) |
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 708131 618238 634902 642134 586375 601189 641571 642957 775653 787816 803311 776094 788531 802365 742293 753187 767474 783355 783414 786880 786920 808448 731821 746187 734828 740636 747981 761354 622658 634741 697236 713440 716960 720635 794871 804351 391977 792715 573207 385645 554091 670783 784133 543930 568031 564104 634044 418697 447160 515490 547805 631245 416751 605725 619699 474848 439020 471330 439158 527871 493398 752645 510822 557828 563687 619670 606402 401177 454039 666045 734554 730343 672780 711699 747404 524802 579432 554385 475646 588379 576221 587987 454814 793839 382014 417389 441073 427539 417246 443496 493679 450679 529617 500787 544108 547778 548836 606081 598310 600358 616296 623171 633134 782789 793534 475947 419822 474044 440094 513746 568292 469437 647839 796939 454983 564303 627146 666876 436230 728388 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.85%) |
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 382014 385645 391977 401177 416751 417246 417389 418697 419822 427539 436230 439020 439158 440094 441073 443496 447160 450679 454039 454814 454983 469437 471330 474044 474848 475646 475947 493398 493679 500787 510822 513746 515490 524802 527871 529617 543930 544108 547778 547805 548836 554091 554385 557828 563687 564104 564303 568031 568292 573207 576221 579432 586375 587987 588379 598310 600358 601189 605725 606081 606402 616296 618238 619670 619699 622658 623171 627146 631245 633134 634044 634741 634902 641571 642134 642957 647839 666045 666876 670783 672780 697236 708131 711699 713440 716960 720635 728388 730343 731821 734554 734828 740636 742293 746187 747404 747981 752645 753187 761354 767474 775653 776094 782789 783355 783414 784133 786880 786920 787816 788531 792715 793534 793839 794871 796939 802365 803311 804351 808448 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape vagina"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк вагин"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.88%) |
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.