Query Metrics
7
Database Queries
7
Different statements
143.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.35 ms (83.98%) |
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 188282 392739 399966 400487 406969 418916 426940 428146 428843 452308 453444 458721 459887 462455 468307 472675 476247 479493 480246 485922 512100 513194 527668 532821 538972 552762 558226 561460 562018 586150 591048 599518 601986 606685 618910 621488 625268 631292 666091 670749 678986 682065 689558 697512 700827 703900 710119 712176 712679 714049 714750 714868 716178 720899 722346 723961 725182 725226 726841 730526 733514 734040 736130 742271 742276 742283 745974 745987 745996 747421 755611 758314 759905 761230 761253 765580 769494 777135 781650 783115 784653 786569 788943 789353 789365 789617 789630 792631 793577 794102 795127 798820 799360 799962 799966 800935 802177 802670 802937 803522 803787 804552 805819 806356 811145 812785 813608 813750 816696 817551 817574 817585 817972 817991 818497 824446 825380 825940 828335 ] |
||||||||||||||||||||||||||||||
|
12.99 ms (9.06%) |
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 733514 730526 742283 714750 781650 392739 813750 462455 532821 538972 802177 759905 806356 406969 485922 817551 824446 825940 816696 817991 817585 817972 825380 817574 818497 828335 670749 720899 784653 789353 789365 789630 734040 742271 755611 761253 783115 803787 725226 745987 745996 777135 794102 799360 452308 512100 418916 428146 714868 804552 742276 761230 631292 527668 813608 453444 479493 552762 561460 562018 558226 700827 714049 716178 722346 678986 682065 710119 666091 689558 697512 712176 712679 606685 621488 586150 618910 786569 789617 800935 803361 812785 723961 736130 758314 788943 798820 802670 725182 747421 745974 769494 726841 601986 625268 793577 795127 799966 802937 805819 811145 459887 591048 803522 480246 476247 599518 792631 765580 703900 799962 400487 426940 468307 472675 513194 399966 188282 428843 458721 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.85%) |
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 188282 392739 399966 400487 406969 418916 426940 428146 428843 452308 453444 458721 459887 462455 468307 472675 476247 479493 480246 485922 512100 513194 527668 532821 538972 552762 558226 561460 562018 586150 591048 599518 601986 606685 618910 621488 625268 631292 666091 670749 678986 682065 689558 697512 700827 703900 710119 712176 712679 714049 714750 714868 716178 720899 722346 723961 725182 725226 726841 730526 733514 734040 736130 742271 742276 742283 745974 745987 745996 747421 755611 758314 759905 761230 761253 765580 769494 777135 781650 783115 784653 786569 788943 789353 789365 789617 789630 792631 793577 794102 795127 798820 799360 799962 799966 800935 802177 802670 802937 803522 803787 804552 805819 806356 811145 812785 813608 813750 816696 817551 817574 817585 817972 817991 818497 824446 825380 825940 828335 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин stepson"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин stepson"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother stepson"
]
|
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.