Query Metrics
7
Database Queries
7
Different statements
148.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.12 ms (82.46%) |
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 3616 7169 20715 232995 233112 310683 358792 382254 382549 385794 387496 390945 395271 395720 396849 397223 397362 405491 409886 411817 411946 443963 444834 454267 455910 467248 477455 484125 485691 486314 490192 492392 502034 504354 504414 515171 519341 520300 522056 525528 532982 533022 536754 537157 537581 538660 547340 547568 549244 550647 561777 563129 565648 566681 589597 594067 603374 619430 624854 644699 644705 665108 665116 665466 665881 667244 667647 668176 672796 676467 698958 702454 702893 714162 716215 716753 721475 721570 721754 724274 724276 736957 739478 739690 741093 745055 746638 746753 747171 748389 750869 757641 759847 765305 770061 772694 774763 774766 774767 781734 788232 788276 788461 788787 788873 789294 789535 789969 789992 793529 795573 795577 798916 801237 802409 804224 804944 808012 808866 828373 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (10.61%) |
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 828373 525528 533022 536754 537157 537581 547568 561777 565648 566681 665881 716753 721570 667244 672796 698958 721475 716215 547340 563129 603374 644705 594067 619430 644699 774763 781734 788232 788873 789535 801237 802409 774767 788787 789294 808012 724276 739478 741093 750869 772694 788276 789969 793529 795577 798916 804944 808866 759847 724274 747171 739690 745055 736957 746638 746753 757641 765305 770061 702454 702893 714162 721754 774766 788461 789992 795573 804224 382254 411817 7169 390945 396849 20715 232995 233112 358792 395720 382549 409886 444834 455910 504414 532982 519341 502034 504354 538660 484125 486314 550647 665116 665466 667647 668176 665108 676467 549244 589597 624854 748389 467248 477455 443963 411946 454267 520300 492392 515171 485691 490192 522056 385794 395271 310683 3616 387496 397223 397362 405491 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.85%) |
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 3616 7169 20715 232995 233112 310683 358792 382254 382549 385794 387496 390945 395271 395720 396849 397223 397362 405491 409886 411817 411946 443963 444834 454267 455910 467248 477455 484125 485691 486314 490192 492392 502034 504354 504414 515171 519341 520300 522056 525528 532982 533022 536754 537157 537581 538660 547340 547568 549244 550647 561777 563129 565648 566681 589597 594067 603374 619430 624854 644699 644705 665108 665116 665466 665881 667244 667647 668176 672796 676467 698958 702454 702893 714162 716215 716753 721475 721570 721754 724274 724276 736957 739478 739690 741093 745055 746638 746753 747171 748389 750869 757641 759847 765305 770061 772694 774763 774766 774767 781734 788232 788276 788461 788787 788873 789294 789535 789969 789992 793529 795573 795577 798916 801237 802409 804224 804944 808012 808866 828373 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old boobs"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old boobs"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old boobs"
]
|
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.