Query Metrics
7
Database Queries
7
Different statements
424.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.76 ms (49.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cute девушк секс"
]
|
||||||||||||||||||||||||||||||
|
188.36 ms (44.37%) |
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 82217 119987 309283 382493 384462 385605 386080 386892 389594 389668 393469 394707 397685 399887 399948 418999 420900 424612 434573 441181 446345 446350 455109 461489 465918 469863 481211 481357 496434 496446 498378 504672 518772 522156 530257 561725 573795 576307 586452 593281 603082 605816 607885 608426 611047 625639 632279 649226 650348 652925 653229 656732 658091 663240 669868 670997 673448 680768 691690 694533 695665 698482 698647 701131 701300 701935 725063 725133 727811 731354 733090 735597 738529 739519 740449 743961 744338 746958 747237 749713 749719 751110 751242 751723 751786 753736 755222 755403 755471 757829 757934 762035 762972 765398 773919 774833 778488 779008 779140 780002 785777 786496 786895 788405 790529 791071 791386 792309 797958 801193 807502 808768 809125 809972 810171 811244 813453 813466 820021 820884 ] |
||||||||||||||||||||||||||||||
|
14.72 ms (3.47%) |
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 653229 576307 611047 605816 743961 773919 731354 735597 778488 397685 785777 518772 593281 586452 625639 751242 757934 744338 382493 418999 820884 809125 810171 740449 701131 790529 809972 455109 669868 698482 751723 386080 561725 680768 792309 762035 389668 446345 751786 757829 498378 747237 309283 807502 82217 389594 820021 481357 522156 698647 603082 607885 779008 755222 749713 749719 786496 393469 649226 808768 701935 386892 496446 652925 656732 658091 608426 632279 774833 725133 746958 765398 481211 461489 119987 446350 786895 384462 465918 694533 673448 751110 434573 385605 663240 399887 394707 813466 755471 530257 691690 695665 779140 780002 813453 791071 811244 738529 753736 755403 788405 801193 424612 496434 650348 791386 739519 725063 733090 762972 420900 441181 504672 573795 670997 701300 727811 469863 399948 797958 ] |
||||||||||||||||||||||||||||||
|
4.06 ms (0.96%) |
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 82217 119987 309283 382493 384462 385605 386080 386892 389594 389668 393469 394707 397685 399887 399948 418999 420900 424612 434573 441181 446345 446350 455109 461489 465918 469863 481211 481357 496434 496446 498378 504672 518772 522156 530257 561725 573795 576307 586452 593281 603082 605816 607885 608426 611047 625639 632279 649226 650348 652925 653229 656732 658091 663240 669868 670997 673448 680768 691690 694533 695665 698482 698647 701131 701300 701935 725063 725133 727811 731354 733090 735597 738529 739519 740449 743961 744338 746958 747237 749713 749719 751110 751242 751723 751786 753736 755222 755403 755471 757829 757934 762035 762972 765398 773919 774833 778488 779008 779140 780002 785777 786496 786895 788405 790529 791071 791386 792309 797958 801193 807502 808768 809125 809972 810171 811244 813453 813466 820021 820884 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cute girl sex"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cute девушк секс"
]
|
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.