Query Metrics
7
Database Queries
7
Different statements
252.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
223.51 ms (88.39%) |
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 373950 399861 420517 426359 426362 431335 431514 432288 432297 436139 436735 442573 446796 447532 447549 447560 447914 448210 449320 450722 452268 457495 462377 464842 467929 468189 468724 472114 474322 476448 478044 482087 483739 487197 487202 488153 490268 491190 491839 495014 496042 497301 498520 499765 499812 500504 500694 501734 502499 502703 504700 504765 508838 509322 511078 512440 515847 516782 517454 518366 520740 521119 521855 522280 522463 522724 524203 524400 526564 526593 528041 528768 529244 530507 536738 544992 545009 548582 554288 555510 558786 559295 564385 564772 565170 569567 569668 571245 576301 578685 579098 579312 580702 583254 583654 584794 586734 589400 590174 591867 593966 594460 597750 598118 598193 598858 602829 603168 603835 609890 611479 619165 621171 621650 648593 676492 680206 680859 ] |
||||||||||||||||||||||||||||||
|
18.60 ms (7.36%) |
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 457495 509322 521119 490268 487202 491839 496042 522463 491190 511078 521855 373950 399861 436139 446796 448210 474322 482087 447914 468724 497689 512440 499765 499812 504765 524400 536738 502499 515847 554288 559295 569567 548582 564385 576301 541345 555510 580702 583254 680859 578685 584794 590174 597750 609890 611479 591867 594460 621650 593966 598193 598858 621171 436735 462377 467929 468189 426359 447549 450722 420517 447532 452268 431335 449320 464842 472114 526593 529244 483739 488153 498520 432297 442573 487197 478044 518366 502703 516782 528041 500504 501734 528768 522724 524203 476448 545009 583654 564772 571245 676492 680206 648593 565170 569668 579098 579312 603835 619165 589400 603168 586734 598118 602829 447560 431514 432288 426362 495014 520740 522280 526564 504700 497301 500694 508838 517454 530507 544992 558786 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (1.47%) |
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 373950 399861 420517 426359 426362 431335 431514 432288 432297 436139 436735 442573 446796 447532 447549 447560 447914 448210 449320 450722 452268 457495 462377 464842 467929 468189 468724 472114 474322 476448 478044 482087 483739 487197 487202 488153 490268 491190 491839 495014 496042 497301 498520 499765 499812 500504 500694 501734 502499 502703 504700 504765 508838 509322 511078 512440 515847 516782 517454 518366 520740 521119 521855 522280 522463 522724 524203 524400 526564 526593 528041 528768 529244 530507 536738 544992 545009 548582 554288 555510 558786 559295 564385 564772 565170 569567 569668 571245 576301 578685 579098 579312 580702 583254 583654 584794 586734 589400 590174 591867 593966 594460 597750 598118 598193 598858 602829 603168 603835 609890 611479 619165 621171 621650 648593 676492 680206 680859 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"гольфах"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"гольф"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.57%) |
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.