Query Metrics
7
Database Queries
7
Different statements
159.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.40 ms (83.51%) |
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 6663 6666 353401 381912 382217 384803 388826 395404 395492 396115 396568 396704 397946 405176 405907 408508 414666 415155 416236 425519 428385 428408 434716 434724 443231 444748 445741 451255 452269 454145 471832 473225 473920 476120 478491 479676 480280 486766 488721 497557 497725 507899 508191 517864 517869 520157 521897 524704 530382 534387 534590 536242 536712 536847 537204 537663 537888 540398 540410 540437 543548 558126 562377 565402 565948 568560 580122 580614 580653 583541 583982 585552 593167 600206 600360 600363 601536 604470 604476 604553 605606 606546 617411 622583 627811 628116 630250 630537 630544 630582 633764 633798 634153 634163 634198 637077 642041 646427 647357 647626 647972 649150 651647 657057 661283 670109 674430 674995 677362 684312 698095 699734 718947 720295 722527 729894 740616 744978 761083 780637 ] |
||||||||||||||||||||||||||||||
|
16.16 ms (10.12%) |
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 600206 642041 408508 670109 699734 630250 740616 451255 540398 634153 6666 405907 534590 580653 568560 580614 729894 604553 633764 537663 534387 651647 684312 476120 486766 480280 722527 585552 744978 384803 471832 382217 396704 405176 415155 524704 521897 488721 537888 530382 634198 649150 661283 605606 761083 395492 565948 454145 508191 543548 583541 537204 540410 600363 634163 604476 617411 540437 674995 600360 630537 353401 520157 497725 720295 630544 601536 478491 428408 507899 396115 536242 657057 647357 674430 718947 698095 630582 637077 627811 780637 425519 473225 395404 583982 381912 6663 388826 396568 434716 443231 444748 452269 479676 677362 562377 565402 580122 606546 622583 428385 416236 517864 497557 646427 647972 414666 445741 536847 647626 593167 604470 558126 633798 536712 473920 517869 628116 397946 434724 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.18%) |
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 6663 6666 353401 381912 382217 384803 388826 395404 395492 396115 396568 396704 397946 405176 405907 408508 414666 415155 416236 425519 428385 428408 434716 434724 443231 444748 445741 451255 452269 454145 471832 473225 473920 476120 478491 479676 480280 486766 488721 497557 497725 507899 508191 517864 517869 520157 521897 524704 530382 534387 534590 536242 536712 536847 537204 537663 537888 540398 540410 540437 543548 558126 562377 565402 565948 568560 580122 580614 580653 583541 583982 585552 593167 600206 600360 600363 601536 604470 604476 604553 605606 606546 617411 622583 627811 628116 630250 630537 630544 630582 633764 633798 634153 634163 634198 637077 642041 646427 647357 647626 647972 649150 651647 657057 661283 670109 674430 674995 677362 684312 698095 699734 718947 720295 722527 729894 740616 744978 761083 780637 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny anal bbc"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые анал bbc"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые анал bbc"
]
|
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.