Query Metrics
7
Database Queries
7
Different statements
200.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.72 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 38261 80916 187349 233186 381979 384480 384988 390815 391884 393435 396322 397907 422197 432871 437361 439721 440836 440951 442257 445063 448183 452358 453273 453706 455122 455989 456787 459379 460974 462471 468883 470652 471645 474441 479094 480522 482618 482843 482881 483482 486357 499694 501378 501618 504458 507266 509287 510771 510776 512145 516473 516808 517245 517374 517589 521867 523777 527893 531955 537848 540207 544452 544495 545922 555600 562540 568337 590961 603678 604874 610094 617019 658440 676408 695759 705549 709396 710249 714424 725511 730991 731915 734005 738334 739555 739686 739762 744394 744439 744764 744791 746114 746453 746600 746603 753511 755056 755065 756920 758110 758149 758274 760775 769566 772525 774964 775950 784946 787571 795327 800432 800704 803062 805644 806241 808866 808870 809791 811314 817004 ] |
||||||||||||||||||||||||||||||
|
12.88 ms (6.43%) |
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 512145 486357 603678 187349 439721 455122 516808 517374 800432 808866 393435 384480 445063 455989 482843 456787 517589 537848 474441 482618 544452 705549 775950 390815 397907 462471 479094 233186 422197 468883 504458 510771 523777 507266 509287 510776 516473 604874 744764 499694 562540 545922 734005 772525 795327 730991 746600 753511 755056 739555 746453 755065 769566 758149 817004 540207 590961 803062 808870 396322 744791 760775 384988 381979 432871 453273 501618 531955 470652 568337 658440 676408 710249 714424 695759 610094 784946 806241 738334 746114 756920 787571 800704 805644 811314 758110 744394 758274 725511 731915 739686 739762 744439 746603 709396 774964 809791 453706 80916 460974 527893 517245 544495 555600 617019 501378 521867 483482 442257 391884 38261 440836 437361 440951 448183 482881 452358 459379 471645 480522 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (2.14%) |
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 38261 80916 187349 233186 381979 384480 384988 390815 391884 393435 396322 397907 422197 432871 437361 439721 440836 440951 442257 445063 448183 452358 453273 453706 455122 455989 456787 459379 460974 462471 468883 470652 471645 474441 479094 480522 482618 482843 482881 483482 486357 499694 501378 501618 504458 507266 509287 510771 510776 512145 516473 516808 517245 517374 517589 521867 523777 527893 531955 537848 540207 544452 544495 545922 555600 562540 568337 590961 603678 604874 610094 617019 658440 676408 695759 705549 709396 710249 714424 725511 730991 731915 734005 738334 739555 739686 739762 744394 744439 744764 744791 746114 746453 746600 746603 753511 755056 755065 756920 758110 758149 758274 760775 769566 772525 774964 775950 784946 787571 795327 800432 800704 803062 805644 806241 808866 808870 809791 811314 817004 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женщин дрочк"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женщины дрочка"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.87%) |
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.