Query Metrics
7
Database Queries
7
Different statements
159.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.59 ms (83.74%) |
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 391945 410734 416501 416522 416561 416571 416600 418111 418121 418133 422273 426290 427971 428700 429905 432274 433002 434286 434309 438013 439052 439156 439924 441442 441454 442524 443236 443255 445661 446063 451316 453332 453582 456208 456478 457821 459237 461704 463493 464262 464804 465548 467936 469027 473745 478423 480857 483210 483564 483711 483715 492165 504810 511673 511973 512931 513016 513992 520786 520789 524254 526556 526570 528143 528474 529338 532727 534553 541212 542266 549739 552991 555582 555847 556680 563692 576920 584228 585454 586838 590802 592402 598668 600642 601333 602165 602409 603947 604286 604357 604790 605015 606816 609841 609885 612699 613851 614966 624755 625864 627361 634108 639208 642022 646872 666355 675110 680267 696598 708517 709693 752704 758779 760649 779840 806668 814971 824791 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (10.34%) |
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 680267 675110 590802 600642 602409 613851 625864 604357 627361 524254 708517 612699 666355 603947 604790 639208 709693 806668 418111 441454 426290 433002 439156 442524 410734 534553 520789 513992 542266 555582 541212 549739 555847 556680 584228 586838 598668 605015 609841 609885 592402 614966 634108 601333 606816 604286 624755 758779 752704 602165 422273 480857 416501 416600 418133 429905 434309 439924 434286 528143 483715 483210 529338 441442 416561 428700 432274 443236 416522 439052 416571 418121 427971 824791 814971 446063 453582 467936 473745 451316 457821 464804 483564 453332 469027 504810 511673 513372 465548 478423 492165 563692 576920 646872 696598 585454 779840 760649 461704 464262 391945 456208 456478 456520 511973 512931 526556 483711 520786 526570 513016 528474 438013 642022 463493 532727 552991 443255 459237 445661 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.50%) |
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 391945 410734 416501 416522 416561 416571 416600 418111 418121 418133 422273 426290 427971 428700 429905 432274 433002 434286 434309 438013 439052 439156 439924 441442 441454 442524 443236 443255 445661 446063 451316 453332 453582 456208 456478 457821 459237 461704 463493 464262 464804 465548 467936 469027 473745 478423 480857 483210 483564 483711 483715 492165 504810 511673 511973 512931 513016 513992 520786 520789 524254 526556 526570 528143 528474 529338 532727 534553 541212 542266 549739 552991 555582 555847 556680 563692 576920 584228 585454 586838 590802 592402 598668 600642 601333 602165 602409 603947 604286 604357 604790 605015 606816 609841 609885 612699 613851 614966 624755 625864 627361 634108 639208 642022 646872 666355 675110 680267 696598 708517 709693 752704 758779 760649 779840 806668 814971 824791 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade asshole"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск asshole"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск asshole"
]
|
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.