Query Metrics
7
Database Queries
7
Different statements
172.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.31 ms (83.32%) |
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 185855 187595 187636 189743 233029 359102 361315 365910 385638 388365 397362 404306 405546 411326 411604 411615 413303 424985 428829 439524 439651 439686 439735 443758 451931 451991 452145 454887 460760 460761 462290 465592 465955 466235 467550 469509 470959 474824 474877 479073 479082 479145 480392 483147 484443 487347 490267 490918 491989 502749 508746 517013 518846 521147 523579 535264 546962 550380 555098 557148 560394 560430 563209 563227 563436 577965 589707 603151 617016 697180 710502 712311 712553 712812 713635 714171 714646 715450 718553 722088 724476 726767 726902 728442 734102 736402 740158 741906 742812 743724 744904 745196 745382 748163 748240 758436 758446 769429 772100 774176 781759 781980 797220 799016 801319 804006 807539 807627 808021 808496 808541 814909 816784 816785 816792 818643 818824 818851 819001 823444 ] |
||||||||||||||||||||||||||||||
|
18.22 ms (10.59%) |
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 397362 734102 769429 742812 521147 523579 479082 388365 428829 404306 560394 563209 546962 781759 724476 736402 748163 748240 470959 818851 560430 712311 726902 460760 411326 411615 385638 814909 818643 490267 722088 577965 617016 808541 758446 726767 744904 439735 187636 361315 603151 808021 479145 797220 451931 451991 535264 465955 411604 465592 462290 479073 466235 491989 469509 517013 405546 550380 807627 563436 563227 189743 365910 483147 480392 439651 439686 474877 439524 502749 508746 823444 710502 740158 745196 743724 233029 818824 555098 712553 799016 443758 819001 816792 557148 712812 714646 589707 413303 474824 490918 484443 518846 424985 816784 816785 454887 697180 714171 718553 715450 801319 807539 758436 804006 808496 741906 772100 745382 774176 728442 781980 187595 467550 359102 460761 185855 452145 713635 487347 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.44%) |
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 185855 187595 187636 189743 233029 359102 361315 365910 385638 388365 397362 404306 405546 411326 411604 411615 413303 424985 428829 439524 439651 439686 439735 443758 451931 451991 452145 454887 460760 460761 462290 465592 465955 466235 467550 469509 470959 474824 474877 479073 479082 479145 480392 483147 484443 487347 490267 490918 491989 502749 508746 517013 518846 521147 523579 535264 546962 550380 555098 557148 560394 560430 563209 563227 563436 577965 589707 603151 617016 697180 710502 712311 712553 712812 713635 714171 714646 715450 718553 722088 724476 726767 726902 728442 734102 736402 740158 741906 742812 743724 744904 745196 745382 748163 748240 758436 758446 769429 772100 774176 781759 781980 797220 799016 801319 804006 807539 807627 808021 808496 808541 814909 816784 816785 816792 818643 818824 818851 819001 823444 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс mature"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob mature"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс mature"
]
|
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.