Query Metrics
7
Database Queries
7
Different statements
165.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.54 ms (85.04%) |
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 6699 21575 29367 31015 37183 82091 100665 146944 181420 187595 188369 191495 193928 334847 338022 358481 359102 365885 382129 384368 384984 385381 385758 386544 386686 386894 387175 388780 388869 388894 388979 389062 389943 390303 390403 390601 390761 391579 392393 392602 392672 392674 394197 395933 396110 396341 396806 401520 402926 407653 415507 418880 418994 428567 444001 446900 454130 454963 456405 460177 460358 461147 462255 466061 467218 490106 494608 494645 494912 495448 502894 504729 504745 509631 509729 509794 511205 513532 514449 516253 517026 517584 521473 522409 522601 522862 523680 526407 527149 528534 533997 540512 544503 546941 563503 563645 581041 589673 591644 594912 598586 611321 645393 671659 686073 687116 687241 695175 701626 764206 775379 775385 781072 794230 807517 807546 811486 817376 821376 823501 ] |
||||||||||||||||||||||||||||||
|
14.99 ms (9.07%) |
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 6699 82091 388979 389943 388780 390601 396110 418880 407653 418994 428567 817376 821376 823501 454130 461147 466061 462255 467218 460177 494912 509794 516253 517584 527149 504745 517026 522862 533997 504729 509729 522601 523680 526407 509631 528534 540512 563503 581041 544503 563645 686073 701626 687116 695175 645393 671659 687241 546941 589673 611321 594912 598586 591644 775379 807546 811486 764206 775385 781072 794230 807517 29367 100665 146944 187595 193928 386894 390403 390761 394197 395933 396341 415507 384984 385381 386544 402926 454963 21575 181420 188369 191495 334847 358481 365885 390303 391579 392602 392672 456405 338022 359102 386686 387175 388869 392393 392674 396806 444001 460358 513532 521473 511205 494608 522409 490106 495448 514449 385758 384368 37183 401520 494645 502894 388894 446900 382129 31015 389062 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.46%) |
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 6699 21575 29367 31015 37183 82091 100665 146944 181420 187595 188369 191495 193928 334847 338022 358481 359102 365885 382129 384368 384984 385381 385758 386544 386686 386894 387175 388780 388869 388894 388979 389062 389943 390303 390403 390601 390761 391579 392393 392602 392672 392674 394197 395933 396110 396341 396806 401520 402926 407653 415507 418880 418994 428567 444001 446900 454130 454963 456405 460177 460358 461147 462255 466061 467218 490106 494608 494645 494912 495448 502894 504729 504745 509631 509729 509794 511205 513532 514449 516253 517026 517584 521473 522409 522601 522862 523680 526407 527149 528534 533997 540512 544503 546941 563503 563645 581041 589673 591644 594912 598586 611321 645393 671659 686073 687116 687241 695175 701626 764206 775379 775385 781072 794230 807517 807546 811486 817376 821376 823501 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy рак"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy doggy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy рак"
]
|
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.