Query Metrics
7
Database Queries
7
Different statements
149.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.29 ms (81.92%) |
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 45799 96527 172262 188389 382690 384234 385799 396413 404519 406301 406650 409088 411338 412401 414008 414784 416777 418948 418971 420155 420238 420407 428532 428831 430348 434260 435290 442407 443756 444101 444468 449733 452085 453184 453404 453540 453553 453720 454108 454971 455643 456584 456605 457568 459238 459246 459338 459890 459932 460211 460424 461794 462178 462202 464013 464017 466720 469442 469487 470267 471408 471445 473468 476340 476454 476787 481466 483286 485943 492386 492454 493055 495072 496873 497828 498814 509540 512608 513005 515448 515851 516070 517207 520065 521123 524796 528347 528581 530414 546869 549738 572268 582589 584975 586233 588611 589139 589692 591552 591565 592685 596317 597184 602674 604839 606083 607604 615752 617087 621343 622406 622866 662633 665205 672771 673992 687163 708179 770123 806711 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (10.94%) |
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 584975 549738 662633 665205 708179 672771 673992 687163 546869 572268 582589 586233 589139 592685 596317 597184 602674 615752 622406 622866 591552 617087 604839 606083 588611 589692 591565 621343 806711 770123 607604 412401 443756 453184 453404 453540 469487 411338 420238 420407 428532 459238 471408 382690 418948 418971 428831 435290 455643 461794 462178 464017 470267 476454 476787 481466 188389 396413 409088 420155 454108 457568 406650 430348 453720 460211 473468 515448 516070 485943 497828 498814 509540 517207 483286 515851 524796 492386 493055 521123 528581 385799 384234 172262 45799 96527 404519 406301 414008 414784 416777 444101 444468 442407 434260 456605 459246 466720 469442 471445 453553 454971 456584 459338 460424 462202 464013 476340 449733 452085 459890 459932 492454 495072 512608 530414 496873 513005 520065 528347 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (2.00%) |
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 45799 96527 172262 188389 382690 384234 385799 396413 404519 406301 406650 409088 411338 412401 414008 414784 416777 418948 418971 420155 420238 420407 428532 428831 430348 434260 435290 442407 443756 444101 444468 449733 452085 453184 453404 453540 453553 453720 454108 454971 455643 456584 456605 457568 459238 459246 459338 459890 459932 460211 460424 461794 462178 462202 464013 464017 466720 469442 469487 470267 471408 471445 473468 476340 476454 476787 481466 483286 485943 492386 492454 493055 495072 496873 497828 498814 509540 512608 513005 515448 515851 516070 517207 520065 521123 524796 528347 528581 530414 546869 549738 572268 582589 584975 586233 588611 589139 589692 591552 591565 592685 596317 597184 602674 604839 606083 607604 615752 617087 621343 622406 622866 662633 665205 672771 673992 687163 708179 770123 806711 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen boobs"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн boobs"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кухн boobs"
]
|
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.