Query Metrics
7
Database Queries
7
Different statements
162.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.56 ms (85.17%) |
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 88476 428299 439218 445141 446241 446245 447381 448598 449561 450994 451082 454817 462220 462224 466568 467633 468302 482116 483686 483738 496703 498972 499369 510170 525373 528056 533305 533780 539092 541655 544791 546407 546421 549097 552446 553884 553905 567253 568112 574949 575700 578698 581015 583224 584893 584922 584936 584942 585370 586100 586999 587547 589206 589239 590458 592075 596177 601054 603301 607244 611204 611208 618405 619295 625633 631982 633041 635724 636708 638887 640047 641032 644367 645520 649487 654992 676769 687315 690764 704687 704990 706413 706421 709542 709910 709970 714474 730867 730871 740345 745345 749084 751335 752570 754153 757566 758622 768848 774180 774578 776209 777160 777522 778730 781392 781948 782050 782150 784872 784980 786916 789408 796409 796943 806633 807569 811894 814171 814955 822821 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (8.43%) |
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 583224 581015 578698 585370 601054 584942 768848 784872 781392 589206 751335 589239 806633 539092 553905 654992 782050 778730 754153 758622 774578 709970 644367 811894 814171 462220 541655 546421 584922 789408 584936 631982 596177 709910 633041 777522 704990 641032 752570 740345 549097 690764 635724 706413 568112 822821 687315 636708 618405 786916 528056 584893 777160 553884 552446 706421 638887 814955 592075 781948 782150 88476 586100 774180 796409 454817 574949 544791 449561 619295 640047 676769 709542 704687 587547 611208 784980 590458 807569 749084 533305 446241 468302 649487 586999 447381 448598 466568 645520 499369 450994 533780 498972 730867 546407 730871 603301 451082 575700 428299 496703 757566 462224 611204 625633 796943 482116 714474 439218 445141 510170 467633 525373 567253 483738 607244 776209 745345 446245 483686 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.83%) |
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 88476 428299 439218 445141 446241 446245 447381 448598 449561 450994 451082 454817 462220 462224 466568 467633 468302 482116 483686 483738 496703 498972 499369 510170 525373 528056 533305 533780 539092 541655 544791 546407 546421 549097 552446 553884 553905 567253 568112 574949 575700 578698 581015 583224 584893 584922 584936 584942 585370 586100 586999 587547 589206 589239 590458 592075 596177 601054 603301 607244 611204 611208 618405 619295 625633 631982 633041 635724 636708 638887 640047 641032 644367 645520 649487 654992 676769 687315 690764 704687 704990 706413 706421 709542 709910 709970 714474 730867 730871 740345 745345 749084 751335 752570 754153 757566 758622 768848 774180 774578 776209 777160 777522 778730 781392 781948 782050 782150 784872 784980 786916 789408 796409 796943 806633 807569 811894 814171 814955 822821 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fit girl solo"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fit девушк соло"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fit девушк соло"
]
|
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.