Query Metrics
7
Database Queries
7
Different statements
187.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.55 ms (86.11%) |
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 402965 418254 422450 424497 426094 440581 457149 457338 469720 474050 474394 480091 482585 484398 485378 488951 490114 499417 502491 507856 511996 512749 513953 520185 522317 523073 530855 530867 533510 535100 545945 547623 547910 553722 555743 557946 570991 598204 603663 615100 618744 623107 640776 648475 649087 650284 659066 660435 661333 662894 670919 674615 675906 676345 677460 680030 680590 681501 687150 689520 696989 697513 701199 710302 722070 723964 729217 729220 729284 732791 736267 741073 750546 750644 756458 757167 758247 758816 761267 761273 762812 764184 764807 767040 767479 767996 770348 770679 771782 775402 779914 780300 786065 786122 787691 788217 788299 788799 790460 790828 792215 794958 795385 796825 796958 796964 797250 799657 801619 803038 804053 808091 809359 809403 813100 813161 824123 827152 827269 827370 ] |
||||||||||||||||||||||||||||||
|
15.14 ms (8.07%) |
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 623107 689520 687150 512749 557946 603663 598204 457149 522317 484398 640776 422450 426094 824123 827370 545945 555743 570991 676345 662894 675906 680030 775402 780300 790828 788299 796958 809403 723964 750546 757167 813100 729217 736267 764807 767040 729220 729284 758816 762812 764184 732791 741073 750644 756458 770348 770679 771782 697513 779914 786065 787691 788799 804053 418254 474050 511996 490114 502491 507856 469720 530855 535100 650284 661333 670919 677460 701199 681501 659066 660435 618744 767996 710302 680590 533510 474394 440581 513953 485378 488951 499417 722070 790460 457338 520185 674615 696989 547910 615100 801619 758247 796964 402965 523073 424497 827152 827269 547623 480091 530867 482585 553722 648475 649087 792215 795385 786122 788217 796825 797250 808091 813161 767479 794958 799657 803038 809359 761267 761273 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.85%) |
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 402965 418254 422450 424497 426094 440581 457149 457338 469720 474050 474394 480091 482585 484398 485378 488951 490114 499417 502491 507856 511996 512749 513953 520185 522317 523073 530855 530867 533510 535100 545945 547623 547910 553722 555743 557946 570991 598204 603663 615100 618744 623107 640776 648475 649087 650284 659066 660435 661333 662894 670919 674615 675906 676345 677460 680030 680590 681501 687150 689520 696989 697513 701199 710302 722070 723964 729217 729220 729284 732791 736267 741073 750546 750644 756458 757167 758247 758816 761267 761273 762812 764184 764807 767040 767479 767996 770348 770679 771782 775402 779914 780300 786065 786122 787691 788217 788299 788799 790460 790828 792215 794958 795385 796825 796958 796964 797250 799657 801619 803038 804053 808091 809359 809403 813100 813161 824123 827152 827269 827370 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade facesitting"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск фейсситтинг"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.