Query Metrics
7
Database Queries
7
Different statements
238.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.06 ms (90.21%) |
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 420412 421236 421459 425299 429561 432822 433605 437582 441629 442257 442415 446191 446465 448969 450161 450760 450761 450783 450794 454846 471491 477869 478663 487693 489838 491815 494496 519832 520694 525171 527155 527681 528187 528215 529170 532569 540539 555767 562736 564127 566068 569394 572918 580363 580497 581135 584516 588946 590254 590492 592224 592750 593068 593873 594166 596945 599229 600279 601067 606644 607359 611351 620338 636928 654201 662370 717823 721757 728733 731473 755157 760476 761436 764958 765848 766903 767769 773228 774271 774994 775004 776195 776518 776886 776889 778265 778837 781192 784523 785007 786312 789846 791592 791983 792310 796008 796583 797944 798015 798631 798929 799502 799542 805739 805832 806763 808210 809271 809486 811095 811764 813488 814349 815108 815119 815121 816968 823196 825798 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (6.19%) |
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 823196 825798 532569 555767 581135 606644 599229 620338 636928 593873 796008 776889 781192 811095 813488 798631 760476 764958 767769 773228 755157 766903 799502 425299 776195 814349 815121 600279 477869 590254 809271 584516 569394 437582 528187 805832 478663 491815 442415 775004 776886 786312 799542 774994 776518 784523 791983 797944 798015 785007 791592 792310 774271 798929 806763 809486 450161 728733 540539 778837 494496 487693 441629 528215 450760 450783 527155 580497 572918 580363 588946 593068 471491 519832 450794 489838 525171 432822 520694 815108 527681 697943 433605 592224 662370 717823 721757 564127 592750 594166 808210 731473 789846 421459 429561 454846 654201 442257 611351 590492 601067 607359 596945 778265 805739 765848 446465 566068 448969 420412 421236 446191 529170 815119 562736 761436 796583 811764 816968 450761 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.15%) |
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 420412 421236 421459 425299 429561 432822 433605 437582 441629 442257 442415 446191 446465 448969 450161 450760 450761 450783 450794 454846 471491 477869 478663 487693 489838 491815 494496 519832 520694 525171 527155 527681 528187 528215 529170 532569 540539 555767 562736 564127 566068 569394 572918 580363 580497 581135 584516 588946 590254 590492 592224 592750 593068 593873 594166 596945 599229 600279 601067 606644 607359 611351 620338 636928 654201 662370 717823 721757 728733 731473 755157 760476 761436 764958 765848 766903 767769 773228 774271 774994 775004 776195 776518 776886 776889 778265 778837 781192 784523 785007 786312 789846 791592 791983 792310 796008 796583 797944 798015 798631 798929 799502 799542 805739 805832 806763 808210 809271 809486 811095 811764 813488 814349 815108 815119 815121 816968 823196 825798 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов дрочк член mom"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov handjob mom"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.59%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов дрочк член 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.