Query Metrics
7
Database Queries
7
Different statements
169.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.63 ms (83.56%) |
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 386357 396449 397296 423840 425345 426796 436418 444959 446126 446902 447312 447551 455186 459225 461013 467833 472765 475499 476475 480089 480885 483613 490893 492811 492842 493072 495552 497186 501836 502447 504208 511597 511681 512826 513587 513612 518602 521918 521944 521982 522948 548058 558999 560614 560673 564724 569874 570244 571541 573617 584842 585783 590277 590337 591157 597498 600063 609900 620631 620995 648570 654451 672891 674617 677350 679491 680650 681371 691327 695851 697126 697474 697485 697645 698136 699237 707517 713580 719156 721202 721341 722629 723264 723504 742298 742364 743142 743916 747550 749237 751118 755483 757564 758984 761125 763729 765822 766419 771895 779914 781250 788322 788430 794019 795858 795979 801825 802369 804825 806635 809656 810187 810482 810527 810878 812912 813584 814295 818582 825644 ] |
||||||||||||||||||||||||||||||
|
18.21 ms (10.74%) |
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 609900 620631 810482 810527 749237 806635 397296 476475 447312 502447 492842 521918 620995 597498 446902 436418 504208 825644 814295 560673 672891 697126 697645 707517 713580 722629 723264 699237 680650 585783 590337 600063 591157 781250 794019 795858 795979 810878 758984 804825 810187 812912 757564 742364 742298 763729 765822 766419 771895 721341 723504 779914 788322 802369 809656 467833 455186 511681 495552 564724 558999 560614 426796 446126 459225 475499 480885 444959 386357 423840 425345 461013 480089 447551 472765 518602 521944 521982 497186 511597 513612 492811 493072 483613 490893 501836 512826 522948 813584 818582 513587 548058 584842 569874 570244 571541 573617 681371 697485 648570 654451 679491 695851 697474 674617 677350 691327 719156 721202 590277 788430 801825 743142 747550 743916 751118 755483 761125 698136 396449 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.66%) |
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 386357 396449 397296 423840 425345 426796 436418 444959 446126 446902 447312 447551 455186 459225 461013 467833 472765 475499 476475 480089 480885 483613 490893 492811 492842 493072 495552 497186 501836 502447 504208 511597 511681 512826 513587 513612 518602 521918 521944 521982 522948 548058 558999 560614 560673 564724 569874 570244 571541 573617 584842 585783 590277 590337 591157 597498 600063 609900 620631 620995 648570 654451 672891 674617 677350 679491 680650 681371 691327 695851 697126 697474 697485 697645 698136 699237 707517 713580 719156 721202 721341 722629 723264 723504 742298 742364 743142 743916 747550 749237 751118 755483 757564 758984 761125 763729 765822 766419 771895 779914 781250 788322 788430 794019 795858 795979 801825 802369 804825 806635 809656 810187 810482 810527 810878 812912 813584 814295 818582 825644 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian hot girls"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск hot девушк"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск hot девушк"
]
|
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.