Query Metrics
7
Database Queries
7
Different statements
189.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.52 ms (85.72%) |
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 10006 53396 382411 384795 385141 399369 412492 418345 419196 430310 436304 438411 453497 459965 461120 464310 466602 467951 468958 469204 469853 477737 477874 480992 483129 484367 484744 485165 485744 486027 488514 489385 491657 494688 498697 499241 499418 503220 508345 509257 510149 512513 512805 516637 517634 520263 521587 527393 527995 535465 536275 536801 541099 542818 542831 544187 544205 549228 550402 550465 555882 556063 557439 558902 560684 566573 577896 584380 585048 587487 594224 596347 601763 602046 604823 609078 609420 613757 619389 631697 634565 649845 650192 652121 676973 677681 678915 700451 704039 708468 716858 717131 720253 721554 722625 731869 736046 736281 739517 748326 748551 748980 751563 754222 759529 759599 760068 767103 767208 775195 782556 784569 784938 785534 792059 801795 802362 802412 806566 809381 ] |
||||||||||||||||||||||||||||||
|
16.11 ms (8.50%) |
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 792059 802412 785534 748551 767208 806566 748980 751563 759599 759529 767103 754222 601763 613757 700451 704039 717131 775195 801795 412492 469853 453497 508345 499418 384795 382411 53396 10006 418345 430310 585048 459965 461120 485744 480992 488514 466602 477737 477874 512805 536275 516637 521587 494688 499241 512513 535465 498697 517634 527393 536801 467951 489385 541099 542831 544187 549228 550465 556063 544205 557439 560684 584380 542818 550402 566573 577896 649845 650192 677681 720253 676973 678915 716858 721554 652121 708468 555882 558902 604823 596347 609078 619389 631697 634565 587487 594224 602046 609420 784938 736046 736281 739517 760068 782556 784569 731869 748326 722625 802362 809381 419196 438411 464310 469204 385141 399369 468958 503220 510149 520263 485165 527995 483129 484744 486027 491657 509257 484367 436304 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.75%) |
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 10006 53396 382411 384795 385141 399369 412492 418345 419196 430310 436304 438411 453497 459965 461120 464310 466602 467951 468958 469204 469853 477737 477874 480992 483129 484367 484744 485165 485744 486027 488514 489385 491657 494688 498697 499241 499418 503220 508345 509257 510149 512513 512805 516637 517634 520263 521587 527393 527995 535465 536275 536801 541099 542818 542831 544187 544205 549228 550402 550465 555882 556063 557439 558902 560684 566573 577896 584380 585048 587487 594224 596347 601763 602046 604823 609078 609420 613757 619389 631697 634565 649845 650192 652121 676973 677681 678915 700451 704039 708468 716858 717131 720253 721554 722625 731869 736046 736281 739517 748326 748551 748980 751563 754222 759529 759599 760068 767103 767208 775195 782556 784569 784938 785534 792059 801795 802362 802412 806566 809381 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пробуют"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"проб"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"проб"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.90%) |
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.