Query Metrics
7
Database Queries
7
Different statements
189.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.48 ms (86.78%) |
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 33431 61969 62251 191312 247545 386787 392159 398038 407509 421420 425505 429824 440526 441295 443706 445497 445818 447138 450582 452454 454048 454059 458296 460626 465481 465495 465675 466859 468157 468159 473712 481428 482641 483853 492630 494647 495376 496840 502762 507191 507547 509610 513507 517452 533930 538459 541265 544147 550331 552569 552863 553225 555994 556504 565736 567313 568818 578391 579487 580251 580896 581196 587103 587241 588399 596968 600636 604826 612458 613414 628648 628667 644206 649487 658920 662897 663990 665199 667845 672369 689042 693939 709460 716640 718684 721870 725244 735291 739441 740262 740545 742356 742409 745946 750387 751067 751795 759129 759146 765343 765794 768884 769148 775669 780620 780772 781704 781928 783745 784102 785803 798385 802488 804436 807028 808018 812763 818353 824272 824370 ] |
||||||||||||||||||||||||||||||
|
15.95 ms (8.42%) |
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 750387 759129 808018 725244 751795 739441 742409 745946 765343 769148 721870 780772 784102 407509 191312 450582 481428 507547 62251 61969 441295 465495 483853 468157 473712 494647 552863 541265 552569 553225 568818 693939 644206 596968 742356 443706 465481 495376 513507 502762 580896 718684 587241 735291 740262 398038 555994 579487 600636 612458 812763 447138 445818 386787 33431 429824 818353 824272 824370 454048 458296 465675 492630 496840 533930 507191 538459 466859 567313 578391 556504 658920 665199 667845 672369 689042 649487 663990 709460 565736 581196 587103 604826 613414 588399 628667 628648 781704 785803 802488 804436 740545 751067 759146 768884 765794 775669 780620 781928 783745 392159 425505 421420 468159 247545 440526 452454 550331 445497 544147 716640 798385 807028 580251 662897 482641 454059 460626 517452 509610 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.37%) |
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 33431 61969 62251 191312 247545 386787 392159 398038 407509 421420 425505 429824 440526 441295 443706 445497 445818 447138 450582 452454 454048 454059 458296 460626 465481 465495 465675 466859 468157 468159 473712 481428 482641 483853 492630 494647 495376 496840 502762 507191 507547 509610 513507 517452 533930 538459 541265 544147 550331 552569 552863 553225 555994 556504 565736 567313 568818 578391 579487 580251 580896 581196 587103 587241 588399 596968 600636 604826 612458 613414 628648 628667 644206 649487 658920 662897 663990 665199 667845 672369 689042 693939 709460 716640 718684 721870 725244 735291 739441 740262 740545 742356 742409 745946 750387 751067 751795 759129 759146 765343 765794 768884 769148 775669 780620 780772 781704 781928 783745 784102 785803 798385 802488 804436 807028 808018 812763 818353 824272 824370 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп shower"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп shower"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass in shower"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.