Query Metrics
7
Database Queries
7
Different statements
146.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.41 ms (82.82%) |
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 10006 131772 182686 391455 392729 392814 393713 398237 400723 401559 402067 408776 417461 418868 427076 427449 439488 444128 446456 453603 453624 455708 459811 462288 463093 463312 464284 469844 469898 470785 473252 490791 495159 496049 504764 507154 507815 509077 509451 510586 512047 516695 519321 524023 527116 541250 542942 548670 552859 553197 553608 560579 566303 579488 583210 591737 601853 604425 605841 605856 606571 607772 615622 617121 622037 644708 648880 675424 686082 694119 694154 695831 700945 701508 702320 710001 714357 714477 716392 716396 721579 722080 733068 733181 736980 738623 740084 743009 744328 745386 747954 748662 753548 754967 761862 762559 771874 775284 787616 789870 789874 790342 794906 794974 798171 798992 800227 800305 800316 800535 801644 803261 807301 808192 811678 811866 816764 817553 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (10.61%) |
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 722080 798171 400723 453603 469898 490791 541250 496049 392814 459811 463093 509077 579488 714477 716392 552859 604425 794974 803261 733181 736980 740084 800305 754967 761862 762559 747954 622037 702320 716396 775284 470785 469844 473252 453624 408776 606571 509451 777104 648880 427449 816764 510586 542942 675424 710001 714357 700945 548670 617121 644708 789870 738623 743009 753548 745386 771874 800227 801644 524023 398237 519321 464284 566303 789874 798992 462288 463312 507815 516695 182686 811678 826047 744328 800316 446456 507154 553197 605841 817553 790342 601853 10006 391455 512047 560579 694119 811866 427076 455708 392729 527116 695831 694154 553608 787616 794906 402067 401559 418868 439488 393713 131772 504764 701508 721579 686082 591737 607772 615622 605856 800535 733068 748662 807301 808192 417461 444128 495159 583210 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.85%) |
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 10006 131772 182686 391455 392729 392814 393713 398237 400723 401559 402067 408776 417461 418868 427076 427449 439488 444128 446456 453603 453624 455708 459811 462288 463093 463312 464284 469844 469898 470785 473252 490791 495159 496049 504764 507154 507815 509077 509451 510586 512047 516695 519321 524023 527116 541250 542942 548670 552859 553197 553608 560579 566303 579488 583210 591737 601853 604425 605841 605856 606571 607772 615622 617121 622037 644708 648880 675424 686082 694119 694154 695831 700945 701508 702320 710001 714357 714477 716392 716396 721579 722080 733068 733181 736980 738623 740084 743009 744328 745386 747954 748662 753548 754967 761862 762559 771874 775284 787616 789870 789874 790342 794906 794974 798171 798992 800227 800305 800316 800535 801644 803261 807301 808192 811678 811866 816764 817553 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер young секс"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam young sex"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер young секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.00%) |
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.