Query Metrics
7
Database Queries
7
Different statements
149.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.31 ms (81.81%) |
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 47707 97377 386798 391202 414337 415112 416529 416751 424682 427174 428116 429805 433147 436230 443090 445641 448414 449115 451866 452311 452773 453623 460209 463098 463825 464372 465604 466294 466801 467763 469520 469766 470015 471439 471881 474663 475684 476098 477073 477076 477587 477744 478517 478575 480296 480457 483544 484809 484899 486589 487632 492701 495397 495401 496794 498551 502102 505069 508692 516656 517308 519209 520216 527568 532817 532876 535621 536712 540167 541650 549086 553480 558012 564646 568190 568423 568457 569132 569176 569197 571235 574384 586569 597170 602519 605521 607091 610616 616036 620163 625783 629893 629951 630542 637002 647322 647663 650315 651607 652544 674082 674863 677707 680271 681691 709645 711283 729344 770225 778607 784146 788608 790219 792557 799785 801259 811102 815600 819557 824263 ] |
||||||||||||||||||||||||||||||
|
18.23 ms (12.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 517308 429805 449115 681691 811102 451866 443090 452311 770225 569176 505069 647663 647322 498551 484809 471439 470015 47707 819557 508692 586569 391202 484899 520216 97377 452773 553480 453623 414337 477076 652544 463825 478575 571235 466294 478517 448414 527568 799785 574384 424682 477587 483544 427174 428116 416529 558012 540167 625783 616036 476098 465604 467763 516656 477073 464372 568423 568457 463098 535621 541650 486589 496794 495397 629893 610616 445641 474663 480457 532817 502102 568190 674082 677707 674863 709645 607091 620163 778607 801259 788608 729344 790219 477744 711283 475684 436230 386798 466801 519209 630542 784146 792557 824263 650315 564646 569132 651607 602519 629951 597170 469520 415112 433147 536712 637002 605521 416751 815600 471881 680271 487632 495401 492701 469766 480296 532876 460209 549086 569197 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.58%) |
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 47707 97377 386798 391202 414337 415112 416529 416751 424682 427174 428116 429805 433147 436230 443090 445641 448414 449115 451866 452311 452773 453623 460209 463098 463825 464372 465604 466294 466801 467763 469520 469766 470015 471439 471881 474663 475684 476098 477073 477076 477587 477744 478517 478575 480296 480457 483544 484809 484899 486589 487632 492701 495397 495401 496794 498551 502102 505069 508692 516656 517308 519209 520216 527568 532817 532876 535621 536712 540167 541650 549086 553480 558012 564646 568190 568423 568457 569132 569176 569197 571235 574384 586569 597170 602519 605521 607091 610616 616036 620163 625783 629893 629951 630542 637002 647322 647663 650315 651607 652544 674082 674863 677707 680271 681691 709645 711283 729344 770225 778607 784146 788608 790219 792557 799785 801259 811102 815600 819557 824263 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal compilation stockings"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал подборк чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал подборк чулк нижн бел"
]
|
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.