Query Metrics
7
Database Queries
7
Different statements
158.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.55 ms (86.59%) |
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 386558 397203 397869 409340 445424 524338 535985 536298 538684 539458 545358 546550 548483 550682 555153 557446 573168 576621 582203 583364 592470 601026 603343 604840 604877 606121 607213 607628 609977 614182 618341 621168 625679 629971 630125 633456 644187 648446 651117 672723 678761 678780 708614 714393 715416 717621 721178 722678 725562 726210 730485 735292 735919 736092 740457 740573 741610 742427 744173 744980 745058 750885 751370 751485 751494 752190 753019 753074 754744 755183 755193 755351 756045 757216 760590 763393 768598 770020 770100 770231 771950 771979 774078 774728 774739 774742 776542 777522 781799 781948 781956 782479 782489 782496 785831 785882 787352 790764 795527 797369 802573 802739 803749 805724 806984 808711 808862 811104 811109 812226 812492 812733 813597 819222 819232 819243 819261 823406 824563 826142 ] |
||||||||||||||||||||||||||||||
|
12.03 ms (7.57%) |
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 805724 735292 770020 726210 755183 768598 750885 751485 754744 774078 721178 803749 386558 409340 813597 555153 756045 397869 826142 819222 819243 583364 651117 601026 606121 604877 609977 629971 625679 782479 785831 802573 777522 811104 744173 752190 753019 785882 790764 751494 771950 744980 755351 740573 751370 771979 725562 633456 812226 539458 557446 715416 722678 672723 592470 774742 776542 795527 812733 745058 770100 717621 781956 782496 787352 397203 708614 678780 582203 603343 604840 618341 802739 811109 763393 770231 740457 757216 760590 808711 808862 812492 524338 819232 445424 819261 823406 824563 535985 536298 538684 545358 548483 550682 546550 573168 576621 714393 648446 678761 607628 644187 607213 614182 621168 774728 781799 806984 781948 741610 782489 797369 742427 730485 735919 755193 736092 753074 630125 774739 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.77%) |
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 386558 397203 397869 409340 445424 524338 535985 536298 538684 539458 545358 546550 548483 550682 555153 557446 573168 576621 582203 583364 592470 601026 603343 604840 604877 606121 607213 607628 609977 614182 618341 621168 625679 629971 630125 633456 644187 648446 651117 672723 678761 678780 708614 714393 715416 717621 721178 722678 725562 726210 730485 735292 735919 736092 740457 740573 741610 742427 744173 744980 745058 750885 751370 751485 751494 752190 753019 753074 754744 755183 755193 755351 756045 757216 760590 763393 768598 770020 770100 770231 771950 771979 774078 774728 774739 774742 776542 777522 781799 781948 781956 782479 782489 782496 785831 785882 787352 790764 795527 797369 802573 802739 803749 805724 806984 808711 808862 811104 811109 812226 812492 812733 813597 819222 819232 819243 819261 823406 824563 826142 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom solo tits"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom соло сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom соло сиськ"
]
|
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.