Query Metrics
7
Database Queries
7
Different statements
175.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.09 ms (85.39%) |
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 388713 396866 417441 421051 427759 436132 441901 443231 445783 453583 455898 457294 459032 460328 466588 467110 467195 469619 471035 482773 491497 492064 496033 498112 511810 521810 521850 522284 522785 528173 530483 530796 531248 532737 532760 533372 533928 534150 534381 534791 536527 536542 536562 536570 536645 536752 537901 537908 540348 542583 545461 545611 558171 574459 576503 578786 580180 584006 585999 586407 588697 592384 595194 595214 596919 598504 599894 601575 604387 604500 625412 627007 628082 631203 634780 639335 639716 639798 647972 657865 660365 660405 666865 668526 668663 675660 679770 681301 681596 681609 716878 726634 738827 744261 745384 754321 755020 757402 765092 765810 775414 776041 782538 783038 783693 785877 791914 798601 803757 807660 810822 811125 812372 812759 814338 816722 817351 823929 824900 ] |
||||||||||||||||||||||||||||||
|
16.04 ms (9.13%) |
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 785877 811125 469619 814338 681609 783038 744261 726634 783693 558171 595194 716878 580180 436132 453583 498112 816722 482773 536542 531248 599894 601575 631203 738827 791914 824900 578786 812759 755020 803757 545461 592384 459032 467195 396866 776041 807660 754321 765092 765810 534150 537901 445783 427759 660365 595214 596919 798601 388713 536562 537908 532737 542583 441901 817351 467110 536570 536527 576503 668663 681596 598504 812372 757402 604500 681301 513476 511810 491497 530796 521850 536752 668526 625412 496033 443231 823929 466588 660405 657865 627007 586407 775414 782538 421051 532760 533928 533372 584006 745384 522785 585999 604387 647972 639798 639716 628082 492064 417441 460328 471035 540348 675660 679770 639335 588697 534791 521810 455898 545611 666865 634780 528173 536645 457294 530483 534381 574459 810822 522284 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.60%) |
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 388713 396866 417441 421051 427759 436132 441901 443231 445783 453583 455898 457294 459032 460328 466588 467110 467195 469619 471035 482773 491497 492064 496033 498112 511810 521810 521850 522284 522785 528173 530483 530796 531248 532737 532760 533372 533928 534150 534381 534791 536527 536542 536562 536570 536645 536752 537901 537908 540348 542583 545461 545611 558171 574459 576503 578786 580180 584006 585999 586407 588697 592384 595194 595214 596919 598504 599894 601575 604387 604500 625412 627007 628082 631203 634780 639335 639716 639798 647972 657865 660365 660405 666865 668526 668663 675660 679770 681301 681596 681609 716878 726634 738827 744261 745384 754321 755020 757402 765092 765810 775414 776041 782538 783038 783693 785877 791914 798601 803757 807660 810822 811125 812372 812759 814338 816722 817351 823929 824900 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black dildo"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black дилд"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black дилд"
]
|
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.