Query Metrics
7
Database Queries
7
Different statements
197.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.51 ms (83.94%) |
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 95586 95873 96665 260158 326039 341546 383828 390667 391929 393481 396866 397242 397899 400834 403021 404678 408692 412311 413972 414863 424480 443407 443822 445634 449021 459804 459830 462424 463764 464326 468019 468630 468675 474679 475466 476709 477210 478451 478575 478832 479074 480757 484624 484673 484681 486478 487339 510754 515977 517008 522616 531249 531393 534208 541885 543607 544429 544748 544752 566860 576678 584073 600237 600359 600506 604523 617658 623380 631243 641079 641303 643993 650833 651038 662069 670947 670959 672138 678778 678782 686615 686860 690827 697278 703523 708462 709640 717607 718909 720877 721113 724216 731086 732256 736226 741541 756246 770520 776312 784279 784569 788783 788969 789664 790842 803679 804442 804491 805563 805565 809291 809414 809479 809534 810824 815927 816484 817340 817416 817860 ] |
||||||||||||||||||||||||||||||
|
20.05 ms (10.17%) |
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 260158 817860 788969 397242 391929 732256 770520 708462 790842 803679 776312 543607 462424 643993 397899 650833 326039 400834 475466 756246 741541 789664 817340 815927 566860 805563 480757 718909 522616 515977 672138 623380 463764 95586 541885 487339 584073 459830 486478 404678 341546 604523 414863 396866 709640 424480 809534 736226 474679 484624 484681 413972 805565 617658 464326 784569 445634 600506 443822 477210 96665 95873 721113 476709 544752 531249 817416 690827 686615 686860 717607 720877 703523 600359 641303 788783 697278 478451 510754 459804 412311 678778 678782 479074 531393 449021 816484 544748 662069 731086 484673 408692 403021 393481 478832 390667 809414 810824 468630 443407 383828 670947 631243 809291 809479 724216 641079 804442 468675 478575 534208 651038 804491 517008 544429 600237 468019 576678 670959 784279 ] |
||||||||||||||||||||||||||||||
|
4.35 ms (2.20%) |
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 95586 95873 96665 260158 326039 341546 383828 390667 391929 393481 396866 397242 397899 400834 403021 404678 408692 412311 413972 414863 424480 443407 443822 445634 449021 459804 459830 462424 463764 464326 468019 468630 468675 474679 475466 476709 477210 478451 478575 478832 479074 480757 484624 484673 484681 486478 487339 510754 515977 517008 522616 531249 531393 534208 541885 543607 544429 544748 544752 566860 576678 584073 600237 600359 600506 604523 617658 623380 631243 641079 641303 643993 650833 651038 662069 670947 670959 672138 678778 678782 686615 686860 690827 697278 703523 708462 709640 717607 718909 720877 721113 724216 731086 732256 736226 741541 756246 770520 776312 784279 784569 788783 788969 789664 790842 803679 804442 804491 805563 805565 809291 809414 809479 809534 810824 815927 816484 817340 817416 817860 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро анал mature"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро анал mature"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"trio anal mature"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.74%) |
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.