Query Metrics
7
Database Queries
7
Different statements
148.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.75 ms (84.00%) |
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 188189 387510 388792 397013 400019 408032 418684 423605 427931 437151 437772 440532 440923 444882 449222 449385 452563 452768 453092 453279 461160 461651 461759 473051 476771 485184 488639 494118 494264 495460 496730 496780 504109 507513 507653 508974 511012 511213 512937 514766 514982 518608 523229 524087 525495 525626 526608 527463 533772 535461 538499 538840 542781 547407 551625 561275 577051 577204 578760 586118 595132 595217 601659 621433 625436 634811 635249 636546 645270 647916 652273 665675 666993 682683 700307 700760 704229 707418 715120 726994 727731 727774 727925 738818 739648 741851 742489 757276 758887 759960 761015 761199 761597 765547 766690 774243 778082 778384 785732 794560 795484 797396 800239 802067 803860 804114 805354 805733 809656 810298 813467 813918 814446 817140 823659 823928 823940 824340 824362 ] |
||||||||||||||||||||||||||||||
|
14.28 ms (9.62%) |
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 452768 388792 449222 453279 496780 507513 507653 511012 514982 449385 525626 494264 595132 440532 824362 823659 823940 824340 514766 538499 538840 577204 542781 547407 652273 666993 707418 578760 629530 636546 621433 778082 805354 794560 795484 813467 757276 761199 797396 800239 803860 805733 727925 739648 761015 761597 726994 727731 742489 758887 759960 774243 738818 741851 765547 727774 766690 700760 715120 778384 785732 804114 809656 810298 427931 387510 485184 495460 461160 452563 453092 418684 400019 595217 488639 508974 527463 461651 561275 700307 704229 645270 665675 577051 625436 635249 601659 802067 634811 408032 473051 437772 518608 440923 461759 504109 512937 526608 437151 444882 524087 494118 586118 188189 397013 423605 823928 813918 814446 817140 476771 523229 525495 533772 496730 511213 535461 551625 647916 682683 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.13%) |
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 188189 387510 388792 397013 400019 408032 418684 423605 427931 437151 437772 440532 440923 444882 449222 449385 452563 452768 453092 453279 461160 461651 461759 473051 476771 485184 488639 494118 494264 495460 496730 496780 504109 507513 507653 508974 511012 511213 512937 514766 514982 518608 523229 524087 525495 525626 526608 527463 533772 535461 538499 538840 542781 547407 551625 561275 577051 577204 578760 586118 595132 595217 601659 621433 625436 634811 635249 636546 645270 647916 652273 665675 666993 682683 700307 700760 704229 707418 715120 726994 727731 727774 727925 738818 739648 741851 742489 757276 758887 759960 761015 761199 761597 765547 766690 774243 778082 778384 785732 794560 795484 797396 800239 802067 803860 804114 805354 805733 809656 810298 813467 813918 814446 817140 823659 823928 823940 824340 824362 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел creampie"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings creampie"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел creampie"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.