Query Metrics
7
Database Queries
7
Different statements
147.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.03 ms (84.67%) |
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 398582 409613 412092 415834 415835 418883 425574 431487 433920 439487 440798 440805 440857 440859 440947 441342 442463 444601 446181 446649 455377 459073 459102 463636 481238 482774 482906 482922 485343 485420 486820 490968 492337 494963 498909 504805 505578 507456 509437 509907 511187 518155 518329 520490 520608 521377 521991 522963 523007 524888 525867 537815 545848 547874 547903 548373 552211 552234 552697 553921 557718 558582 564132 566296 567600 577553 581228 583558 584861 585099 591214 591452 593785 594282 594448 595114 598623 600227 604221 604861 608512 609709 610309 611037 612268 622856 623961 624838 624990 631503 635050 641059 671220 674355 674907 679657 693227 700299 701917 704187 715129 716675 718044 718811 724633 729239 737361 751958 759738 761088 762739 762743 790136 790188 792599 794680 795075 800028 804877 812299 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (9.27%) |
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 762739 715129 718811 485343 425574 415835 800028 440947 505578 623961 674907 612268 795075 724633 790188 594448 608512 594282 674355 598623 566296 584861 525867 693227 701917 567600 790136 548373 751958 441342 804877 521991 439487 459073 523007 604861 812299 794680 409613 459102 481238 511187 610309 440805 509907 547903 759738 492337 583558 700299 704187 671220 718044 737361 729239 482922 442463 600227 604221 446649 463636 486820 611037 440798 431487 440859 520608 762743 398582 509437 622856 716675 552211 518329 494963 679657 595114 635050 485420 507456 524888 558582 581228 552697 631503 504805 520490 537815 609709 482774 545848 455377 482906 593785 518155 444601 522963 577553 440857 557718 418883 553921 591452 641059 624838 624990 761088 585099 412092 498909 591214 547874 564132 415834 433920 490968 552234 521377 792599 446181 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.61%) |
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 398582 409613 412092 415834 415835 418883 425574 431487 433920 439487 440798 440805 440857 440859 440947 441342 442463 444601 446181 446649 455377 459073 459102 463636 481238 482774 482906 482922 485343 485420 486820 490968 492337 494963 498909 504805 505578 507456 509437 509907 511187 518155 518329 520490 520608 521377 521991 522963 523007 524888 525867 537815 545848 547874 547903 548373 552211 552234 552697 553921 557718 558582 564132 566296 567600 577553 581228 583558 584861 585099 591214 591452 593785 594282 594448 595114 598623 600227 604221 604861 608512 609709 610309 611037 612268 622856 623961 624838 624990 631503 635050 641059 671220 674355 674907 679657 693227 700299 701917 704187 715129 716675 718044 718811 724633 729239 737361 751958 759738 761088 762739 762743 790136 790188 792599 794680 795075 800028 804877 812299 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real домашн любительск couple"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real homemade couple"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real домашн любительск couple"
]
|
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.