Query Metrics
7
Database Queries
7
Different statements
191.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.08 ms (89.12%) |
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 233353 450686 463868 494760 501073 506257 514463 518823 550276 562899 564682 571863 581318 589422 590261 593300 600261 607394 608980 616966 619244 619786 623596 623848 625504 635549 636798 642274 645836 647800 648393 659140 663203 666770 672691 674256 677136 683559 683804 687187 695764 703350 704347 705178 705339 705428 708164 711909 715124 719524 720588 722829 728246 728463 728673 729857 733161 735554 736835 737255 738222 741314 743434 743959 744902 747793 751130 751929 756716 760210 761589 761666 763331 766131 766461 767548 770343 774562 775161 777699 778096 778572 779711 780252 780723 781067 781606 782436 783567 783666 784881 785285 785998 789399 789531 791773 792015 792355 793452 797043 797951 799311 799590 800101 801216 801424 802822 804162 804493 804637 806731 807941 810129 810847 811655 811818 812579 813770 814461 825217 ] |
||||||||||||||||||||||||||||||
|
10.65 ms (5.55%) |
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 810129 736835 761589 763331 735554 233353 705428 518823 722829 642274 623848 783567 792355 793452 802822 777699 789531 806731 807941 811818 751130 767548 728463 751929 728673 733161 737255 760210 766131 770343 715124 450686 463868 501073 506257 581318 562899 571863 550276 645836 648393 719524 683559 711909 647800 663203 695764 703350 590261 619786 589422 600261 616966 608980 636798 779711 780252 781606 783666 799590 801424 812579 775161 778096 782436 791773 804493 804637 738222 743959 744902 766461 785285 789399 797951 800101 804162 810847 743434 747793 741314 728246 729857 756716 761666 607394 704347 774562 780723 785998 792015 813770 814461 825217 494760 514463 564682 677136 683804 705339 674256 705178 659140 666770 672691 687187 708164 720588 593300 619244 625504 635549 623596 778572 781067 784881 797043 799311 801216 811655 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.38%) |
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 233353 450686 463868 494760 501073 506257 514463 518823 550276 562899 564682 571863 581318 589422 590261 593300 600261 607394 608980 616966 619244 619786 623596 623848 625504 635549 636798 642274 645836 647800 648393 659140 663203 666770 672691 674256 677136 683559 683804 687187 695764 703350 704347 705178 705339 705428 708164 711909 715124 719524 720588 722829 728246 728463 728673 729857 733161 735554 736835 737255 738222 741314 743434 743959 744902 747793 751130 751929 756716 760210 761589 761666 763331 766131 766461 767548 770343 774562 775161 777699 778096 778572 779711 780252 780723 781067 781606 782436 783567 783666 784881 785285 785998 789399 789531 791773 792015 792355 793452 797043 797951 799311 799590 800101 801216 801424 802822 804162 804493 804637 806731 807941 810129 810847 811655 811818 812579 813770 814461 825217 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жестка трахают"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор секс"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.88%) |
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.