Query Metrics
7
Database Queries
7
Different statements
163.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.75 ms (86.19%) |
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 24149 402062 413143 414865 418323 422757 422762 423134 424615 425806 428262 429375 435507 443602 443845 446858 447797 448658 453247 454741 455965 456005 456700 458617 460025 469804 478431 478452 483809 485302 485576 492622 498990 500570 501252 509776 511489 515749 517780 518011 519769 529822 531554 533295 533431 534055 539299 539889 542518 544712 544885 547099 547541 553782 556365 556373 582863 586900 586935 590759 591718 591783 595165 596856 598289 604134 608625 622620 623904 637828 638433 642486 645643 645677 646457 647704 649729 649757 649784 658170 658192 672233 673030 687019 701339 712148 712210 715178 720040 722432 728266 738969 744090 746016 746940 751806 752494 754151 754152 759029 760479 766783 771040 780698 784572 785237 796971 797024 797202 798523 801660 803896 809052 810173 824416 825330 825372 825374 826867 827065 ] |
||||||||||||||||||||||||||||||
|
13.30 ms (8.15%) |
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 424615 492622 448658 456005 500570 539299 485302 754151 425806 429375 413143 483809 501252 827065 586935 746016 766783 797024 517780 825372 825374 825330 478452 544885 547541 796971 759029 760479 744090 728266 738969 715178 720040 722432 784572 622620 423134 498990 511489 518011 591783 418323 519769 485576 443602 422762 443845 455965 453247 456700 458617 509776 582863 556365 586900 780698 754152 454741 435507 469804 478431 446858 447797 460025 826867 824416 785237 801660 803896 809052 797202 798523 810173 746940 751806 752494 771040 414865 529822 531554 533295 534055 533431 542518 553782 556373 647704 649729 658170 658192 645677 649757 649784 672233 673030 687019 701339 645643 646457 712148 712210 544712 547099 591718 638433 642486 608625 623904 637828 596856 24149 402062 604134 539889 515749 422757 428262 590759 595165 598289 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.60%) |
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 24149 402062 413143 414865 418323 422757 422762 423134 424615 425806 428262 429375 435507 443602 443845 446858 447797 448658 453247 454741 455965 456005 456700 458617 460025 469804 478431 478452 483809 485302 485576 492622 498990 500570 501252 509776 511489 515749 517780 518011 519769 529822 531554 533295 533431 534055 539299 539889 542518 544712 544885 547099 547541 553782 556365 556373 582863 586900 586935 590759 591718 591783 595165 596856 598289 604134 608625 622620 623904 637828 638433 642486 645643 645677 646457 647704 649729 649757 649784 658170 658192 672233 673030 687019 701339 712148 712210 715178 720040 722432 728266 738969 744090 746016 746940 751806 752494 754151 754152 759029 760479 766783 771040 780698 784572 785237 796971 797024 797202 798523 801660 803896 809052 810173 824416 825330 825372 825374 826867 827065 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian homemade"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.88%) |
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.