Query Metrics
7
Database Queries
7
Different statements
187.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.62 ms (86.20%) |
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 5537 393422 393812 396268 505454 512637 531328 533987 535576 536190 542842 543160 543619 543788 554346 554799 554882 557862 573978 583338 592011 609216 613332 615382 623505 627581 630952 631739 634133 634337 635419 636202 639217 640856 646602 647265 649771 652535 657590 657591 658096 658269 665373 667576 667676 667886 668435 668849 669444 672379 674561 677513 680285 684282 689257 691000 691400 691603 691847 701794 703173 705598 709277 710952 715230 718815 719859 720637 721759 723050 723532 727508 728875 731059 736752 737501 738147 740158 741090 743327 744674 745477 746315 746396 749196 750035 750136 751207 753121 754038 755264 755451 756112 759161 763325 764676 769656 771387 772391 776146 778497 786465 787866 796830 797577 800251 802873 807794 809208 811438 817520 817760 818598 821355 821815 824064 826964 827727 ] |
||||||||||||||||||||||||||||||
|
14.01 ms (7.47%) |
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 505454 533987 531328 543160 543788 554346 668435 647265 649771 718815 723050 677513 689257 691400 623505 631739 636202 639217 778497 743327 749196 771387 755264 769656 764676 741090 751207 763325 657590 665373 796830 800251 755451 627581 736752 657591 684282 652535 672379 634133 640856 727508 703173 535576 811438 824064 536190 750136 772391 543619 740158 802873 613332 826964 821815 667576 691847 709277 554799 786465 737501 753121 787866 776146 393812 5537 723532 818598 825655 658096 720637 731059 542842 615382 821355 512637 573978 691000 719859 667886 710952 715230 609216 592011 738147 756112 807794 746396 759161 770921 744674 750035 721759 393422 658269 396268 691603 635419 809208 745477 817760 827727 701794 817520 554882 557862 668849 680285 746315 754038 797577 583338 674561 667676 646602 669444 634337 630952 728875 705598 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (1.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс член"
]
|
||||||||||||||||||||||||||||||
|
3.18 ms (1.70%) |
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 5537 393422 393812 396268 505454 512637 531328 533987 535576 536190 542842 543160 543619 543788 554346 554799 554882 557862 573978 583338 592011 609216 613332 615382 623505 627581 630952 631739 634133 634337 635419 636202 639217 640856 646602 647265 649771 652535 657590 657591 658096 658269 665373 667576 667676 667886 668435 668849 669444 672379 674561 677513 680285 684282 689257 691000 691400 691603 691847 701794 703173 705598 709277 710952 715230 718815 719859 720637 721759 723050 723532 727508 728875 731059 736752 737501 738147 740158 741090 743327 744674 745477 746315 746396 749196 750035 750136 751207 753121 754038 755264 755451 756112 759161 763325 764676 769656 771387 772391 776146 778497 786465 787866 796830 797577 800251 802873 807794 809208 811438 817520 817760 818598 821355 821815 824064 826964 827727 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex dick"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.