Query Metrics
7
Database Queries
7
Different statements
390.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.53 ms (53.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty анал дилд"
]
|
||||||||||||||||||||||||||||||
|
156.37 ms (40.02%) |
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 410272 417674 429006 431028 434310 435551 443464 448607 453213 456907 458051 460120 466177 469198 469758 477125 479694 481807 486856 495070 503934 511359 512059 512486 513223 522917 523333 525287 525608 531133 531231 532940 533016 534041 537679 537993 540333 540334 541853 555065 555834 556911 565276 576125 582277 592675 595458 597216 599001 599885 599928 600252 600329 600798 604109 604342 605315 606587 610683 617418 629934 630533 630546 631193 631243 632632 633502 633533 634135 634512 636308 639719 639751 641930 642016 642037 642044 643376 646920 647948 666867 675008 675858 675866 676428 679770 679775 680174 680428 682521 695127 700250 700990 700996 702061 702621 704528 719001 720719 729687 738503 744947 756506 759987 760396 770314 770802 775539 790239 802121 803046 803524 806078 808579 809439 811037 814783 815370 815865 819571 ] |
||||||||||||||||||||||||||||||
|
17.25 ms (4.41%) |
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 700996 719001 666867 679770 606587 595458 600329 600798 599928 631243 806078 803524 738503 756506 759987 770314 629934 803046 456907 481807 702621 634512 429006 513223 477125 469198 599001 760396 675008 597216 633502 639751 632632 525287 435551 814783 819571 815865 532940 537679 540334 531133 555834 675866 700990 700250 720719 675858 555065 576125 610683 605315 634135 604109 809439 744947 770802 790239 811037 466177 512486 486856 641930 617418 643376 808579 802121 631193 702061 522917 410272 636308 582277 775539 495070 682521 523333 531231 443464 815370 469758 533016 679775 592675 729687 448607 479694 453213 460120 431028 537993 458051 503934 512059 434310 541853 565276 647948 676428 695127 600252 630533 630546 642044 639719 642037 642016 604342 511359 680428 417674 525608 534041 540333 556911 646920 680174 704528 599885 633533 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (0.61%) |
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 410272 417674 429006 431028 434310 435551 443464 448607 453213 456907 458051 460120 466177 469198 469758 477125 479694 481807 486856 495070 503934 511359 512059 512486 513223 522917 523333 525287 525608 531133 531231 532940 533016 534041 537679 537993 540333 540334 541853 555065 555834 556911 565276 576125 582277 592675 595458 597216 599001 599885 599928 600252 600329 600798 604109 604342 605315 606587 610683 617418 629934 630533 630546 631193 631243 632632 633502 633533 634135 634512 636308 639719 639751 641930 642016 642037 642044 643376 646920 647948 666867 675008 675858 675866 676428 679770 679775 680174 680428 682521 695127 700250 700990 700996 702061 702621 704528 719001 720719 729687 738503 744947 756506 759987 760396 770314 770802 775539 790239 802121 803046 803524 806078 808579 809439 811037 814783 815370 815865 819571 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty anal dildo"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty анал дилд"
]
|
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.