Query Metrics
7
Database Queries
7
Different statements
216.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.55 ms (88.22%) |
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 61243 182232 384117 391926 394630 400480 414067 416644 416689 416700 416707 424195 424614 428174 429902 436639 439187 439292 441094 446949 449108 452567 452814 452837 452878 456190 457541 458867 460351 463751 466475 468269 468943 469092 469250 470471 471654 471663 477081 477417 477435 477759 480450 481418 484953 493730 494156 495507 497906 499288 502800 505387 505798 506119 513672 521559 523761 525603 529969 534586 541326 545390 547452 547480 550107 554831 556885 559355 569594 573928 576943 580588 583355 584021 585964 586914 591003 592187 600087 604824 605199 607549 623187 626597 660411 660419 662850 664192 669030 672927 677147 680928 707840 713885 714247 725629 725631 735134 745136 749234 752145 752609 752632 758792 766825 770250 770260 770276 785591 786881 792088 793262 795403 796910 802029 805645 806327 811808 814394 ] |
||||||||||||||||||||||||||||||
|
15.65 ms (7.24%) |
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 391926 458867 460351 452567 394630 495507 523761 484953 449108 550107 554831 707840 793262 805645 428174 457541 545390 556885 384117 182232 61243 752145 441094 400480 416707 424614 439292 416689 416700 414067 439187 814394 477081 468269 469092 452814 452837 452878 463751 469250 470471 477417 534586 505387 525603 494156 521559 529969 477435 564310 576943 541326 569594 580588 547452 547480 559355 573928 583355 669030 672927 680928 660419 677147 713885 660411 662850 664192 584021 586914 591003 604824 592187 607549 585964 623187 600087 792088 795403 806327 735134 785591 811808 752632 758792 766825 770250 725631 749234 752609 770260 725629 745136 770276 605199 714247 786881 802029 424195 429902 456190 466475 468943 416644 446949 471654 471663 480450 436639 481418 502800 493730 499288 513672 497906 505798 796910 477759 626597 506119 ] |
||||||||||||||||||||||||||||||
|
3.31 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 61243 182232 384117 391926 394630 400480 414067 416644 416689 416700 416707 424195 424614 428174 429902 436639 439187 439292 441094 446949 449108 452567 452814 452837 452878 456190 457541 458867 460351 463751 466475 468269 468943 469092 469250 470471 471654 471663 477081 477417 477435 477759 480450 481418 484953 493730 494156 495507 497906 499288 502800 505387 505798 506119 513672 521559 523761 525603 529969 534586 541326 545390 547452 547480 550107 554831 556885 559355 569594 573928 576943 580588 583355 584021 585964 586914 591003 592187 600087 604824 605199 607549 623187 626597 660411 660419 662850 664192 669030 672927 677147 680928 707840 713885 714247 725629 725631 735134 745136 749234 752145 752609 752632 758792 766825 770250 770260 770276 785591 786881 792088 793262 795403 796910 802029 805645 806327 811808 814394 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал соло toys"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal solo toys"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал соло toys"
]
|
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.