Query Metrics
7
Database Queries
7
Different statements
200.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.25 ms (85.88%) |
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 384786 390624 402967 403761 421709 424517 427580 429595 435318 437325 437333 438787 446578 447007 448521 451033 451038 452333 452796 454122 454137 455487 455950 458328 458791 459892 459965 460387 460872 461693 463567 464826 470560 471497 472787 475599 476521 479584 480903 483274 484830 484857 484860 487172 490088 490280 492012 495324 495600 495940 496850 497462 497588 502552 506718 509265 510261 512916 514765 516424 519438 520523 520877 521965 523313 523315 526604 526860 527356 530863 532746 535416 541561 541629 542053 543389 543971 546730 548740 557100 560452 560587 561930 565770 566415 568732 568763 571801 571802 577690 579171 579530 584567 586532 601754 602971 603648 605735 609214 615707 619524 624429 624949 626569 626838 631908 632567 654923 717603 718788 720447 726478 735910 755448 756966 772167 776566 781511 796804 811770 ] |
||||||||||||||||||||||||||||||
|
15.87 ms (7.91%) |
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 483274 429595 447007 452796 455950 459965 460387 455487 487172 532746 512916 492012 541561 579530 543389 543971 568732 571801 577690 615707 603648 586532 776566 755448 735910 772167 438787 475599 461693 520523 484860 521965 484830 496850 523313 384786 530863 427580 437333 424517 451038 479584 452333 463567 472787 527356 565770 541629 571802 717603 720447 584567 609214 619524 626838 811770 781511 756966 726478 471497 435318 437325 458328 446578 454137 464826 480903 451033 476521 509265 526604 526860 495600 506718 495940 510261 516424 523315 403761 495324 542053 718788 796804 497462 514765 566415 654923 624429 624949 632567 601754 626569 454122 605735 631908 390624 421709 448521 490280 497588 602971 402967 548740 484857 458791 460872 470560 459892 490088 519438 502552 520877 535416 561930 557100 560452 560587 546730 568763 579171 ] |
||||||||||||||||||||||||||||||
|
4.62 ms (2.30%) |
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 384786 390624 402967 403761 421709 424517 427580 429595 435318 437325 437333 438787 446578 447007 448521 451033 451038 452333 452796 454122 454137 455487 455950 458328 458791 459892 459965 460387 460872 461693 463567 464826 470560 471497 472787 475599 476521 479584 480903 483274 484830 484857 484860 487172 490088 490280 492012 495324 495600 495940 496850 497462 497588 502552 506718 509265 510261 512916 514765 516424 519438 520523 520877 521965 523313 523315 526604 526860 527356 530863 532746 535416 541561 541629 542053 543389 543971 546730 548740 557100 560452 560587 561930 565770 566415 568732 568763 571801 571802 577690 579171 579530 584567 586532 601754 602971 603648 605735 609214 615707 619524 624429 624949 626569 626838 631908 632567 654923 717603 718788 720447 726478 735910 755448 756966 772167 776566 781511 796804 811770 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"party homemade"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"party домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"party домашн любительск"
]
|
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.