Query Metrics
7
Database Queries
7
Different statements
162.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.69 ms (84.73%) |
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 33917 78786 96800 335642 348918 387265 387693 389178 391861 396048 401644 408432 413283 415588 419273 439439 447692 448266 456863 459855 462499 466882 471898 474845 489796 491437 494700 496973 499533 500936 502343 502560 502736 504038 505739 508579 509355 512542 514187 519343 521462 521987 524204 532118 532298 537192 539347 543889 545288 545500 546082 555855 557000 558109 560241 562970 564485 565114 569225 569619 571766 571980 573222 573983 579261 580494 580847 581175 585337 585680 595086 598772 600937 601503 601691 602490 603029 604837 605073 606796 621109 622452 622722 623360 624008 624023 626973 627252 628585 629338 645364 648347 652671 662399 671584 672324 675587 683541 692131 703626 710769 738475 741879 742751 747069 750430 756496 757196 779653 781040 781060 783353 787819 796999 800875 801064 807010 811653 817992 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (9.12%) |
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 569225 489796 595086 505739 562970 543889 692131 710769 703626 628585 779653 781060 811653 738475 756496 605073 413283 448266 521462 750430 408432 491437 499533 580847 560241 539347 683541 623360 602490 581175 545288 571980 648347 545500 624008 389178 569619 817992 514187 652671 600937 621109 781040 741879 474845 494700 546082 502560 519343 532298 565114 801064 335642 419273 466882 508579 573983 604837 626973 787819 798952 800875 796999 807010 96800 502343 500936 558109 573222 662399 557000 585680 598772 624023 783353 348918 396048 509355 456863 645364 742751 78786 537192 524204 571766 502736 391861 387693 532118 627252 387265 504038 671584 579261 622722 622452 415588 555855 580494 675587 629338 757196 747069 512542 33917 401644 439439 447692 459855 564485 521987 496973 585337 672324 601691 601503 462499 603029 471898 606796 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.71%) |
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 33917 78786 96800 335642 348918 387265 387693 389178 391861 396048 401644 408432 413283 415588 419273 439439 447692 448266 456863 459855 462499 466882 471898 474845 489796 491437 494700 496973 499533 500936 502343 502560 502736 504038 505739 508579 509355 512542 514187 519343 521462 521987 524204 532118 532298 537192 539347 543889 545288 545500 546082 555855 557000 558109 560241 562970 564485 565114 569225 569619 571766 571980 573222 573983 579261 580494 580847 581175 585337 585680 595086 598772 600937 601503 601691 602490 603029 604837 605073 606796 621109 622452 622722 623360 624008 624023 626973 627252 628585 629338 645364 648347 652671 662399 671584 672324 675587 683541 692131 703626 710769 738475 741879 742751 747069 750430 756496 757196 779653 781040 781060 783353 787819 796999 800875 801064 807010 811653 817992 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на сиськ"
]
|
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.