Query Metrics
7
Database Queries
7
Different statements
285.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
256.43 ms (89.93%) |
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 73724 81588 123457 187992 397163 400467 410173 468537 471522 486055 515245 528788 537568 537755 542961 543870 544358 545734 546548 547276 547282 548257 549940 550620 554790 561997 562928 563852 565156 566009 570050 574201 574286 577362 578467 581628 592837 600035 600165 607387 611309 611616 613221 619673 624214 624842 631220 649996 650788 655101 655314 655410 656046 656739 657034 657402 658292 658413 659608 663930 665512 670081 670175 671882 681808 682022 682530 683515 683538 683825 684238 685992 686040 686652 688370 689370 689757 693852 694600 695758 696277 700546 701297 702360 712794 712925 715560 718194 720628 722654 723406 731386 734508 737482 741019 744254 745764 759585 766541 774109 779832 788670 789304 794610 794743 795286 800560 803083 814065 815878 817629 817677 817678 818316 818639 820732 823152 823365 825184 827660 ] |
||||||||||||||||||||||||||||||
|
17.14 ms (6.01%) |
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 468537 548257 561997 624842 688370 684238 563852 577362 542961 565156 554790 655410 663930 657402 682530 650788 570050 578467 611616 607387 624214 600035 613221 471522 486055 528788 123457 81588 400467 665512 701297 741019 731386 794743 73724 187992 397163 410173 823152 817677 825184 814065 815878 817629 817678 818316 818639 820732 823365 827660 537755 537568 515245 547276 550620 581628 543870 546548 562928 544358 545734 547282 549940 574286 655314 671882 683515 683538 693852 695758 696277 700546 702360 712925 715560 657034 659608 682022 683825 685992 686040 686652 689757 712794 718194 720628 722654 723406 649996 655101 656046 656739 658292 658413 670081 670175 681808 689370 694600 566009 574201 600165 611309 592837 619673 631220 788670 789304 800560 779832 795286 734508 737482 744254 745764 759585 766541 774109 794610 803083 ] |
||||||||||||||||||||||||||||||
|
3.82 ms (1.34%) |
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 73724 81588 123457 187992 397163 400467 410173 468537 471522 486055 515245 528788 537568 537755 542961 543870 544358 545734 546548 547276 547282 548257 549940 550620 554790 561997 562928 563852 565156 566009 570050 574201 574286 577362 578467 581628 592837 600035 600165 607387 611309 611616 613221 619673 624214 624842 631220 649996 650788 655101 655314 655410 656046 656739 657034 657402 658292 658413 659608 663930 665512 670081 670175 671882 681808 682022 682530 683515 683538 683825 684238 685992 686040 686652 688370 689370 689757 693852 694600 695758 696277 700546 701297 702360 712794 712925 715560 718194 720628 722654 723406 731386 734508 737482 741019 744254 745764 759585 766541 774109 779832 788670 789304 794610 794743 795286 800560 803083 814065 815878 817629 817677 817678 818316 818639 820732 823152 823365 825184 827660 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелом"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелый мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.59%) |
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.