Query Metrics
7
Database Queries
7
Different statements
166.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.71 ms (83.77%) |
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 197445 413503 424781 425507 444413 455373 461224 465818 466396 476425 483364 512681 521210 526632 527258 530567 531925 545535 548258 550595 551022 551837 552930 557786 558102 562526 563083 565123 565128 566670 570891 575999 577432 578774 585303 587568 598955 602219 607378 618292 618867 626948 628698 629799 629977 634866 634877 641627 644550 644766 650301 652253 664559 664731 665103 665237 665894 666836 667464 668496 668532 669755 669758 689364 690048 693508 700086 702232 704542 705396 713842 714148 714358 721475 724538 727524 728238 729948 733129 737736 738220 747183 752812 753663 763179 769450 772772 776636 781964 788240 788276 800237 801091 803185 803984 807393 807777 808038 808126 809288 811360 811557 812392 812524 815398 819381 820085 820374 823848 823868 823983 824173 824313 825056 825183 825885 826012 828008 828604 ] |
||||||||||||||||||||||||||||||
|
15.94 ms (9.56%) |
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 526632 483364 565128 634866 629799 425507 197445 823983 824313 825056 823848 826012 823868 819381 820085 820374 824173 825885 815398 824734 825183 828008 828604 521210 530567 531925 565123 551837 562526 563083 545535 551022 552930 558102 575999 652253 664731 668532 690048 700086 702232 714358 650301 665103 665894 666836 689364 693508 721475 665237 668496 669755 669758 713842 550595 566670 570891 585303 602219 634877 641627 587568 598955 644550 618292 629977 607378 618867 644766 803185 811360 776636 788240 808038 812392 729948 769450 772772 788276 807393 812524 728238 737736 738220 724538 727524 733129 752812 753663 747183 763179 626948 704542 705396 714148 781964 800237 801091 803984 807777 808126 809288 811557 548258 578774 444413 413503 466396 461224 557786 577432 664559 667464 628698 455373 465818 476425 424781 527258 512681 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.91%) |
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 197445 413503 424781 425507 444413 455373 461224 465818 466396 476425 483364 512681 521210 526632 527258 530567 531925 545535 548258 550595 551022 551837 552930 557786 558102 562526 563083 565123 565128 566670 570891 575999 577432 578774 585303 587568 598955 602219 607378 618292 618867 626948 628698 629799 629977 634866 634877 641627 644550 644766 650301 652253 664559 664731 665103 665237 665894 666836 667464 668496 668532 669755 669758 689364 690048 693508 700086 702232 704542 705396 713842 714148 714358 721475 724538 727524 728238 729948 733129 737736 738220 747183 752812 753663 763179 769450 772772 776636 781964 788240 788276 800237 801091 803185 803984 807393 807777 808038 808126 809288 811360 811557 812392 812524 815398 819381 820085 820374 823848 823868 823983 824173 824313 825056 825183 825885 826012 828008 828604 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая saggy сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette saggy tits"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая saggy сиськ"
]
|
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.