Query Metrics
7
Database Queries
7
Different statements
181.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.97 ms (84.52%) |
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 129640 186858 191698 390051 391581 391666 391931 409152 418954 425578 426416 429552 441068 443744 445401 445661 446109 448968 449691 450377 453441 454415 456312 456611 458312 460172 467348 469150 469300 469472 474461 478617 479522 483628 492643 493174 493191 493229 496041 506278 507144 514445 523136 523590 525561 530325 531836 537576 538007 543135 543680 546617 554888 555226 560699 562357 563066 563232 563830 569145 570972 576540 580283 589659 591910 599998 601076 604208 624936 629739 629971 663937 673791 692704 700818 702551 714539 714655 718581 723659 726606 731552 734309 737049 740567 745335 753656 759009 760690 761246 768394 771145 771730 775064 779599 788031 790337 791332 794872 795960 797175 797345 797500 801451 801912 804153 805635 805689 814678 815912 816508 816932 817181 820134 823933 826710 826938 828472 828520 828874 ] |
||||||||||||||||||||||||||||||
|
16.87 ms (9.32%) |
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 530325 555226 663937 629971 629739 797500 791332 456611 624936 429552 523590 563066 426416 714655 589659 599998 601076 775064 794872 797175 779599 391581 525561 469300 460172 469150 591910 456312 391931 543680 814678 554888 692704 700818 702551 801912 740567 760690 771730 446109 537576 469472 483628 191698 828520 828472 563830 788031 771145 506278 453441 443744 445401 563232 673791 479522 458312 493191 493174 514445 538007 129640 445661 474461 391666 441068 449691 493229 448968 467348 560699 562357 797345 805635 478617 523136 496041 492643 543135 761246 714539 801451 726606 828874 450377 454415 425578 569145 418954 570972 718581 186858 815912 816508 759009 390051 820134 823933 546617 804153 790337 745335 409152 723659 826710 817181 826938 816932 507144 531836 580283 576540 604208 805689 737049 795960 734309 753656 768394 731552 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.04%) |
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 129640 186858 191698 390051 391581 391666 391931 409152 418954 425578 426416 429552 441068 443744 445401 445661 446109 448968 449691 450377 453441 454415 456312 456611 458312 460172 467348 469150 469300 469472 474461 478617 479522 483628 492643 493174 493191 493229 496041 506278 507144 514445 523136 523590 525561 530325 531836 537576 538007 543135 543680 546617 554888 555226 560699 562357 563066 563232 563830 569145 570972 576540 580283 589659 591910 599998 601076 604208 624936 629739 629971 663937 673791 692704 700818 702551 714539 714655 718581 723659 726606 731552 734309 737049 740567 745335 753656 759009 760690 761246 768394 771145 771730 775064 779599 788031 790337 791332 794872 795960 797175 797345 797500 801451 801912 804153 805635 805689 814678 815912 816508 816932 817181 820134 823933 826710 826938 828472 828520 828874 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom mother"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.