Query Metrics
7
Database Queries
7
Different statements
175.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.61 ms (80.35%) |
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 384119 397396 402357 418139 424646 426220 430355 430374 443333 446028 446543 449234 450385 462071 473778 478833 479008 488224 492275 500321 504592 505803 509108 509163 511348 515571 528385 531129 531214 533010 535597 546465 554104 557828 571304 577638 579101 581938 590788 590806 594221 595605 599117 602259 604364 605399 613038 613172 615679 618190 618921 621765 625186 628377 632156 632435 633780 633788 634151 635900 637016 640772 640789 640793 641318 643100 650155 650725 664532 668780 670208 673093 673874 675188 676455 681490 687844 689542 693925 702320 708301 710033 710189 711860 720828 721811 722627 722984 723820 724698 726135 737992 740854 741060 743654 744790 747474 747492 751422 755125 757298 759648 760338 768716 775043 778285 778593 781485 785226 789854 791097 791283 791484 796384 800471 801259 801316 802328 804413 826874 ] |
||||||||||||||||||||||||||||||
|
24.58 ms (14.05%) |
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 759648 757298 747474 710189 515571 693925 643100 602259 402357 664532 632435 590806 800471 791283 791484 796384 747492 755125 804413 478833 670208 571304 802328 557828 579101 577638 689542 778285 723820 751422 632156 641318 535597 640789 628377 500321 397396 492275 650725 687844 613038 744790 710033 446543 531129 633780 640772 634151 676455 668780 675188 722627 581938 613172 618921 595605 789854 741060 737992 702320 711860 781485 479008 511348 504592 801316 640793 635900 726135 450385 509108 785226 740854 724698 720828 462071 673093 594221 778593 505803 488224 599117 621765 615679 426220 430374 528385 650155 604364 775043 743654 443333 801259 424646 473778 533010 531214 384119 760338 554104 625186 418139 826874 446028 590788 430355 509163 721811 791097 633788 637016 449234 673874 681490 708301 722984 618190 768716 546465 605399 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.53%) |
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 384119 397396 402357 418139 424646 426220 430355 430374 443333 446028 446543 449234 450385 462071 473778 478833 479008 488224 492275 500321 504592 505803 509108 509163 511348 515571 528385 531129 531214 533010 535597 546465 554104 557828 571304 577638 579101 581938 590788 590806 594221 595605 599117 602259 604364 605399 613038 613172 615679 618190 618921 621765 625186 628377 632156 632435 633780 633788 634151 635900 637016 640772 640789 640793 641318 643100 650155 650725 664532 668780 670208 673093 673874 675188 676455 681490 687844 689542 693925 702320 708301 710033 710189 711860 720828 721811 722627 722984 723820 724698 726135 737992 740854 741060 743654 744790 747474 747492 751422 755125 757298 759648 760338 768716 775043 778285 778593 781485 785226 789854 791097 791283 791484 796384 800471 801259 801316 802328 804413 826874 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оргазм впервые"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"оргазм вперв"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.79%) |
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.