Query Metrics
7
Database Queries
7
Different statements
398.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.77 ms (54.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие milf mom"
]
|
||||||||||||||||||||||||||||||
|
160.14 ms (40.17%) |
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 397624 400872 401226 402342 404664 409109 412394 413091 413110 416791 418195 420540 421139 428846 430377 439709 450779 460184 472465 476904 477335 479019 479865 484768 519931 522168 524330 524783 524867 529305 547927 556648 563620 565142 603345 606639 606752 610235 612144 615759 621035 621229 636028 642743 643919 645917 645933 648986 649956 681153 682176 694149 699061 699355 702620 708626 715226 717037 719022 722081 724135 725374 726063 728277 731369 731806 745183 751451 753251 753620 754852 763845 765028 769911 771867 772032 775677 776954 781306 781492 784602 788161 788610 790002 799050 801357 801736 801888 803246 804247 805337 806093 806124 806147 807451 808614 813651 813774 815509 815975 816838 816929 817825 817873 818394 818495 818550 818822 820003 820746 821608 822589 823230 825366 826160 827884 828006 ] |
||||||||||||||||||||||||||||||
|
13.33 ms (3.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 428846 439709 450779 524330 519931 645933 565142 772032 818822 826160 815509 815975 818495 823230 813774 817825 820003 563620 649956 699355 708626 719022 681153 699061 715226 643919 606639 612144 615759 642743 621229 801357 808614 801736 801888 806124 806147 725374 753251 781492 784602 788161 765028 769911 724135 751451 726063 606752 636028 775677 799050 803246 806093 409109 524867 479019 401226 484768 529305 522168 745183 818550 825366 828006 556648 694149 722081 603345 731806 728277 753620 754852 731369 717037 404664 413091 524783 510295 476904 547927 645917 610235 788610 781306 763845 697939 402342 413110 420540 400872 412394 416791 460184 418195 430377 421139 472465 477335 776954 807451 771867 805337 816929 827884 682176 648986 702620 621035 804247 790002 397624 772079 479865 816838 817873 813651 818394 820746 821608 822589 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (0.69%) |
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 397624 400872 401226 402342 404664 409109 412394 413091 413110 416791 418195 420540 421139 428846 430377 439709 450779 460184 472465 476904 477335 479019 479865 484768 519931 522168 524330 524783 524867 529305 547927 556648 563620 565142 603345 606639 606752 610235 612144 615759 621035 621229 636028 642743 643919 645917 645933 648986 649956 681153 682176 694149 699061 699355 702620 708626 715226 717037 719022 722081 724135 725374 726063 728277 731369 731806 745183 751451 753251 753620 754852 763845 765028 769911 771867 772032 775677 776954 781306 781492 784602 788161 788610 790002 799050 801357 801736 801888 803246 804247 805337 806093 806124 806147 807451 808614 813651 813774 815509 815975 816838 816929 817825 817873 818394 818495 818550 818822 820003 820746 821608 822589 823230 825366 826160 827884 828006 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big milf mom"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие milf mom"
]
|
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.