Query Metrics
7
Database Queries
7
Different statements
167.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.10 ms (83.75%) |
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 142809 214602 214719 383558 384310 384900 388296 391440 396365 398715 402506 402967 410745 411953 419356 428484 435638 437333 437341 438779 440737 442475 454529 456621 457409 462116 470510 484827 484829 484855 484862 487607 488733 491374 504463 533322 534080 548373 548740 554360 558619 560437 561081 562359 569595 574131 578367 579853 580697 580705 580717 581854 588262 595765 601500 609479 609858 621999 623831 626895 630861 634192 637189 646228 659311 666778 677821 691830 691878 694117 698140 709648 715395 715545 716754 718881 720939 727314 731994 731999 736656 736830 742022 742605 747129 748138 748213 748243 756231 760698 761655 762644 765394 768739 773928 775710 775833 775843 776020 776320 787780 789857 790844 794844 796427 802356 806447 807337 807404 808059 809070 810769 810771 811010 812560 814631 817705 821680 822645 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (10.62%) |
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 142809 214719 814631 484829 504463 787780 558619 548373 694117 698140 659311 579853 637189 806447 731999 731994 768739 761655 391440 396365 440737 484855 214602 398715 419356 487607 533322 554879 718881 776020 736656 756231 491374 437341 411953 484827 554360 646228 677821 715395 666778 621999 588262 595765 623831 776320 790844 807337 808059 794844 748138 748213 748243 760698 609858 634192 802356 810769 811010 457409 383558 384310 388296 402506 821680 817705 456621 569595 691830 691878 720939 609479 601500 630861 796427 812560 773928 789857 747129 742022 765394 742605 762644 709648 715545 716754 442475 574131 578367 561081 626895 807404 809070 775843 438779 470510 484862 384900 402967 428484 410745 822645 534080 548740 562359 581854 580717 580705 775833 810771 736830 727314 775710 454529 462116 435638 560437 488733 580697 437333 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.45%) |
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 142809 214602 214719 383558 384310 384900 388296 391440 396365 398715 402506 402967 410745 411953 419356 428484 435638 437333 437341 438779 440737 442475 454529 456621 457409 462116 470510 484827 484829 484855 484862 487607 488733 491374 504463 533322 534080 548373 548740 554360 558619 560437 561081 562359 569595 574131 578367 579853 580697 580705 580717 581854 588262 595765 601500 609479 609858 621999 623831 626895 630861 634192 637189 646228 659311 666778 677821 691830 691878 694117 698140 709648 715395 715545 716754 718881 720939 727314 731994 731999 736656 736830 742022 742605 747129 748138 748213 748243 756231 760698 761655 762644 765394 768739 773928 775710 775833 775843 776020 776320 787780 789857 790844 794844 796427 802356 806447 807337 807404 808059 809070 810769 810771 811010 812560 814631 817705 821680 822645 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"party tits"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"party сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"party сиськ"
]
|
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.