Query Metrics
7
Database Queries
7
Different statements
221.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.01 ms (87.25%) |
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 383599 411884 413826 414116 415859 416512 416680 418139 418145 421366 430355 432179 434286 434337 434364 437518 437864 439233 444194 444515 446038 446709 447608 448816 448898 450410 451261 452382 452953 452977 462850 467878 467888 468142 470414 470458 473778 476191 479661 492525 502043 503183 506516 512975 514399 515440 528361 530011 530625 531194 532847 534647 535358 535620 536783 537204 537663 537906 541832 544404 550203 552608 559453 569223 582540 583866 599976 600175 601613 606578 614858 629962 630083 632649 633123 633451 633458 633796 635234 636303 639716 639742 639798 640800 642000 642033 642775 645861 647939 648825 649546 649596 650544 651850 656568 657136 661510 666538 666895 676090 677784 696582 699397 702622 710161 728200 750701 751435 752647 765222 765628 765668 770382 785059 788344 803455 813221 813819 814523 ] |
||||||||||||||||||||||||||||||
|
18.44 ms (8.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 770382 470414 452382 447608 642033 416680 503183 765628 728200 448898 418139 814523 661510 492525 416512 535358 531194 550203 642000 640800 606578 651850 710161 437864 421366 630083 633796 437518 535620 476191 414116 467888 467878 450410 647939 633458 537906 468142 528361 666538 530011 656568 583866 765668 418145 636303 639742 544404 383599 530625 676090 648825 552608 432179 514399 415859 534647 657136 629962 751435 444515 649596 434286 788344 787989 813221 515440 559453 569223 537663 434337 650544 600175 785059 430355 446709 532847 599976 633451 601613 614858 506516 446038 541832 411884 462850 452977 536783 696582 699397 633123 677784 473778 752647 649546 439233 451261 444194 666895 639798 639716 803455 413826 537204 582540 632649 813819 479661 635234 702622 434364 502043 448816 512975 452953 750701 470458 645861 765222 642775 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.27%) |
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 383599 411884 413826 414116 415859 416512 416680 418139 418145 421366 430355 432179 434286 434337 434364 437518 437864 439233 444194 444515 446038 446709 447608 448816 448898 450410 451261 452382 452953 452977 462850 467878 467888 468142 470414 470458 473778 476191 479661 492525 502043 503183 506516 512975 514399 515440 528361 530011 530625 531194 532847 534647 535358 535620 536783 537204 537663 537906 541832 544404 550203 552608 559453 569223 582540 583866 599976 600175 601613 606578 614858 629962 630083 632649 633123 633451 633458 633796 635234 636303 639716 639742 639798 640800 642000 642033 642775 645861 647939 648825 649546 649596 650544 651850 656568 657136 661510 666538 666895 676090 677784 696582 699397 702622 710161 728200 750701 751435 752647 765222 765628 765668 770382 785059 788344 803455 813221 813819 814523 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo anal squirt"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд анал сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.67%) |
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.