Query Metrics
7
Database Queries
7
Different statements
163.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.00 ms (85.18%) |
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 319164 394406 394608 404233 476676 504517 515896 518547 520753 530024 532745 533726 533746 535627 536305 538536 543950 544323 546247 553103 559178 560997 566035 569646 571439 573977 574159 579818 584961 585457 592003 592458 604341 604569 608407 620488 623196 625299 628112 628500 629172 633602 635835 639574 639745 641567 644916 648202 648870 652850 662137 663294 669073 675572 678580 678586 679114 679135 679643 682991 685454 685633 690832 690855 690913 692813 693041 693860 694083 694476 694553 694562 695186 695621 695631 695919 695928 696097 696349 697354 697373 698409 698421 698513 699390 699691 699731 699779 701535 712998 717543 720008 723735 725560 726249 729079 729917 735027 735152 736107 742926 744677 747503 750294 751995 756535 761077 767066 774251 776913 783381 788169 799746 799972 800477 800761 800800 805532 814002 814250 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (8.32%) |
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 520753 532745 639745 559178 566035 533726 476676 662137 742926 604569 515896 623196 533746 644916 608407 530024 695928 695919 699779 504517 699691 694553 695186 698421 690832 604341 814250 553103 648870 682991 546247 592458 629172 518547 620488 729079 592003 761077 725560 535627 574159 694083 571439 404233 735152 695631 701535 696097 783381 747503 774251 538536 692813 696349 712998 800800 729917 800761 805532 720008 767066 675572 717543 726249 751995 536305 543950 685454 698513 685633 694476 573977 799972 776913 799746 699731 663294 394608 394406 756535 750294 679643 669073 735027 585457 690855 690913 678586 679114 679135 693860 694562 695621 699390 652850 693041 697373 584961 635835 641567 633602 639574 736107 744677 628112 788169 628500 814002 697354 723735 698409 648202 625299 319164 560997 544323 579818 800477 569646 678580 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.99%) |
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 319164 394406 394608 404233 476676 504517 515896 518547 520753 530024 532745 533726 533746 535627 536305 538536 543950 544323 546247 553103 559178 560997 566035 569646 571439 573977 574159 579818 584961 585457 592003 592458 604341 604569 608407 620488 623196 625299 628112 628500 629172 633602 635835 639574 639745 641567 644916 648202 648870 652850 662137 663294 669073 675572 678580 678586 679114 679135 679643 682991 685454 685633 690832 690855 690913 692813 693041 693860 694083 694476 694553 694562 695186 695621 695631 695919 695928 696097 696349 697354 697373 698409 698421 698513 699390 699691 699731 699779 701535 712998 717543 720008 723735 725560 726249 729079 729917 735027 735152 736107 742926 744677 747503 750294 751995 756535 761077 767066 774251 776913 783381 788169 799746 799972 800477 800761 800800 805532 814002 814250 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"двоем в попу"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"два анал"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.97%) |
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.