Query Metrics
7
Database Queries
7
Different statements
188.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.99 ms (84.02%) |
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 38857 92307 384290 391150 394710 395354 396037 398883 410129 413444 420157 421874 425686 431585 432699 433051 440755 441698 443064 445827 446642 448468 449906 450301 452602 453581 454536 456581 462989 464470 466827 472196 493781 494044 509747 514985 516146 516623 516924 524139 525429 530146 532603 532638 533083 533526 534660 535187 538771 541771 556771 563409 566338 566653 571801 578797 581805 592267 605024 611486 613768 614696 614797 614830 628527 628663 631830 675204 677270 680328 692110 702632 716201 723252 726317 735810 740565 749362 752769 752892 758334 759900 759926 761121 762119 762784 770159 775454 776799 777355 792259 795934 797151 803721 806109 808544 809852 811615 811673 812161 815539 816302 816754 817358 818730 819111 819308 819742 819972 824524 825944 826381 827038 827734 828451 828719 828741 ] |
||||||||||||||||||||||||||||||
|
19.56 ms (10.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 716201 440755 563409 726317 431585 533083 631830 811673 614830 452602 524139 816754 827734 462989 525429 613768 592267 811615 758334 776799 740565 605024 449906 395354 410129 420157 425686 454536 396037 824524 509747 614696 702632 532638 759900 566653 38857 828451 391150 611486 541771 735810 808544 450301 466827 453581 433051 92307 516146 827038 815539 816302 819742 533526 534660 803721 770159 812161 761121 762119 581805 446642 421874 443064 472196 448468 441698 532603 432699 516924 493781 456581 464470 516623 818730 823742 826381 822803 824287 825944 819972 828741 828719 566338 819308 556771 384290 514985 578797 628663 628527 398883 723252 675204 677270 680328 792259 797151 806109 795934 759926 762784 809852 530146 571801 614797 535187 538771 692110 752769 752892 775454 777355 817358 819111 749362 394710 413444 445827 494044 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.75%) |
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 38857 92307 384290 391150 394710 395354 396037 398883 410129 413444 420157 421874 425686 431585 432699 433051 440755 441698 443064 445827 446642 448468 449906 450301 452602 453581 454536 456581 462989 464470 466827 472196 493781 494044 509747 514985 516146 516623 516924 524139 525429 530146 532603 532638 533083 533526 534660 535187 538771 541771 556771 563409 566338 566653 571801 578797 581805 592267 605024 611486 613768 614696 614797 614830 628527 628663 631830 675204 677270 680328 692110 702632 716201 723252 726317 735810 740565 749362 752769 752892 758334 759900 759926 761121 762119 762784 770159 775454 776799 777355 792259 795934 797151 803721 806109 808544 809852 811615 811673 812161 815539 816302 816754 817358 818730 819111 819308 819742 819972 824524 825944 826381 827038 827734 828451 828719 828741 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass panties"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.78%) |
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.