Query Metrics
7
Database Queries
7
Different statements
189.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.06 ms (83.06%) |
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 391562 396740 415818 418122 418145 420108 420182 425037 427011 427027 427166 431341 434322 435550 438748 439543 440453 440816 440820 447748 447810 452977 461605 466294 467868 467872 467878 467888 468142 468363 469194 470458 476797 479477 483486 493194 494202 494231 502826 502868 503477 504639 506253 507430 507817 512830 513568 514042 514399 516123 519501 524237 530011 531177 531524 532785 533685 533697 535597 535620 544404 544788 546465 547733 552585 555133 562384 562491 563576 566346 566766 569927 578917 598696 598728 600004 600014 601655 606571 608174 609085 614867 619979 621756 624909 631937 636295 650155 653487 669912 682884 683259 683261 718698 735958 736376 738877 740012 742657 750701 765222 765495 766283 786598 787468 789188 793926 801610 802263 803827 803880 809815 810463 811296 821851 825722 826233 827335 828021 828627 ] |
||||||||||||||||||||||||||||||
|
20.68 ms (10.93%) |
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 502826 512830 483486 469194 506253 391562 415818 735958 766283 396740 467868 427027 447748 470458 461605 467888 514042 503477 821851 479477 468142 547733 552585 566346 569927 653487 718698 546465 555133 631937 624909 811296 801610 467872 440453 466294 440820 420182 440816 418145 438748 514399 507817 513568 493194 494202 619979 742657 427011 793926 669912 608174 789188 803880 827335 418122 434322 519501 598696 600004 425037 435550 502868 531524 532785 531177 533697 535597 535620 563576 683259 750701 452977 427166 507430 516123 825722 828021 562384 828627 468363 765495 530011 544788 562491 683261 606571 614867 601655 621756 467878 439543 803827 786598 738877 447810 765222 494231 636295 420108 431341 598728 524237 826233 682884 802263 809815 740012 787468 736376 810463 650155 600014 533685 609085 476797 504639 566766 544404 578917 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.53%) |
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 391562 396740 415818 418122 418145 420108 420182 425037 427011 427027 427166 431341 434322 435550 438748 439543 440453 440816 440820 447748 447810 452977 461605 466294 467868 467872 467878 467888 468142 468363 469194 470458 476797 479477 483486 493194 494202 494231 502826 502868 503477 504639 506253 507430 507817 512830 513568 514042 514399 516123 519501 524237 530011 531177 531524 532785 533685 533697 535597 535620 544404 544788 546465 547733 552585 555133 562384 562491 563576 566346 566766 569927 578917 598696 598728 600004 600014 601655 606571 608174 609085 614867 619979 621756 624909 631937 636295 650155 653487 669912 682884 683259 683261 718698 735958 736376 738877 740012 742657 750701 765222 765495 766283 786598 787468 789188 793926 801610 802263 803827 803880 809815 810463 811296 821851 825722 826233 827335 828021 828627 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt russian"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм русск"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.97%) |
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.