Query Metrics
7
Database Queries
7
Different statements
205.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.25 ms (86.82%) |
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 177455 384238 386709 389923 390575 392422 400760 401799 404693 407124 410590 413649 414177 419452 425820 428488 428761 430436 432644 432698 432704 442128 442544 446038 446964 448522 448821 448839 451246 452097 452354 452568 452813 454931 458530 458922 464005 466700 468499 473533 475410 475702 480719 483709 491584 497473 498619 499931 500772 502043 515009 517779 519219 524262 528044 530494 531123 532789 532989 533018 540333 540339 542422 544668 545470 550579 550672 552699 555759 574432 574657 580225 584759 585323 589349 590854 590884 594925 597840 598105 607742 623196 628091 628126 628641 638967 640706 650174 650187 654914 666538 729818 731105 735057 743383 748053 752080 756212 760367 779840 787336 787506 792655 795398 797075 799190 802182 808579 809009 809039 811298 814777 814890 814924 815204 824953 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (8.23%) |
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 574432 585323 594925 589349 607742 597840 640706 802182 809009 809039 731105 795398 811298 748053 743383 752080 787336 799190 428488 555759 452813 432698 532789 531123 502043 177455 442544 432644 442128 814924 448522 473533 452354 533018 524262 550672 650187 628641 792655 779840 729818 735057 756212 458922 458530 497473 542422 666538 413649 797075 517779 410590 824953 760367 815204 452568 532989 528044 540333 590854 400760 464005 451246 386709 590884 552699 390575 432704 814777 530494 584759 650174 808579 419452 475410 446038 407124 446964 466700 598105 475702 384238 814890 519219 483709 550579 545470 628091 430436 454931 499931 574657 787506 448821 480719 540339 544668 491584 498619 515009 500772 392422 428761 623196 580225 628126 638967 448839 654914 414177 404693 401799 389923 425820 452097 468499 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.40%) |
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 177455 384238 386709 389923 390575 392422 400760 401799 404693 407124 410590 413649 414177 419452 425820 428488 428761 430436 432644 432698 432704 442128 442544 446038 446964 448522 448821 448839 451246 452097 452354 452568 452813 454931 458530 458922 464005 466700 468499 473533 475410 475702 480719 483709 491584 497473 498619 499931 500772 502043 515009 517779 519219 524262 528044 530494 531123 532789 532989 533018 540333 540339 542422 544668 545470 550579 550672 552699 555759 574432 574657 580225 584759 585323 589349 590854 590884 594925 597840 598105 607742 623196 628091 628126 628641 638967 640706 650174 650187 654914 666538 729818 731105 735057 743383 748053 752080 756212 760367 779840 787336 787506 792655 795398 797075 799190 802182 808579 809009 809039 811298 814777 814890 814924 815204 824953 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina dildo"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская дилд"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская дилд"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.