Query Metrics
7
Database Queries
7
Different statements
222.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.78 ms (89.29%) |
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 12090 397075 397093 398160 402673 406206 407462 409150 410076 411913 413309 414938 418968 423947 439628 444593 447146 447486 448876 452284 465902 475146 476962 492455 508487 516077 518406 521850 523538 543185 555379 558572 559801 561123 564154 565167 576667 576689 590103 597841 601547 604589 621756 628593 642323 643013 653757 668614 676538 681279 682510 684360 689672 690860 693563 699574 699592 699594 703514 708807 715773 716996 720942 721173 722557 724011 725300 726657 729217 736267 736785 741073 744326 748588 748601 750546 752744 753442 753800 757211 761004 761619 766736 768939 769742 773545 776415 777067 778828 779237 782004 782428 782456 783152 784452 788225 789950 794445 794958 795183 795822 798095 798945 799948 802059 806233 808798 808915 809403 816420 816782 817190 819410 819855 819995 822207 823018 824050 825884 826972 ] |
||||||||||||||||||||||||||||||
|
14.21 ms (6.38%) |
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 597841 761004 643013 444593 439628 465902 476962 414938 447146 448876 447486 779237 808798 452284 518406 521850 523538 508487 558572 565167 576689 555379 559801 621756 492455 681279 410076 418968 684360 413309 12090 397075 397093 407462 409150 411913 817190 822207 816782 824050 816420 819410 819855 819995 823018 825884 826972 543185 561123 564154 576667 676538 690860 693563 721173 699574 699594 722557 653757 668614 682510 689672 699592 708807 590103 642323 601547 628593 776415 782004 788225 795183 777067 798095 809403 725300 750546 753800 784452 789950 794958 806233 808915 729217 736267 748588 748601 752744 768939 769742 724011 766736 773545 726657 753442 736785 741073 744326 757211 761619 604589 703514 715773 716996 720942 778828 782428 782456 783152 794445 795822 798945 799948 802059 398160 475146 402673 423947 516077 406206 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.36%) |
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 12090 397075 397093 398160 402673 406206 407462 409150 410076 411913 413309 414938 418968 423947 439628 444593 447146 447486 448876 452284 465902 475146 476962 492455 508487 516077 518406 521850 523538 543185 555379 558572 559801 561123 564154 565167 576667 576689 590103 597841 601547 604589 621756 628593 642323 643013 653757 668614 676538 681279 682510 684360 689672 690860 693563 699574 699592 699594 703514 708807 715773 716996 720942 721173 722557 724011 725300 726657 729217 736267 736785 741073 744326 748588 748601 750546 752744 753442 753800 757211 761004 761619 766736 768939 769742 773545 776415 777067 778828 779237 782004 782428 782456 783152 784452 788225 789950 794445 794958 795183 795822 798095 798945 799948 802059 806233 808798 808915 809403 816420 816782 817190 819410 819855 819995 822207 823018 824050 825884 826972 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking sperm"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза сперм"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.