Query Metrics
7
Database Queries
7
Different statements
198.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.25 ms (86.16%) |
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 405074 432250 437176 443080 451224 451779 456737 462144 462904 464372 467565 469586 471886 475630 480069 481766 484695 485002 486336 487472 488219 488823 490087 493310 497166 500482 500498 500505 501841 508510 510157 512137 512478 514659 514693 517372 517395 517450 517455 517596 517602 518406 519851 525137 542056 545009 548751 551532 556778 558338 558788 561131 568316 574566 576113 583981 584262 586786 587598 587864 588016 588038 588039 591908 594768 598207 599272 599863 601478 605456 605521 605553 606541 606567 607146 611902 615394 618561 623149 625086 626124 627380 632442 634856 636567 637731 648672 650983 654617 654840 655410 655647 656465 656686 656710 656782 656789 657033 657051 657067 657287 657670 657692 658269 659703 659714 659715 702369 731397 732633 732635 745526 760534 769395 773971 778701 779627 797138 803873 809879 ] |
||||||||||||||||||||||||||||||
|
18.14 ms (9.13%) |
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 568316 598207 443080 493310 514693 519851 551532 487472 485002 514659 574566 501841 517602 659714 497166 512478 525137 512137 451779 469586 517372 594768 607146 611902 615394 591908 481766 432250 659703 586786 542056 548751 601478 488219 518406 508510 471886 517596 587598 606541 510157 500482 484695 545009 561131 464372 637731 517395 480069 606567 605553 657051 583981 558788 656686 657287 517455 462904 517450 656789 659715 599272 490087 558338 654840 654617 405074 656465 605456 599863 618561 658269 634856 657670 656782 657033 657692 655647 656710 556778 627380 655410 657067 587864 584262 588039 486336 488823 576113 605521 475630 779627 462144 623149 456737 625086 773971 636567 760534 732635 626124 437176 650983 588016 809879 769395 731397 500498 732633 451224 648672 797138 632442 588038 702369 500505 467565 803873 778701 745526 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.26%) |
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 405074 432250 437176 443080 451224 451779 456737 462144 462904 464372 467565 469586 471886 475630 480069 481766 484695 485002 486336 487472 488219 488823 490087 493310 497166 500482 500498 500505 501841 508510 510157 512137 512478 514659 514693 517372 517395 517450 517455 517596 517602 518406 519851 525137 542056 545009 548751 551532 556778 558338 558788 561131 568316 574566 576113 583981 584262 586786 587598 587864 588016 588038 588039 591908 594768 598207 599272 599863 601478 605456 605521 605553 606541 606567 607146 611902 615394 618561 623149 625086 626124 627380 632442 634856 636567 637731 648672 650983 654617 654840 655410 655647 656465 656686 656710 656782 656789 657033 657051 657067 657287 657670 657692 658269 659703 659714 659715 702369 731397 732633 732635 745526 760534 769395 773971 778701 779627 797138 803873 809879 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold handjob"
]
|
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.