Query Metrics
7
Database Queries
7
Different statements
421.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.30 ms (52.47%) |
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 585172 587502 589210 638051 627065 791275 783686 794049 749545 757344 760242 769473 755365 757526 786556 614008 824527 815266 536091 688760 707943 711046 670429 719370 651911 720023 548284 633230 629218 639209 794275 797356 777919 753816 766039 754262 736696 756556 827159 712913 563877 648286 730061 770825 734872 571379 626295 788702 730839 738453 744192 747926 778344 825624 567640 683709 681776 703335 706012 708764 638069 589965 611702 620705 623938 633268 758351 810561 744495 752875 759872 724659 748764 789414 797113 805070 403782 821020 499201 547535 685180 653429 660601 662040 694898 546253 550290 554836 634735 777177 782309 804739 810577 798077 800797 812712 744862 750156 760205 786433 745669 738270 744193 638194 775420 790495 565844 815495 818994 535292 788709 776063 812362 393729 818036 682179 654935 678003 697662 644100 ] |
||||||||||||||||||||||||||||||
|
190.34 ms (45.13%) |
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 393729 403782 499201 535292 536091 546253 547535 548284 550290 554836 563877 565844 567640 571379 585172 587502 589210 589965 611702 614008 620705 623938 626295 627065 629218 633230 633268 634735 638051 638069 638194 639209 644100 648286 651911 653429 654935 660601 662040 670429 678003 681776 682179 683709 685180 688760 694898 697662 703335 706012 707943 708764 711046 712913 719370 720023 724659 730061 730839 734872 736696 738270 738453 744192 744193 744495 744862 745669 747926 748764 749545 750156 752875 753816 754262 755365 756556 757344 757526 758351 759872 760205 766039 769473 770825 775420 776063 777177 777919 778344 782309 783686 786433 786556 788702 788709 789414 790495 791275 794049 794275 797113 797356 798077 800797 804739 805070 810561 810577 812362 812712 815266 815495 818036 818994 821020 824527 825624 827159 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (0.61%) |
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 393729 403782 499201 535292 536091 546253 547535 548284 550290 554836 563877 565844 567640 571379 585172 587502 589210 589965 611702 614008 620705 623938 626295 627065 629218 633230 633268 634735 638051 638069 638194 639209 644100 648286 651911 653429 654935 660601 662040 670429 678003 681776 682179 683709 685180 688760 694898 697662 703335 706012 707943 708764 711046 712913 719370 720023 724659 730061 730839 734872 736696 738270 738453 744192 744193 744495 744862 745669 747926 748764 749545 750156 752875 753816 754262 755365 756556 757344 757526 758351 759872 760205 766039 769473 770825 775420 776063 777177 777919 778344 782309 783686 786433 786556 788702 788709 789414 790495 791275 794049 794275 797113 797356 798077 800797 804739 805070 810561 810577 812362 812712 815266 815495 818036 818994 821020 824527 825624 827159 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"good girl"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"good девушк"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"good девушк"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.38%) |
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.