Query Metrics
7
Database Queries
7
Different statements
400.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.22 ms (54.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин son жоп"
]
|
||||||||||||||||||||||||||||||
|
157.41 ms (39.27%) |
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 45357 55266 364242 384470 394738 399961 400486 400498 400888 403003 407187 410748 413463 414027 415584 417005 417015 418974 421834 421838 421853 421913 422165 422183 422207 428454 428463 428468 428547 428840 428844 428852 428910 432596 437361 437670 440979 443996 446107 448701 448963 450995 455183 459254 464805 465545 466496 470995 473935 476904 477067 484052 493168 495223 505956 514007 516485 519604 521137 523031 523836 524778 524779 526521 526728 530409 540138 543798 544787 546921 549833 549847 550225 552762 556582 581893 582656 593805 620245 623714 684308 699277 709575 710549 714489 715459 718560 722721 724502 724706 725473 725484 725499 725536 731093 732140 732358 735840 736977 742760 746176 746267 748231 779768 779904 780795 782626 788804 789188 796203 796205 796214 799983 806114 807453 813771 820379 820745 821757 823619 ] |
||||||||||||||||||||||||||||||
|
17.84 ms (4.45%) |
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 516485 732140 45357 718560 748231 782626 443996 55266 779768 428844 421838 543798 437361 546921 735840 820745 821757 722721 544787 806114 422165 710549 549833 620245 428910 823619 732358 788804 364242 384470 465545 540138 495223 623714 725484 725473 746176 742760 417015 484052 523836 514007 421913 394738 407187 428468 530409 556582 725499 724502 473935 428454 413463 820379 448701 437670 493168 581893 400486 400498 440979 550225 724706 459254 400888 450995 684308 428463 432596 523031 524779 414027 813771 552762 582656 699277 715459 714489 593805 789188 807453 780795 725536 736977 796214 731093 746267 709575 799983 410748 477067 448963 466496 521137 524778 428852 779904 796205 796203 418974 455183 417005 519604 549847 403003 428547 476904 428840 421853 526521 399961 446107 464805 415584 526728 422183 421834 505956 422207 470995 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.76%) |
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 45357 55266 364242 384470 394738 399961 400486 400498 400888 403003 407187 410748 413463 414027 415584 417005 417015 418974 421834 421838 421853 421913 422165 422183 422207 428454 428463 428468 428547 428840 428844 428852 428910 432596 437361 437670 440979 443996 446107 448701 448963 450995 455183 459254 464805 465545 466496 470995 473935 476904 477067 484052 493168 495223 505956 514007 516485 519604 521137 523031 523836 524778 524779 526521 526728 530409 540138 543798 544787 546921 549833 549847 550225 552762 556582 581893 582656 593805 620245 623714 684308 699277 709575 710549 714489 715459 718560 722721 724502 724706 725473 725484 725499 725536 731093 732140 732358 735840 736977 742760 746176 746267 748231 779768 779904 780795 782626 788804 789188 796203 796205 796214 799983 806114 807453 813771 820379 820745 821757 823619 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother son ass"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин son жоп"
]
|
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.