Query Metrics
7
Database Queries
7
Different statements
193.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.17 ms (85.98%) |
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 6968 53396 391113 395849 395856 395975 395981 396691 397883 398201 400689 404939 413057 421562 422582 422593 422947 422958 422960 422987 423261 424622 429898 445833 446740 447888 448033 454840 461569 463936 463937 468085 476957 481760 489120 490143 512973 522949 523985 524322 532644 533516 536615 545698 550228 554639 558131 571211 571218 571229 571847 572763 590542 594261 596161 597267 598069 599946 603394 605322 605328 605330 607314 612363 620205 623413 629560 635968 636269 637436 640427 641682 646824 651161 667904 678954 683955 684200 695316 704212 705320 705878 708468 709688 714448 717906 720677 721554 721999 722645 722781 732001 733295 733862 736663 737408 741289 741310 742434 744259 744753 747398 747448 747534 749338 753486 758615 760007 760967 760975 761585 766687 777140 784247 790867 793901 797733 810032 810689 813526 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (8.75%) |
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 554639 623413 532644 620205 404939 422582 422947 448033 463937 447888 476957 395981 429898 395856 489120 524322 612363 422958 446740 571847 558131 590542 454840 421562 481760 463936 461569 490143 512973 523985 733862 422960 550228 572763 545698 445833 522949 395849 395975 53396 6968 398201 423261 424622 413057 422987 422593 468085 533516 536615 571211 571218 571229 667904 678954 705878 720677 684200 705320 709688 721554 646824 651161 683955 695316 708468 722645 598069 599946 641682 635968 636269 637436 594261 596161 607314 629560 597267 603394 605322 605328 605330 784247 810689 777140 793901 797733 813526 737408 744753 753486 761585 766687 810032 741289 747448 749338 736663 747534 732001 733295 741310 744259 747398 760967 742434 758615 760007 760975 640427 704212 714448 717906 721999 722781 790867 391113 396691 397883 400689 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.72%) |
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 6968 53396 391113 395849 395856 395975 395981 396691 397883 398201 400689 404939 413057 421562 422582 422593 422947 422958 422960 422987 423261 424622 429898 445833 446740 447888 448033 454840 461569 463936 463937 468085 476957 481760 489120 490143 512973 522949 523985 524322 532644 533516 536615 545698 550228 554639 558131 571211 571218 571229 571847 572763 590542 594261 596161 597267 598069 599946 603394 605322 605328 605330 607314 612363 620205 623413 629560 635968 636269 637436 640427 641682 646824 651161 667904 678954 683955 684200 695316 704212 705320 705878 708468 709688 714448 717906 720677 721554 721999 722645 722781 732001 733295 733862 736663 737408 741289 741310 742434 744259 744753 747398 747448 747534 749338 753486 758615 760007 760967 760975 761585 766687 777140 784247 790867 793901 797733 810032 810689 813526 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man anal"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин анал"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин анал"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.78%) |
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.