Query Metrics
7
Database Queries
7
Different statements
163.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.15 ms (83.89%) |
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 385838 388004 392165 417284 422096 436392 439630 441239 459449 470265 472341 475350 476849 480161 480759 483330 485730 487116 487153 487802 488896 490059 495482 502208 503986 504282 504703 508052 510611 513473 514969 521900 522306 526780 527581 527701 528887 537282 546760 548266 550483 552403 558210 560037 565622 566729 567686 568743 568783 571082 571725 577485 579124 581383 582523 597841 602420 607873 614205 614209 614377 614596 618101 622889 637176 643530 644101 669609 671494 673177 680375 686540 687614 689166 695795 696529 700531 705727 705772 705786 721865 721993 723970 724690 725573 725719 732166 745557 745986 746073 747500 748134 757044 758421 760934 762228 764341 765553 765827 768773 769126 777286 778661 779620 782784 783665 786324 788368 791685 792044 793214 793278 794615 794784 798906 798911 799006 810348 812618 813271 ] |
||||||||||||||||||||||||||||||
|
15.87 ms (9.71%) |
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 514969 637176 793214 791685 475350 487153 480161 392165 441239 669609 794615 798911 527581 602420 643530 793278 745986 721865 537282 579124 723970 508052 527701 513473 567686 560037 745557 700531 439630 487802 786324 528887 385838 671494 782784 748134 746073 644101 778661 747500 680375 568783 614596 614205 566729 765827 417284 614209 705727 794784 472341 597841 721993 769126 779620 798906 388004 618101 673177 607873 762228 725573 768773 732166 705772 510611 571725 436392 485730 480759 502208 526780 488896 614377 504282 565622 422096 522306 705786 686540 582523 696529 764341 765553 757044 546760 550483 695795 812618 799006 724690 788368 571082 813271 689166 687614 622889 783665 792044 810348 758421 760934 777286 459449 487116 581383 503986 577485 552403 725719 483330 495482 558210 568743 490059 476849 470265 504703 521900 548266 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (2.18%) |
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 385838 388004 392165 417284 422096 436392 439630 441239 459449 470265 472341 475350 476849 480161 480759 483330 485730 487116 487153 487802 488896 490059 495482 502208 503986 504282 504703 508052 510611 513473 514969 521900 522306 526780 527581 527701 528887 537282 546760 548266 550483 552403 558210 560037 565622 566729 567686 568743 568783 571082 571725 577485 579124 581383 582523 597841 602420 607873 614205 614209 614377 614596 618101 622889 637176 643530 644101 669609 671494 673177 680375 686540 687614 689166 695795 696529 700531 705727 705772 705786 721865 721993 723970 724690 725573 725719 732166 745557 745986 746073 747500 748134 757044 758421 760934 762228 764341 765553 765827 768773 769126 777286 778661 779620 782784 783665 786324 788368 791685 792044 793214 793278 794615 794784 798906 798911 799006 810348 812618 813271 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex in forest"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс лес природ"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.90%) |
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.