Query Metrics
7
Database Queries
7
Different statements
150.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.88 ms (83.91%) |
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 188462 400199 402848 418589 420638 423912 425037 427166 434576 434693 437929 439504 440876 441623 448864 449061 450334 450441 451672 454801 459151 463840 469554 469823 478285 478963 478970 479816 481871 482780 483814 485129 485648 487730 488483 488939 492703 492714 499697 500304 502064 502324 505418 508187 509833 510898 516015 516038 518643 519872 521452 525669 528384 531377 536613 544066 545440 550531 558200 559295 559810 568189 573206 576256 578829 584434 593812 593994 594861 596929 601655 601724 602259 603954 604058 605673 616382 617395 619574 627137 629819 646669 647315 649921 653455 663815 669919 673901 687630 688698 693944 705099 709316 709374 713565 714088 714183 715818 726131 730216 734614 736358 752710 756975 764814 769482 772971 775683 776096 779840 780603 784750 792652 796702 797055 801722 801788 803047 807004 815441 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (9.74%) |
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 400199 485129 584434 649921 780603 730216 188462 521452 752710 714183 437929 402848 488483 478285 605673 423912 483814 536613 627137 573206 593994 502064 518643 485648 519872 434693 478963 478970 784750 439504 469823 451672 492703 705099 713565 568189 647315 594861 792652 450334 487730 646669 448864 482780 505418 601724 425037 492714 544066 454801 508187 617395 775683 602259 441623 459151 578829 449061 693944 616382 469554 463840 509833 559295 629819 593812 653455 596929 669919 440876 479816 558200 427166 525669 604058 779840 510898 450441 528384 516015 420638 601655 502324 576256 603954 550531 516038 709316 673901 687630 663815 715818 772971 688698 764814 714088 434576 796702 756975 619574 418589 531377 803047 734614 769482 801788 726131 499697 545440 797055 801722 500304 776096 815441 488939 709374 736358 481871 559810 807004 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.96%) |
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 188462 400199 402848 418589 420638 423912 425037 427166 434576 434693 437929 439504 440876 441623 448864 449061 450334 450441 451672 454801 459151 463840 469554 469823 478285 478963 478970 479816 481871 482780 483814 485129 485648 487730 488483 488939 492703 492714 499697 500304 502064 502324 505418 508187 509833 510898 516015 516038 518643 519872 521452 525669 528384 531377 536613 544066 545440 550531 558200 559295 559810 568189 573206 576256 578829 584434 593812 593994 594861 596929 601655 601724 602259 603954 604058 605673 616382 617395 619574 627137 629819 646669 647315 649921 653455 663815 669919 673901 687630 688698 693944 705099 709316 709374 713565 714088 714183 715818 726131 730216 734614 736358 752710 756975 764814 769482 772971 775683 776096 779840 780603 784750 792652 796702 797055 801722 801788 803047 807004 815441 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big squirt"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.96%) |
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.