Query Metrics
7
Database Queries
7
Different statements
154.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.84 ms (83.41%) |
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 321814 401248 416420 424655 424903 426012 426869 428296 432486 432624 432991 433461 433890 433901 433950 434193 434232 435365 435382 435803 436231 436680 437079 437788 439920 441877 442054 442443 442526 442695 442795 445667 446040 446817 447013 447813 447815 447919 448023 449816 449935 450152 450161 451634 453495 454860 456924 456993 458478 460679 461782 462281 462516 462979 463699 465043 467800 472574 474831 474918 474931 476496 478123 478552 479959 480833 483852 484345 486211 488069 496574 496669 503852 506100 508508 508805 509120 509250 509348 509536 510480 510701 513361 517494 518815 521079 521109 521954 523750 526935 530270 546899 548224 548599 553258 553261 553611 553714 555890 559997 563750 564715 565479 567074 568727 573328 574885 580657 581135 591171 616757 666778 695836 716762 732848 733405 735550 758388 781246 794974 ] |
||||||||||||||||||||||||||||||
|
15.78 ms (10.21%) |
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 424655 442526 426012 437788 428296 434193 435382 426869 442795 446817 449935 450152 456993 460679 474931 445667 447813 456924 486211 447013 462979 474831 476496 508805 510480 509348 465043 553611 574885 581135 546899 548599 553261 563750 573328 695836 666778 555890 565479 616757 794974 758388 781246 732848 733405 735550 716762 432991 433950 437079 447815 448023 451634 458478 478552 436680 439920 442443 462281 474918 435365 436231 450161 479959 321814 447919 454860 461782 463699 467800 480833 435803 453495 503852 509250 509536 483852 513361 521954 510701 517494 521109 523750 526935 509120 521079 553714 548224 559997 567074 591171 478123 488069 496669 508508 496574 506100 518815 401248 442054 416420 433901 424903 433890 441877 449816 472574 484345 530270 553258 564715 568727 580657 432486 442695 434232 446040 462516 433461 432624 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.83%) |
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 321814 401248 416420 424655 424903 426012 426869 428296 432486 432624 432991 433461 433890 433901 433950 434193 434232 435365 435382 435803 436231 436680 437079 437788 439920 441877 442054 442443 442526 442695 442795 445667 446040 446817 447013 447813 447815 447919 448023 449816 449935 450152 450161 451634 453495 454860 456924 456993 458478 460679 461782 462281 462516 462979 463699 465043 467800 472574 474831 474918 474931 476496 478123 478552 479959 480833 483852 484345 486211 488069 496574 496669 503852 506100 508508 508805 509120 509250 509348 509536 510480 510701 513361 517494 518815 521079 521109 521954 523750 526935 530270 546899 548224 548599 553258 553261 553611 553714 555890 559997 563750 564715 565479 567074 568727 573328 574885 580657 581135 591171 616757 666778 695836 716762 732848 733405 735550 758388 781246 794974 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"парень дрочит и кончает"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен дрочк сперм"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.