Query Metrics
7
Database Queries
7
Different statements
202.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.86 ms (87.42%) |
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 4199 8900 31134 145988 168687 381942 382220 382864 383554 385008 385941 386749 386953 388514 389347 390016 390021 390387 391405 392582 396476 401915 412857 415518 422415 424762 424764 425422 429540 448348 453168 454557 460952 462230 464567 468508 468511 471014 489119 490587 490600 497126 499842 504028 508103 510924 510925 512892 513450 529393 536468 536567 538474 606515 617568 631459 634934 697219 700804 709720 710439 717123 724768 725395 725616 726457 726459 728381 729058 730267 730297 730339 733326 734049 734271 736090 738292 740912 741058 743268 744182 744208 744773 744989 745320 755414 756620 759701 760170 768153 773621 774663 774665 776464 776469 776842 778058 783348 789265 789704 790388 794408 794428 794430 794585 794676 794700 800737 803363 804028 804251 808464 809907 810057 810100 810136 811887 824127 824225 824959 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (6.99%) |
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 631459 774665 776469 783348 789704 790388 794408 794585 794676 811887 774663 776842 789265 794428 794700 808464 724768 725616 729058 733326 738292 741058 744208 794430 803363 804251 810100 730267 734271 744773 745320 759701 725395 726457 726459 728381 744989 755414 756620 744182 760170 730297 730339 734049 736090 740912 743268 768153 773621 606515 617568 634934 697219 700804 709720 710439 717123 776464 778058 800737 804028 809907 810057 810136 386953 392582 412857 168687 390016 471014 424764 382864 415518 422415 448348 468508 490600 504028 489119 385941 382220 388514 824127 824225 824959 383554 386749 385008 145988 381942 31134 8900 4199 389347 390021 391405 390387 396476 401915 429540 424762 425422 468511 490587 454557 464567 453168 460952 462230 510924 510925 512892 529393 497126 499842 538474 508103 536468 536567 513450 ] |
||||||||||||||||||||||||||||||
|
4.24 ms (2.10%) |
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 4199 8900 31134 145988 168687 381942 382220 382864 383554 385008 385941 386749 386953 388514 389347 390016 390021 390387 391405 392582 396476 401915 412857 415518 422415 424762 424764 425422 429540 448348 453168 454557 460952 462230 464567 468508 468511 471014 489119 490587 490600 497126 499842 504028 508103 510924 510925 512892 513450 529393 536468 536567 538474 606515 617568 631459 634934 697219 700804 709720 710439 717123 724768 725395 725616 726457 726459 728381 729058 730267 730297 730339 733326 734049 734271 736090 738292 740912 741058 743268 744182 744208 744773 744989 745320 755414 756620 759701 760170 768153 773621 774663 774665 776464 776469 776842 778058 783348 789265 789704 790388 794408 794428 794430 794585 794676 794700 800737 803363 804028 804251 808464 809907 810057 810100 810136 811887 824127 824225 824959 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy but"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.74%) |
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.