Query Metrics
7
Database Queries
7
Different statements
222.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.63 ms (86.50%) |
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 3523 37730 76649 117479 338565 381784 396636 396836 397175 398009 400006 400469 402373 409621 415092 420233 421238 429202 431483 436539 437417 447180 449108 449499 449800 451725 455518 458119 460211 460611 461325 466615 469646 473071 473417 478715 480009 481701 488282 488637 507993 508104 508397 508563 513885 519427 519502 525448 528122 533383 533387 546893 550345 557543 558203 568926 577689 585133 588878 591841 596584 607167 625247 625800 637430 637554 647844 654346 654353 677919 690618 691180 698207 698468 704204 704212 722794 722906 732457 735405 746071 746090 746573 751152 751173 755765 770356 772150 773929 778372 778954 779845 781416 782130 785280 785448 787156 787403 788039 788163 788730 790618 791074 795343 797032 797565 797595 799648 800109 800295 800319 803327 806263 807472 807521 809004 810203 812958 818092 823447 ] |
||||||||||||||||||||||||||||||
|
15.95 ms (7.16%) |
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 770356 773929 722794 787403 3523 415092 449108 533383 550345 654353 698207 698468 785280 797565 778954 797032 751173 806263 772150 625800 117479 436539 807472 807521 488282 396636 455518 568926 447180 461325 528122 591841 625247 596584 800319 751152 746090 637554 778372 812958 400006 431483 396836 480009 513885 519427 557543 800295 797595 803327 508104 704212 381784 460211 488637 429202 451725 588878 400469 469646 508563 519502 607167 76649 823447 460611 533387 546893 558203 690618 691180 637430 735405 746071 746573 791074 800109 722906 402373 338565 397175 409621 481701 437417 585133 458119 473071 647844 704204 473417 508397 525448 507993 818092 449800 677919 788730 790618 779845 785448 755765 782130 788163 799648 810203 781416 787156 795343 37730 398009 449499 478715 466615 577689 654346 788039 809004 732457 420233 421238 ] |
||||||||||||||||||||||||||||||
|
5.85 ms (2.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.45%) |
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 3523 37730 76649 117479 338565 381784 396636 396836 397175 398009 400006 400469 402373 409621 415092 420233 421238 429202 431483 436539 437417 447180 449108 449499 449800 451725 455518 458119 460211 460611 461325 466615 469646 473071 473417 478715 480009 481701 488282 488637 507993 508104 508397 508563 513885 519427 519502 525448 528122 533383 533387 546893 550345 557543 558203 568926 577689 585133 588878 591841 596584 607167 625247 625800 637430 637554 647844 654346 654353 677919 690618 691180 698207 698468 704204 704212 722794 722906 732457 735405 746071 746090 746573 751152 751173 755765 770356 772150 773929 778372 778954 779845 781416 782130 785280 785448 787156 787403 788039 788163 788730 790618 791074 795343 797032 797565 797595 799648 800109 800295 800319 803327 806263 807472 807521 809004 810203 812958 818092 823447 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie beautiful girl"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie красивая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie красивая девушк"
]
|
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.