Query Metrics
7
Database Queries
7
Different statements
225.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.90 ms (85.68%) |
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 27928 98190 185642 233042 283983 329500 382507 382650 384543 385484 394235 396859 398921 400619 400931 401352 401431 401652 403414 413253 413270 417343 418465 420507 425676 428685 443457 444735 450398 451283 451382 454674 455493 455696 457639 458558 461900 462782 465145 475353 481340 482374 486253 488639 498603 510664 520392 521760 523368 531626 533030 537488 539458 545788 556807 557497 560147 576069 582526 584424 587247 589947 593382 599407 601772 605833 611044 612119 631676 642155 642216 649983 663758 681392 683478 696329 697113 698910 704325 708280 711600 715485 725810 726844 732367 733767 737796 739780 740560 755203 755387 757155 764693 764869 765850 768591 772096 773463 774415 777790 779190 779267 779476 780089 784237 787418 787554 795386 798177 800813 801139 801320 802098 802958 805027 805031 807345 812707 814275 828708 ] |
||||||||||||||||||||||||||||||
|
21.17 ms (9.40%) |
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 587247 779267 807345 784237 805031 805027 420507 481340 428685 454674 498603 444735 774415 814275 537488 482374 683478 698910 704325 708280 642155 631676 802958 739780 755387 757155 773463 733767 725810 233042 400619 403414 396859 329500 384543 385484 401431 461900 401352 418465 398921 828708 649983 382507 98190 488639 486253 457639 611044 772096 401652 520392 545788 711600 462782 510664 696329 681392 740560 185642 560147 557497 697113 801320 732367 455493 715485 812707 798177 764693 755203 27928 443457 413270 413253 458558 450398 455696 531626 556807 576069 582526 584424 589947 593382 605833 601772 779190 764869 451382 475353 394235 400931 417343 451283 533030 521760 283983 382650 425676 465145 539458 523368 663758 599407 642216 612119 777790 779476 780089 787554 801139 802098 765850 800813 726844 737796 768591 787418 795386 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.40%) |
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 27928 98190 185642 233042 283983 329500 382507 382650 384543 385484 394235 396859 398921 400619 400931 401352 401431 401652 403414 413253 413270 417343 418465 420507 425676 428685 443457 444735 450398 451283 451382 454674 455493 455696 457639 458558 461900 462782 465145 475353 481340 482374 486253 488639 498603 510664 520392 521760 523368 531626 533030 537488 539458 545788 556807 557497 560147 576069 582526 584424 587247 589947 593382 599407 601772 605833 611044 612119 631676 642155 642216 649983 663758 681392 683478 696329 697113 698910 704325 708280 711600 715485 725810 726844 732367 733767 737796 739780 740560 755203 755387 757155 764693 764869 765850 768591 772096 773463 774415 777790 779190 779267 779476 780089 784237 787418 787554 795386 798177 800813 801139 801320 802098 802958 805027 805031 807345 812707 814275 828708 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая большие boobs"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful big boobs"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.78%) |
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.