Query Metrics
7
Database Queries
7
Different statements
169.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.28 ms (84.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 391519 420478 422345 424417 424429 424662 428143 443334 443697 443727 443738 443762 443786 454236 454260 454287 460571 460768 460921 462332 462489 464296 465331 465342 465365 465372 465382 466149 466248 466279 466965 467435 467519 468858 470208 470262 470289 470304 470560 471054 474680 474780 477730 477947 477957 479092 479101 479106 479128 479148 482521 484016 484394 484429 484631 484683 484735 485970 486341 486821 488527 489105 491103 491105 493195 497210 505855 508800 509241 513376 516478 518615 519751 520154 520743 523165 524944 528461 533052 535607 543708 545875 546622 547920 549764 549772 549799 552324 556490 558011 559064 559066 560380 560430 562963 563038 563169 566353 582321 590303 590540 614522 614628 617638 622387 668829 725204 735881 738363 741752 741756 742405 752170 755875 766315 781667 801496 805666 811144 826581 ] |
||||||||||||||||||||||||||||||
|
15.66 ms (9.25%) |
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 484735 520743 826581 535607 533052 545875 668829 566353 801496 781667 811144 725204 766315 738363 755875 735881 549799 443334 474680 477730 486341 560430 742405 424417 470560 505855 543708 559064 560380 547920 617638 443727 462489 466149 477957 479128 391519 428143 454260 465372 470304 443697 470262 443762 466279 516478 486821 497210 523165 524944 484631 520154 493195 508800 509241 488527 805666 491105 518615 491103 484016 528461 464296 471054 482521 558011 546622 552324 556490 563038 582321 559066 563169 549764 549772 562963 622387 590303 590540 614628 741752 741756 752170 614522 420478 422345 424429 454287 465382 477947 443786 454236 460571 460921 465342 465365 466248 467519 468858 470289 479101 479148 462332 467435 470208 474780 479092 479106 424662 443738 460768 465331 466965 484394 484429 485970 489105 513376 519751 484683 ] |
||||||||||||||||||||||||||||||
|
3.89 ms (2.30%) |
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 391519 420478 422345 424417 424429 424662 428143 443334 443697 443727 443738 443762 443786 454236 454260 454287 460571 460768 460921 462332 462489 464296 465331 465342 465365 465372 465382 466149 466248 466279 466965 467435 467519 468858 470208 470262 470289 470304 470560 471054 474680 474780 477730 477947 477957 479092 479101 479106 479128 479148 482521 484016 484394 484429 484631 484683 484735 485970 486341 486821 488527 489105 491103 491105 493195 497210 505855 508800 509241 513376 516478 518615 519751 520154 520743 523165 524944 528461 533052 535607 543708 545875 546622 547920 549764 549772 549799 552324 556490 558011 559064 559066 560380 560430 562963 563038 563169 566353 582321 590303 590540 614522 614628 617638 622387 668829 725204 735881 738363 741752 741756 742405 752170 755875 766315 781667 801496 805666 811144 826581 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian saggy mature"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск saggy mature"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск saggy mature"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.