Query Metrics
7
Database Queries
7
Different statements
176.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.26 ms (83.79%) |
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 412572 414070 414138 416609 418713 419296 420517 428959 429844 432288 437867 439029 439135 439301 439320 441027 441042 443086 447198 447608 447934 448057 450484 450599 450889 451774 452775 452889 452978 456222 456226 459851 467588 467696 468222 469047 470048 475416 476887 487200 497480 499252 508353 510532 513161 519699 519816 521637 524676 527380 529034 530953 541442 545369 545384 545442 552401 556573 564514 569656 575859 577068 579031 580577 585826 586999 590100 591021 594110 594243 595483 597519 599306 601519 602644 605102 607828 609889 618514 626004 634098 634100 650661 661510 662065 662072 686501 703574 722428 740928 742307 745082 745083 747155 747328 751045 751710 752711 752785 762064 766867 767430 770382 771591 782450 782543 782839 783043 785568 785851 786878 799861 800792 806591 806597 806788 811700 824158 ] |
||||||||||||||||||||||||||||||
|
17.78 ms (10.05%) |
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 783043 469047 513161 448057 594243 412572 447934 470048 450889 661510 770382 530953 618514 601519 437867 519816 545369 579031 591021 634098 782450 450484 414138 747328 594110 418713 416609 524676 577068 456222 468222 452978 456226 467588 467696 439320 447198 452889 450599 497480 585826 475416 519699 575859 580577 703574 650661 722428 564514 599306 597519 590100 626004 806597 811700 740928 751710 767430 782543 799861 742307 752785 745083 766867 800792 552401 428959 605102 569656 419296 545442 541442 630427 806591 762064 439029 439135 441042 529034 824158 499252 527380 556573 686501 662065 662072 586999 634100 602644 785568 782839 786878 751045 752711 771591 745082 747155 607828 609889 785851 806788 459851 595376 414070 508353 439301 432288 521637 487200 510532 420517 429844 441027 452775 476887 447608 545384 595483 443086 451774 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.67%) |
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 412572 414070 414138 416609 418713 419296 420517 428959 429844 432288 437867 439029 439135 439301 439320 441027 441042 443086 447198 447608 447934 448057 450484 450599 450889 451774 452775 452889 452978 456222 456226 459851 467588 467696 468222 469047 470048 475416 476887 487200 497480 499252 508353 510532 513161 519699 519816 521637 524676 527380 529034 530953 541442 545369 545384 545442 552401 556573 564514 569656 575859 577068 579031 580577 585826 586999 590100 591021 594110 594243 595483 597519 599306 601519 602644 605102 607828 609889 618514 626004 634098 634100 650661 661510 662065 662072 686501 703574 722428 740928 742307 745082 745083 747155 747328 751045 751710 752711 752785 762064 766867 767430 770382 771591 782450 782543 782839 783043 785568 785851 786878 799861 800792 806591 806597 806788 811700 824158 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen solo stockings"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen соло чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen соло чулк нижн бел"
]
|
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.