Query Metrics
7
Database Queries
7
Different statements
196.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.16 ms (87.77%) |
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 10065 44968 114730 187567 191393 260962 381875 382437 386658 390144 396692 396951 397373 400896 402657 403283 408692 410397 415105 415573 421204 435341 442238 464209 475078 514801 519219 524969 548522 572535 581483 582407 583873 587263 587505 590904 598811 606496 606575 607202 611317 624225 644388 649902 663884 665296 666149 670276 670769 675971 675986 676402 676808 687511 690093 697278 697414 699686 699723 703207 704268 710407 711275 712466 715550 721842 722489 722822 722895 723507 724411 724641 726654 727831 732742 732793 737893 742088 745062 746574 746876 748185 748715 760812 761073 770300 770833 770836 770856 770878 770895 771971 775137 775970 782002 789694 794795 797870 798641 800300 801484 802113 802117 804773 805779 809440 809636 810606 813228 814242 814349 814396 814432 815052 815087 815110 815124 816085 820881 826280 ] |
||||||||||||||||||||||||||||||
|
15.16 ms (7.73%) |
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 801484 260962 415105 403283 670769 587505 809636 582407 800300 802113 770878 770856 675986 710407 606496 590904 746876 770300 794795 815124 649902 666149 611317 187567 583873 675971 676402 44968 724411 748715 624225 396951 415573 814432 644388 742088 770895 390144 699686 724641 587263 816085 699723 746574 697278 704268 607202 722489 606575 732742 397373 381875 826280 727831 732793 810606 581483 524969 722822 408692 519219 690093 572535 814396 814242 775970 805779 761073 514801 410397 814349 802117 760812 789694 771971 726654 421204 687511 782002 813228 798641 745062 435341 442238 676808 748185 464209 809440 386658 548522 804773 475078 114730 820881 598811 737893 715550 402657 396692 721842 711275 775137 382437 400896 191393 815087 815052 815110 723507 665296 670276 722895 797870 770836 770833 703207 10065 712466 663884 697414 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.32%) |
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 10065 44968 114730 187567 191393 260962 381875 382437 386658 390144 396692 396951 397373 400896 402657 403283 408692 410397 415105 415573 421204 435341 442238 464209 475078 514801 519219 524969 548522 572535 581483 582407 583873 587263 587505 590904 598811 606496 606575 607202 611317 624225 644388 649902 663884 665296 666149 670276 670769 675971 675986 676402 676808 687511 690093 697278 697414 699686 699723 703207 704268 710407 711275 712466 715550 721842 722489 722822 722895 723507 724411 724641 726654 727831 732742 732793 737893 742088 745062 746574 746876 748185 748715 760812 761073 770300 770833 770836 770856 770878 770895 771971 775137 775970 782002 789694 794795 797870 798641 800300 801484 802113 802117 804773 805779 809440 809636 810606 813228 814242 814349 814396 814432 815052 815087 815110 815124 816085 820881 826280 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ffm stockings longtest"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро чулк нижн бел longtest"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жмж секс втро чулк нижн бел longtest"
]
|
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.