Query Metrics
7
Database Queries
7
Different statements
244.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.68 ms (87.93%) |
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 16776 31490 96341 100075 212873 231163 383734 390858 395609 395896 396647 396654 397995 398390 398655 399209 400962 401273 402771 404059 404366 404746 411769 413137 414361 417476 418332 419248 419861 421797 422576 422985 423653 424663 429036 429181 433694 437707 443903 445900 447471 447858 447913 449109 449434 450779 454444 458414 462208 462583 464111 464925 466921 467372 467604 470847 472251 472705 473291 474385 475804 478853 480420 482794 485600 486643 492509 494339 495270 500077 504145 506844 510858 512088 519935 519947 519977 521361 521459 522079 526037 526111 528788 538358 542961 549575 550051 558064 561929 565542 569427 570061 571268 573743 575819 580237 581660 584537 591600 591673 598545 598625 599400 600516 606822 611661 612023 616994 624799 636750 646244 661570 713840 721551 747461 747858 757976 766524 784260 804377 ] |
||||||||||||||||||||||||||||||
|
20.95 ms (8.58%) |
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 462583 474385 398390 411769 429036 449109 464925 472705 414361 450779 485600 486643 521361 492509 504145 506844 526037 526111 538358 522079 464111 231163 16776 467372 573743 713840 600516 747858 804377 766524 747461 757976 612023 784260 390858 402771 399209 542961 528788 606822 598545 565542 611661 467604 424663 462208 519977 31490 96341 396654 396647 418332 429181 419248 423653 447913 458414 482794 445900 449434 472251 519947 661570 558064 591673 599400 624799 598625 400962 466921 475804 519935 521459 395896 398655 401273 443903 413137 447471 454444 510858 447858 404746 500077 512088 494339 616994 404366 433694 422576 417476 569427 575819 549575 580237 584537 721551 550051 561929 570061 581660 591600 397995 404059 480420 478853 395609 470847 422985 495270 419861 421797 383734 473291 571268 646244 636750 100075 437707 212873 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.91%) |
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 16776 31490 96341 100075 212873 231163 383734 390858 395609 395896 396647 396654 397995 398390 398655 399209 400962 401273 402771 404059 404366 404746 411769 413137 414361 417476 418332 419248 419861 421797 422576 422985 423653 424663 429036 429181 433694 437707 443903 445900 447471 447858 447913 449109 449434 450779 454444 458414 462208 462583 464111 464925 466921 467372 467604 470847 472251 472705 473291 474385 475804 478853 480420 482794 485600 486643 492509 494339 495270 500077 504145 506844 510858 512088 519935 519947 519977 521361 521459 522079 526037 526111 528788 538358 542961 549575 550051 558064 561929 565542 569427 570061 571268 573743 575819 580237 581660 584537 591600 591673 598545 598625 599400 600516 606822 611661 612023 616994 624799 636750 646244 661570 713840 721551 747461 747858 757976 766524 784260 804377 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин жоп"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин жоп"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man ass"
]
|
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.