Query Metrics
7
Database Queries
7
Different statements
209.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.08 ms (88.62%) |
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 154015 396841 421776 426508 428250 428567 428798 438421 444065 444163 444675 445884 446212 448249 449327 450711 453580 453967 459603 461259 467174 474809 475312 476071 478564 479189 484942 489610 495311 498725 500749 501473 504751 505607 507447 509641 511207 512421 514359 514375 514751 514763 518760 519767 521070 522252 526853 536903 556219 559534 563653 567073 567511 574030 580242 586019 587431 588622 592639 600730 601863 604884 605366 606018 609833 612261 613625 619103 626472 641408 646981 647815 658136 685943 689394 689542 693235 696123 702130 709431 709781 710275 713757 713938 719480 721582 728523 734521 736119 741886 743799 744392 747091 756848 757551 762353 764280 771724 778428 780714 785255 789279 789772 790473 791095 793997 795709 795737 796155 798489 800810 801227 802274 802947 808228 809637 810719 812802 814515 816764 ] |
||||||||||||||||||||||||||||||
|
14.27 ms (6.80%) |
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 658136 713938 646981 689394 689542 696123 588622 605366 641408 604884 778428 795709 812802 785255 793997 809637 744392 757551 736119 743799 764280 756848 619103 626472 721582 795737 802274 396841 514375 484942 567073 461259 509641 500749 501473 507447 522252 514751 512421 467174 567511 574030 713757 719480 606018 613625 789772 800810 801227 802947 741886 747091 789279 790473 426508 498725 526853 428798 444675 444163 428567 816764 475312 449327 453967 495311 511207 519767 489610 556219 702130 709781 647815 710275 559534 563653 586019 601863 609833 600730 587431 592639 791095 796155 798489 808228 780714 810719 762353 728523 771724 734521 438421 446212 154015 445884 444065 459603 476071 518760 505607 521070 514763 612261 536903 448249 428250 421776 814515 474809 450711 453580 479189 504751 514359 478564 580242 693235 685943 709431 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.38%) |
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 154015 396841 421776 426508 428250 428567 428798 438421 444065 444163 444675 445884 446212 448249 449327 450711 453580 453967 459603 461259 467174 474809 475312 476071 478564 479189 484942 489610 495311 498725 500749 501473 504751 505607 507447 509641 511207 512421 514359 514375 514751 514763 518760 519767 521070 522252 526853 536903 556219 559534 563653 567073 567511 574030 580242 586019 587431 588622 592639 600730 601863 604884 605366 606018 609833 612261 613625 619103 626472 641408 646981 647815 658136 685943 689394 689542 693235 696123 702130 709431 709781 710275 713757 713938 719480 721582 728523 734521 736119 741886 743799 744392 747091 756848 757551 762353 764280 771724 778428 780714 785255 789279 789772 790473 791095 793997 795709 795737 796155 798489 800810 801227 802274 802947 808228 809637 810719 812802 814515 816764 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"i fucked her"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"i fucked her"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"i fucked her"
]
|
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.