Query Metrics
7
Database Queries
7
Different statements
166.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.00 ms (80.61%) |
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 403108 413444 418215 418252 427248 434933 435008 440156 442356 444322 445443 446181 446709 446861 447608 450071 450334 450410 451386 456857 461898 462377 462850 463482 466601 466772 467888 467993 469830 470458 473500 476887 479544 485527 488295 488483 495421 500335 502826 505418 506989 508209 524064 527928 536471 536647 539857 540032 541776 543013 545155 546042 546048 553888 556044 562384 564856 566846 572241 578497 582489 588014 588175 594201 594359 595078 604370 615774 617395 619885 620614 624909 627137 629819 631714 631981 638576 649991 658837 672904 698878 703927 709128 715022 719982 720239 720262 721872 729974 733589 736548 737665 748741 750592 751435 752636 754127 756979 765256 782450 782894 784842 785114 785237 786066 787480 787485 788118 792341 793926 795471 795777 797127 799711 801610 803827 806967 813221 814523 826253 ] |
||||||||||||||||||||||||||||||
|
21.91 ms (13.18%) |
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 814523 446709 488295 450334 446861 540032 588014 782450 751435 709128 446181 450410 488483 451386 418215 502826 527928 788118 787480 413444 495421 754127 785114 462377 500335 595078 456857 461898 627137 729974 792341 703927 450071 485527 564856 444322 752636 427248 765256 539857 479544 572241 434933 462850 476887 447608 541776 797127 756979 546048 795777 442356 418252 435008 463482 649991 506989 720239 403108 469830 445443 505418 720262 617395 733589 619885 508209 658837 631714 750592 806967 470458 524064 594201 813221 801610 543013 473500 466772 578497 582489 629819 615774 672904 698878 604370 786066 795471 793926 799711 624909 440156 566846 536471 546042 620614 466601 467993 467888 737665 536647 782894 721872 556044 631981 545155 784842 553888 787485 748741 803827 736548 562384 715022 719982 594359 785237 638576 588175 826253 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.65%) |
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 403108 413444 418215 418252 427248 434933 435008 440156 442356 444322 445443 446181 446709 446861 447608 450071 450334 450410 451386 456857 461898 462377 462850 463482 466601 466772 467888 467993 469830 470458 473500 476887 479544 485527 488295 488483 495421 500335 502826 505418 506989 508209 524064 527928 536471 536647 539857 540032 541776 543013 545155 546042 546048 553888 556044 562384 564856 566846 572241 578497 582489 588014 588175 594201 594359 595078 604370 615774 617395 619885 620614 624909 627137 629819 631714 631981 638576 649991 658837 672904 698878 703927 709128 715022 719982 720239 720262 721872 729974 733589 736548 737665 748741 750592 751435 752636 754127 756979 765256 782450 782894 784842 785114 785237 786066 787480 787485 788118 792341 793926 795471 795777 797127 799711 801610 803827 806967 813221 814523 826253 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодая жена сквиртит…"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"молодая девушк жен сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодая девушк жен сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.07%) |
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.