Query Metrics
7
Database Queries
7
Different statements
194.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.15 ms (87.45%) |
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 247538 405832 426256 461636 462590 475655 480744 485389 489071 504044 507269 512371 514691 518919 529868 530614 533405 533424 533766 536190 536821 537506 537650 538167 538170 539345 539637 540500 541187 543586 544974 547037 548473 549483 552149 555528 556564 558157 562704 563997 564032 567114 567200 571157 573177 574992 575980 577273 584080 591704 599521 601590 603374 604922 604926 607481 613040 613527 617388 620047 620185 622841 623331 623951 623961 627218 628035 628523 629843 631708 632311 634645 634691 638186 639578 639888 646165 650446 651805 652310 653087 653135 653963 658539 663824 663844 664252 665939 671694 671696 675880 680530 681939 685317 697483 700733 706597 709242 712120 715439 716549 722959 723082 733924 733930 736008 736104 743508 743634 745857 746453 748605 756369 759680 761956 763586 764128 778300 790476 813851 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (6.92%) |
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 539345 567200 629843 623961 426256 536821 544974 552149 555528 575980 549483 650446 653087 671694 671696 680530 653135 646165 709242 547037 562704 601590 604922 623951 634691 603374 613040 613527 639888 604926 631708 639578 759680 541187 564032 573177 577273 518919 540500 475655 743634 778300 736104 733930 743508 745857 764128 716549 538167 681939 628035 663824 485389 533405 571157 652310 653963 665939 697483 627218 617388 623331 462590 539637 685317 622841 706597 599521 620185 507269 489071 504044 514691 512371 574992 651805 675880 620047 591704 543586 658539 700733 607481 632311 638186 663844 664252 628523 813851 733924 790476 756369 634645 247538 538170 746453 584080 405832 567114 558157 712120 748605 736008 761956 722959 723082 480744 763586 715439 461636 537650 533766 537506 529868 536190 530614 533424 548473 556564 563997 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (1.80%) |
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 247538 405832 426256 461636 462590 475655 480744 485389 489071 504044 507269 512371 514691 518919 529868 530614 533405 533424 533766 536190 536821 537506 537650 538167 538170 539345 539637 540500 541187 543586 544974 547037 548473 549483 552149 555528 556564 558157 562704 563997 564032 567114 567200 571157 573177 574992 575980 577273 584080 591704 599521 601590 603374 604922 604926 607481 613040 613527 617388 620047 620185 622841 623331 623951 623961 627218 628035 628523 629843 631708 632311 634645 634691 638186 639578 639888 646165 650446 651805 652310 653087 653135 653963 658539 663824 663844 664252 665939 671694 671696 675880 680530 681939 685317 697483 700733 706597 709242 712120 715439 716549 722959 723082 733924 733930 736008 736104 743508 743634 745857 746453 748605 756369 759680 761956 763586 764128 778300 790476 813851 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade big"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск большие"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.