Query Metrics
7
Database Queries
7
Different statements
455.76 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.54 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.83 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation solo orgasm"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.22 ms |
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 706442 683257 664181 666981 627414 631246 790730 760093 794212 804507 487254 541149 638497 607375 402083 403850 813643 818722 824554 826832 827439 827394 819891 820020 813928 818690 820088 827970 539949 496876 498554 544033 551600 577023 581930 556023 576471 541043 550968 552713 554693 561052 665076 671559 693267 703022 712962 713750 646074 647111 669320 669858 692914 710092 718036 648931 659429 676555 689902 694637 695549 719422 577034 583727 607365 636969 589545 599283 602387 622303 598943 623056 629643 642144 592175 596039 774811 777715 778155 782048 782865 784414 784476 785113 785366 795156 798287 806821 812668 781245 782908 783006 784522 785367 785651 788337 790463 803396 805073 806991 812106 736080 737868 744176 746791 746820 748028 753207 757039 760436 782112 783363 783920 785079 796378 797918 799854 810149 810917 748262 ] |
||||||||||||||||||||||||||||||
| 4 | 2.65 ms |
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 402083 403850 487254 496876 498554 539949 541043 541149 544033 550968 551600 552713 554693 556023 561052 576471 577023 577034 581930 583727 589545 592175 596039 598943 599283 602387 607365 607375 622303 623056 627414 629643 631246 636969 638497 642144 646074 647111 648931 659429 664181 665076 666981 669320 669858 671559 676555 683257 689902 692914 693267 694637 695549 703022 706442 710092 712962 713750 718036 719422 736080 737868 744176 746791 746820 748028 748262 753207 757039 760093 760436 774811 777715 778155 781245 782048 782112 782865 782908 783006 783363 783920 784414 784476 784522 785079 785113 785366 785367 785651 788337 790463 790730 794212 795156 796378 797918 798287 799854 803396 804507 805073 806821 806991 810149 810917 812106 812668 813643 813928 818690 818722 819891 820020 820088 824554 826832 827394 827439 827970 ] |
||||||||||||||||||||||||||||||
| 5 | 222.57 ms |
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 402083 403850 487254 496876 498554 539949 541043 541149 544033 550968 551600 552713 554693 556023 561052 576471 577023 577034 581930 583727 589545 592175 596039 598943 599283 602387 607365 607375 622303 623056 627414 629643 631246 636969 638497 642144 646074 647111 648931 659429 664181 665076 666981 669320 669858 671559 676555 683257 689902 692914 693267 694637 695549 703022 706442 710092 712962 713750 718036 719422 736080 737868 744176 746791 746820 748028 748262 753207 757039 760093 760436 774811 777715 778155 781245 782048 782112 782865 782908 783006 783363 783920 784414 784476 784522 785079 785113 785366 785367 785651 788337 790463 790730 794212 795156 796378 797918 798287 799854 803396 804507 805073 806821 806991 810149 810917 812106 812668 813643 813928 818690 818722 819891 820020 820088 824554 826832 827394 827439 827970 ] |
||||||||||||||||||||||||||||||
| 6 | 214.39 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац соло orgasm"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.56 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац соло orgasm"
]
|
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.