Query Metrics
7
Database Queries
7
Different statements
195.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.68 ms (88.04%) |
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 266526 391506 401001 423497 438848 453273 458554 495175 509311 516758 525024 530604 530895 532536 534658 534727 535359 536298 536573 538684 539654 545358 546403 548143 548274 550645 557446 559709 560369 564286 567270 573168 577602 583294 583517 584321 585832 605580 606922 610580 613813 616117 621168 625678 626285 633577 638956 655211 659028 668485 668544 672105 676862 680772 683078 684815 685900 685909 689566 695759 695760 701192 707239 709358 710360 713058 716262 719473 719790 721772 722053 725639 726122 727562 728660 729069 730929 731128 731265 732408 733394 733530 745749 748509 751200 751516 751614 753612 757216 757291 758215 762062 762555 762621 763252 763874 767759 770234 777454 783123 787909 795916 799054 800682 802549 802555 808682 808711 809049 812492 814343 817165 817263 817688 819261 823552 824563 825774 826160 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (6.74%) |
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 726122 730929 732408 748509 759378 762062 763874 767759 725639 727562 745749 751614 757216 758215 770234 729069 753612 757291 762555 728660 731128 731265 733394 733530 751200 751516 762621 763252 610580 638956 701192 707239 713058 722053 777454 783123 787909 795916 799054 800682 802549 802555 808682 808711 809049 812492 401001 391506 266526 423497 438848 823552 825774 817165 817263 826160 814343 817688 819261 824563 458554 453273 495175 534658 535359 536298 538684 539654 536573 509311 516758 530604 530895 532536 534727 525024 550645 557446 545358 548143 559709 560369 564286 577602 583294 548274 573168 584321 668544 683078 684815 716262 719473 721772 655211 668485 695760 709358 659028 672105 676862 680772 685900 685909 689566 695759 710360 719790 546403 567270 583517 585832 606922 616117 625678 605580 613813 621168 626285 633577 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.53%) |
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 266526 391506 401001 423497 438848 453273 458554 495175 509311 516758 525024 530604 530895 532536 534658 534727 535359 536298 536573 538684 539654 545358 546403 548143 548274 550645 557446 559709 560369 564286 567270 573168 577602 583294 583517 584321 585832 605580 606922 610580 613813 616117 621168 625678 626285 633577 638956 655211 659028 668485 668544 672105 676862 680772 683078 684815 685900 685909 689566 695759 695760 701192 707239 709358 710360 713058 716262 719473 719790 721772 722053 725639 726122 727562 728660 729069 730929 731128 731265 732408 733394 733530 745749 748509 751200 751516 751614 753612 757216 757291 758215 762062 762555 762621 763252 763874 767759 770234 777454 783123 787909 795916 799054 800682 802549 802555 808682 808711 809049 812492 814343 817165 817263 817688 819261 823552 824563 825774 826160 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom webcam"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom вебкамер"
]
|
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.