Query Metrics
7
Database Queries
7
Different statements
145.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.15 ms (82.77%) |
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 218622 270104 387130 388440 388825 391017 391070 394035 412855 416675 417109 417554 418743 419133 423585 423593 425895 436844 441027 441818 445423 449466 453583 459897 463015 465169 466417 473334 479032 480815 508226 509627 510190 510907 525861 528533 532774 535350 535947 537502 537836 538093 539372 545478 553890 559188 566396 566428 568047 580525 592110 594905 606555 612007 621040 623397 632143 633308 644448 659199 663749 675869 682712 697843 708838 710289 717163 717196 718118 727987 732224 734541 738727 740194 741133 741855 744354 744371 748443 751822 752308 752520 753124 760659 766190 767102 768659 770073 774064 783466 783949 789812 791042 792912 795422 795771 796077 797010 800897 801160 811925 814716 818150 818298 818315 819173 819366 819408 819956 823755 823801 824595 826313 826742 828312 828631 828643 828768 828786 ] |
||||||||||||||||||||||||||||||
|
14.06 ms (9.68%) |
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 753124 783466 801160 752308 751822 768659 741855 748443 760659 644448 791042 792912 797010 480815 459897 418743 423585 423593 425895 441818 417109 509627 789812 412855 391070 528533 818298 823755 828643 828631 537502 566428 592110 744354 741133 388825 473334 479032 449466 508226 568047 559188 659199 663749 621040 632143 388440 436844 445423 466417 463015 510190 416675 537836 744371 419133 525861 814716 682712 675869 697843 710289 718118 633308 594905 623397 795422 811925 795771 752520 768810 770073 717196 783949 800897 819173 828768 828786 218622 734541 819366 545478 553890 532774 766190 465169 510907 538093 539372 387130 818150 823801 818315 819956 826313 828312 826742 535947 566396 612007 774064 732224 708838 727987 767102 606555 441027 453583 394035 417554 819408 535350 580525 796077 738727 270104 824595 740194 391017 717163 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.96%) |
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 218622 270104 387130 388440 388825 391017 391070 394035 412855 416675 417109 417554 418743 419133 423585 423593 425895 436844 441027 441818 445423 449466 453583 459897 463015 465169 466417 473334 479032 480815 508226 509627 510190 510907 525861 528533 532774 535350 535947 537502 537836 538093 539372 545478 553890 559188 566396 566428 568047 580525 592110 594905 606555 612007 621040 623397 632143 633308 644448 659199 663749 675869 682712 697843 708838 710289 717163 717196 718118 727987 732224 734541 738727 740194 741133 741855 744354 744371 748443 751822 752308 752520 753124 760659 766190 767102 768659 770073 774064 783466 783949 789812 791042 792912 795422 795771 796077 797010 800897 801160 811925 814716 818150 818298 818315 819173 819366 819408 819956 823755 823801 824595 826313 826742 828312 828631 828643 828768 828786 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding big ass"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding большая большие жоп"
]
|
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.