Query Metrics
7
Database Queries
7
Different statements
187.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.06 ms (85.39%) |
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 405705 425113 439674 441326 444338 454095 456268 467970 470355 474895 475499 475706 476006 490219 501120 502499 505531 507284 508204 508542 508916 514402 516922 517006 517634 519455 521339 521836 523346 525554 525559 527260 527941 528327 528329 529131 529331 529377 534395 535531 535667 536406 537971 541303 541714 541732 547584 550339 552628 555149 555798 559542 564390 569247 569565 572684 572961 575928 577087 579471 579859 582088 584025 584716 585965 588818 589436 592402 592955 593577 593604 594289 600248 600762 604254 604330 604671 605748 619288 621392 623732 624127 624160 624578 626200 631549 632546 648040 668972 675179 676655 680441 680780 684465 686113 691166 707408 707506 711554 730599 733239 742316 745487 745679 749936 756321 756703 771333 787055 790575 791209 791758 793818 797461 803721 805773 807852 810052 814263 ] |
||||||||||||||||||||||||||||||
|
15.77 ms (8.41%) |
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 529331 684465 691166 582088 541714 579471 444338 686113 814263 771333 592955 680780 631549 803721 541303 467970 505531 584025 523346 604254 675179 517006 517634 575928 572684 585965 508916 790575 569247 536406 600762 454095 756321 405705 668972 577087 564390 632546 742316 707408 475499 791758 793818 535667 579859 624160 547584 807852 521339 594289 745679 783559 797461 529131 680441 604330 592402 626200 541732 624578 470355 508542 529377 791209 600248 552628 569565 550339 525559 537971 521836 621392 508204 525554 619288 535531 425113 475706 623732 593577 589436 588818 605748 745487 749936 527260 604671 474895 456268 439674 707506 584716 514402 441326 534395 476006 516922 805773 676655 572961 730599 756703 810052 559542 502499 733239 593604 490219 501120 624127 787055 507284 528327 555149 528329 527941 519455 648040 711554 555798 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.81%) |
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 405705 425113 439674 441326 444338 454095 456268 467970 470355 474895 475499 475706 476006 490219 501120 502499 505531 507284 508204 508542 508916 514402 516922 517006 517634 519455 521339 521836 523346 525554 525559 527260 527941 528327 528329 529131 529331 529377 534395 535531 535667 536406 537971 541303 541714 541732 547584 550339 552628 555149 555798 559542 564390 569247 569565 572684 572961 575928 577087 579471 579859 582088 584025 584716 585965 588818 589436 592402 592955 593577 593604 594289 600248 600762 604254 604330 604671 605748 619288 621392 623732 624127 624160 624578 626200 631549 632546 648040 668972 675179 676655 680441 680780 684465 686113 691166 707408 707506 711554 730599 733239 742316 745487 745679 749936 756321 756703 771333 787055 790575 791209 791758 793818 797461 803721 805773 807852 810052 814263 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð║ð¥ð¢Ðçð©ÐéÐî ð▓ ð░ð¢ð░ð╗ Ðçð░ÐüÐéð¢ð¥ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм анал любительск"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.94%) |
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.