Query Metrics
7
Database Queries
7
Different statements
179.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.54 ms (87.76%) |
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 396906 397445 493052 531916 534885 549474 563064 563984 573249 574382 587310 605362 606911 610058 626308 628081 629631 634631 643384 660008 667099 673660 680617 682612 683037 687605 687936 688254 695721 696990 705067 710555 712688 713459 714929 715039 716508 717159 717911 718085 719276 721693 722681 724123 724369 724849 724860 726370 726989 729177 732821 734309 734779 735925 736004 738311 739951 740205 740864 753656 754424 754532 756872 759566 760974 761579 765502 770151 772367 777755 779906 780109 780409 782122 785495 786283 786396 788583 788603 788883 788941 789181 792961 793467 794241 794338 794639 794763 795060 795364 795631 795815 795978 796252 798801 799751 800085 800671 800899 801656 802048 802211 802394 803436 804517 805689 805690 806290 809996 813924 816732 817508 819919 824673 824678 824990 827140 827339 827705 ] |
||||||||||||||||||||||||||||||
|
11.60 ms (6.46%) |
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 682612 721693 702293 587310 606911 788603 795815 798801 800899 801656 794639 795631 735925 761579 809996 732821 765502 739951 740864 760974 726989 756872 717911 777755 780109 789181 794338 795364 799751 802048 634631 805690 816732 819919 824678 827140 827339 827705 817508 824673 813924 824990 493052 534885 531916 573249 574382 549474 563984 563064 680617 688254 710555 716508 683037 687605 687936 714929 722681 660008 667099 673660 695721 712688 717159 718085 628081 629631 605362 643384 786283 786396 800085 804517 779906 788941 795060 795978 796252 800671 802211 805689 734779 736004 754424 754532 782122 785495 788583 793467 794241 803436 806290 734309 740205 753656 724369 724849 729177 724123 724860 726370 770151 772367 759566 610058 626308 696990 705067 713459 715039 719276 780409 788883 792961 794763 802394 397445 738311 396906 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.55%) |
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 396906 397445 493052 531916 534885 549474 563064 563984 573249 574382 587310 605362 606911 610058 626308 628081 629631 634631 643384 660008 667099 673660 680617 682612 683037 687605 687936 688254 695721 696990 705067 710555 712688 713459 714929 715039 716508 717159 717911 718085 719276 721693 722681 724123 724369 724849 724860 726370 726989 729177 732821 734309 734779 735925 736004 738311 739951 740205 740864 753656 754424 754532 756872 759566 760974 761579 765502 770151 772367 777755 779906 780109 780409 782122 785495 786283 786396 788583 788603 788883 788941 789181 792961 793467 794241 794338 794639 794763 795060 795364 795631 795815 795978 796252 798801 799751 800085 800671 800899 801656 802048 802211 802394 803436 804517 805689 805690 806290 809996 813924 816732 817508 819919 824673 824678 824990 827140 827339 827705 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс stepmom"
]
|
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.