Query Metrics
7
Database Queries
7
Different statements
153.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.96 ms (84.50%) |
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 172164 197300 310190 383891 389969 390669 392159 392480 393987 395926 398462 407746 408334 410015 433388 437233 441452 443975 444177 448670 453214 454957 455123 456794 457581 459024 459078 459959 460572 466935 467702 467858 478387 478406 478543 483210 483642 485027 486635 487753 492088 493185 495244 502994 506207 506866 507860 518152 519840 525232 525714 525786 526454 535445 542297 543296 543696 546392 546893 549726 549732 550279 551534 551588 551810 564967 567901 569373 569993 570936 577122 591741 599189 603043 606530 619490 631684 633541 646052 651810 662387 662454 666457 668768 679863 684706 687447 690703 701545 705073 709447 717367 720645 724139 725022 725217 727844 733480 734097 739557 741567 742642 748605 755111 756421 760400 760761 761456 769474 779419 793797 800303 800906 803621 804560 806245 808223 813559 817147 824370 ] |
||||||||||||||||||||||||||||||
|
11.63 ms (7.56%) |
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 800303 705073 603043 813559 808223 806245 606530 407746 755111 535445 492088 760400 507860 310190 756421 395926 550279 549732 577122 668768 793797 502994 172164 687447 760761 393987 734097 619490 817147 725022 551534 542297 487753 483642 717367 519840 392480 739557 518152 725217 543296 742642 769474 779419 525714 701545 493185 383891 761456 525232 569993 197300 454957 631684 466935 467858 483210 804560 410015 662387 662454 720645 478543 727844 448670 459959 733480 408334 564967 800906 478387 506207 684706 591741 543696 599189 551810 546392 690703 633541 457581 485027 443975 453214 666457 679863 392159 437233 389969 433388 398462 803621 724139 567901 526454 748605 506866 459078 525786 646052 546893 741567 456794 459024 709447 486635 390669 551588 441452 455123 495244 460572 478406 570936 651810 549726 569373 467702 444177 824370 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (2.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее сисястые рак…"
]
|
||||||||||||||||||||||||||||||
|
3.28 ms (2.13%) |
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 172164 197300 310190 383891 389969 390669 392159 392480 393987 395926 398462 407746 408334 410015 433388 437233 441452 443975 444177 448670 453214 454957 455123 456794 457581 459024 459078 459959 460572 466935 467702 467858 478387 478406 478543 483210 483642 485027 486635 487753 492088 493185 495244 502994 506207 506866 507860 518152 519840 525232 525714 525786 526454 535445 542297 543296 543696 546392 546893 549726 549732 550279 551534 551588 551810 564967 567901 569373 569993 570936 577122 591741 599189 603043 606530 619490 631684 633541 646052 651810 662387 662454 666457 668768 679863 684706 687447 690703 701545 705073 709447 717367 720645 724139 725022 725217 727844 733480 734097 739557 741567 742642 748605 755111 756421 760400 760761 761456 769474 779419 793797 800303 800906 803621 804560 806245 808223 813559 817147 824370 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск большие сиськ рак"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск большие сиськ рак"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.10%) |
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.