Query Metrics
7
Database Queries
7
Different statements
180.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.49 ms (83.39%) |
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 395742 424862 425512 426294 428126 433339 435454 450687 470436 475986 485149 490797 507944 522409 528096 535559 548637 549270 573382 578108 586672 586677 589146 591701 592189 592210 593497 593781 595722 597849 604068 606873 607926 608428 608444 612346 615895 617472 637418 638248 638550 642190 644813 655833 657529 664368 667842 670276 672622 675638 676427 678908 695347 704339 708909 709705 711673 711946 715853 716112 718203 718264 718311 720037 726196 726812 726836 727673 730422 732256 732262 732293 732782 737728 738758 738771 742579 750603 750608 754774 757042 757329 763559 766745 766760 767252 770520 771155 775090 775175 775195 776602 776857 777073 781959 788251 788808 792602 792630 792884 792892 802458 805876 806050 806072 807692 808447 811451 813382 813388 815357 815451 815592 815699 815847 815875 815897 816547 817928 820578 ] |
||||||||||||||||||||||||||||||
|
17.88 ms (9.91%) |
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 711673 711946 718264 672622 675638 695347 708909 715853 716112 718311 655833 657529 664368 667842 670276 676427 678908 704339 548637 573382 578108 608444 638248 586672 591701 595722 604068 637418 589146 592210 593497 615895 586677 592189 593781 597849 606873 607926 638550 775090 776857 792884 802458 806072 775175 792892 806050 811451 813388 727673 732262 754774 757042 781959 805876 807692 808447 813382 726812 732256 732782 750608 757329 766745 737728 766760 771155 726196 730422 732293 763559 726836 738758 738771 742579 750603 767252 770520 608428 617472 642190 709705 718203 720037 775195 776602 777073 788251 788808 792602 792630 395742 435454 522409 428126 485149 433339 507944 528096 535559 549270 612346 424862 425512 426294 815357 815897 644813 815592 820578 815451 815699 816547 817928 815847 815875 450687 470436 475986 490797 ] |
||||||||||||||||||||||||||||||
|
4.49 ms (2.49%) |
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 395742 424862 425512 426294 428126 433339 435454 450687 470436 475986 485149 490797 507944 522409 528096 535559 548637 549270 573382 578108 586672 586677 589146 591701 592189 592210 593497 593781 595722 597849 604068 606873 607926 608428 608444 612346 615895 617472 637418 638248 638550 642190 644813 655833 657529 664368 667842 670276 672622 675638 676427 678908 695347 704339 708909 709705 711673 711946 715853 716112 718203 718264 718311 720037 726196 726812 726836 727673 730422 732256 732262 732293 732782 737728 738758 738771 742579 750603 750608 754774 757042 757329 763559 766745 766760 767252 770520 771155 775090 775175 775195 776602 776857 777073 781959 788251 788808 792602 792630 792884 792892 802458 805876 806050 806072 807692 808447 811451 813382 813388 815357 815451 815592 815699 815847 815875 815897 816547 817928 820578 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"негритянки длинные во…"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожая длинные"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чернокожая длинные"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.87%) |
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.