Query Metrics
7
Database Queries
7
Different statements
172.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.40 ms (84.85%) |
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 146547 161351 382662 395456 395479 403538 444215 455870 470397 473745 478498 482206 490250 505611 506487 508610 512320 514863 524714 529136 529266 530745 534239 535963 536877 536930 542614 543127 550881 558865 559281 560567 567126 567137 568007 570612 571892 577371 582435 584738 585529 588466 589650 593809 595991 597068 597688 598026 598486 598919 599701 600060 604263 610215 616593 617370 623964 625480 625903 626091 626128 627265 634315 637313 638756 641267 642162 644275 650976 653213 653302 665936 666403 666672 677910 678713 687347 692703 696132 699166 700839 706022 709201 709741 713196 718678 723998 724637 724885 731233 734293 737196 739033 739883 745607 748623 750644 759122 760332 762577 762663 763762 763869 763944 764647 768197 768613 769533 777754 783108 788854 789390 789402 792384 807170 809699 813206 813289 813749 813884 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (9.03%) |
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 777754 723998 739883 762577 598919 653302 550881 597688 763762 524714 529266 530745 482206 478498 696132 699166 593809 623964 505611 512320 692703 585529 789390 792384 768613 567126 638756 627265 625480 653213 597068 473745 559281 666672 382662 536877 567137 650976 724885 764647 634315 146547 455870 490250 506487 666403 589650 734293 768197 558865 610215 783108 807170 760332 809699 706022 535963 584738 625903 604263 759122 598486 560567 642162 529136 665936 616593 748623 750644 570612 617370 577371 568007 724637 534239 700839 813289 731233 762663 644275 788854 514863 678713 718678 600060 813749 813884 687347 709741 713196 599701 813206 745607 769533 763869 739033 395479 403538 598026 542614 709201 571892 637313 641267 588466 595991 626128 789402 737196 763944 395456 582435 444215 161351 470397 536930 543127 677910 508610 626091 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (2.06%) |
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 146547 161351 382662 395456 395479 403538 444215 455870 470397 473745 478498 482206 490250 505611 506487 508610 512320 514863 524714 529136 529266 530745 534239 535963 536877 536930 542614 543127 550881 558865 559281 560567 567126 567137 568007 570612 571892 577371 582435 584738 585529 588466 589650 593809 595991 597068 597688 598026 598486 598919 599701 600060 604263 610215 616593 617370 623964 625480 625903 626091 626128 627265 634315 637313 638756 641267 642162 644275 650976 653213 653302 665936 666403 666672 677910 678713 687347 692703 696132 699166 700839 706022 709201 709741 713196 718678 723998 724637 724885 731233 734293 737196 739033 739883 745607 748623 750644 759122 760332 762577 762663 763762 763869 763944 764647 768197 768613 769533 777754 783108 788854 789390 789402 792384 807170 809699 813206 813289 813749 813884 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"наездница огромный ху…"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз огромный член"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.82%) |
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.