Query Metrics
7
Database Queries
7
Different statements
145.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.11 ms (84.66%) |
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 184985 185011 382206 386719 390219 403549 408085 414064 416038 419147 419218 421105 424608 425330 426293 428960 430650 432404 433592 441985 442679 445103 445540 445958 446430 447548 447562 449355 449469 451890 454443 454705 460951 465079 465161 468148 468538 471715 472484 479029 484355 488467 490165 491268 508353 510205 511413 521615 521915 526824 530529 530727 531427 531446 532237 533638 533937 536110 536728 538770 555056 558189 561346 562348 569827 577320 611119 614424 706601 722799 726844 732109 734350 736587 738813 739084 745470 748954 752452 759267 759711 760549 761201 761422 763154 766349 767417 775853 776057 777838 778058 779948 784641 784951 786147 787619 796996 797752 798765 800114 800324 802833 804787 806179 807122 809686 813002 813214 813789 815392 815717 815751 815873 815893 819110 820162 823295 823566 826241 827079 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (9.07%) |
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 807122 775853 776057 777838 779948 784951 796996 800324 804787 813002 745470 761422 784641 798765 809686 726844 759267 736587 738813 752452 732109 734350 739084 748954 759711 763154 767417 760549 766349 611119 614424 706601 722799 778058 786147 787619 797752 800114 802833 806179 813214 386719 428960 382206 460951 390219 421105 445958 488467 184985 419147 414064 442679 408085 433592 441985 419218 468148 484355 454705 445540 451890 454443 510205 533937 526824 472484 555056 562348 569827 577320 761201 432404 446430 479029 416038 424608 425330 430650 465079 465161 468538 445103 447548 447562 449355 491268 511413 536728 508353 521915 561346 531446 185011 403549 426293 813789 815392 819110 823295 815873 815893 827079 815751 826241 815717 820162 823566 449469 533638 536110 530727 538770 530529 532237 521615 531427 471715 490165 558189 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.43%) |
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 184985 185011 382206 386719 390219 403549 408085 414064 416038 419147 419218 421105 424608 425330 426293 428960 430650 432404 433592 441985 442679 445103 445540 445958 446430 447548 447562 449355 449469 451890 454443 454705 460951 465079 465161 468148 468538 471715 472484 479029 484355 488467 490165 491268 508353 510205 511413 521615 521915 526824 530529 530727 531427 531446 532237 533638 533937 536110 536728 538770 555056 558189 561346 562348 569827 577320 611119 614424 706601 722799 726844 732109 734350 736587 738813 739084 745470 748954 752452 759267 759711 760549 761201 761422 763154 766349 767417 775853 776057 777838 778058 779948 784641 784951 786147 787619 796996 797752 798765 800114 800324 802833 804787 806179 807122 809686 813002 813214 813789 815392 815717 815751 815873 815893 819110 820162 823295 823566 826241 827079 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy oil"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy масл"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy масл"
]
|
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.