Query Metrics
7
Database Queries
7
Different statements
194.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.74 ms (85.81%) |
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 152508 411730 413170 413714 413716 423516 424419 429483 451712 453134 453999 454184 460980 462210 462654 469903 480481 485758 486384 492757 504886 509417 512031 518152 518843 520293 524488 525720 526672 535321 535898 540370 544754 551031 554524 558005 563648 566231 566588 569388 569728 575610 584728 589824 593098 594853 596322 601022 603340 609045 618302 635786 638302 651794 663921 667264 669201 675956 677270 678221 684977 695151 696316 709309 716274 718834 722536 726954 728172 730847 733545 734693 734725 734837 735460 738266 738901 740545 740965 742714 747607 750554 755411 757253 761385 764507 764524 767913 768884 769158 769562 771211 771867 774421 775895 781704 781743 784143 784297 786179 786575 788791 793811 795409 795867 795915 797240 797262 798573 799503 801408 801896 803645 804813 807002 808238 810037 813801 814616 828708 ] |
||||||||||||||||||||||||||||||
|
18.02 ms (9.27%) |
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 675956 678221 695151 718834 651794 663921 667264 669201 677270 684977 696316 716274 722536 544754 569728 596322 609045 635786 638302 594853 601022 603340 593098 618302 589824 781704 795867 795915 801896 775895 781743 795409 799503 803645 808238 730847 734693 738266 747607 750554 757253 761385 764524 769158 786179 786575 797240 797262 807002 810037 728172 740545 767913 771211 733545 734837 726954 735460 768884 734725 738901 740965 742714 755411 764507 769562 771867 709309 784143 784297 788791 793811 798573 801408 804813 152508 451712 413714 424419 469903 504886 828708 413716 423516 429483 411730 413170 774421 813801 814616 486384 453134 453999 454184 460980 480481 485758 492757 462210 525720 540370 512031 518843 520293 535898 524488 526672 535321 509417 518152 462654 551031 554524 563648 575610 584728 558005 569388 566231 566588 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.19%) |
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 152508 411730 413170 413714 413716 423516 424419 429483 451712 453134 453999 454184 460980 462210 462654 469903 480481 485758 486384 492757 504886 509417 512031 518152 518843 520293 524488 525720 526672 535321 535898 540370 544754 551031 554524 558005 563648 566231 566588 569388 569728 575610 584728 589824 593098 594853 596322 601022 603340 609045 618302 635786 638302 651794 663921 667264 669201 675956 677270 678221 684977 695151 696316 709309 716274 718834 722536 726954 728172 730847 733545 734693 734725 734837 735460 738266 738901 740545 740965 742714 747607 750554 755411 757253 761385 764507 764524 767913 768884 769158 769562 771211 771867 774421 775895 781704 781743 784143 784297 786179 786575 788791 793811 795409 795867 795915 797240 797262 798573 799503 801408 801896 803645 804813 807002 808238 810037 813801 814616 828708 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"блондинка с висячими %…"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая обвисшая"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
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.