Query Metrics
7
Database Queries
7
Different statements
224.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.60 ms (87.15%) |
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 96527 172262 188389 382239 385356 387785 393778 396287 396413 404289 404519 406650 409088 411338 411342 412401 414008 418948 418971 420155 422269 426007 428393 428532 428831 430348 432249 435290 443708 443756 443757 444101 444135 452085 452333 453184 453404 453540 453553 453679 454108 454971 455320 455643 455950 456605 457769 457974 458732 458759 459238 459338 459890 459932 460174 464017 466720 469487 470267 471408 471445 473492 473858 476454 476780 481466 487007 492454 492905 496754 497428 497828 499904 502811 506060 509540 511311 511488 515384 515448 515851 516070 517207 519680 520673 524796 528581 540553 544189 546869 546960 559057 565754 566117 566765 571820 572268 584975 588611 589139 589692 591552 591565 592685 596317 602674 606083 607604 615752 617087 621343 649081 665205 672771 673992 687163 708179 770123 806711 824467 ] |
||||||||||||||||||||||||||||||
|
17.85 ms (7.95%) |
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 617087 453184 453540 469487 411338 471408 418971 428831 435290 455643 470267 409088 420155 516070 497828 517207 511311 382239 387785 396287 426007 824467 455950 487007 458759 476780 492905 515384 473492 565754 559057 571820 584975 665205 708179 672771 673992 687163 546869 596317 602674 615752 591552 606083 588611 589692 591565 621343 770123 443756 453404 428532 459238 418948 464017 481466 188389 454108 406650 430348 515851 528581 385356 393778 432249 452333 455320 499904 566765 572268 589139 592685 806711 607604 412401 476454 396413 515448 509540 524796 411342 444101 452085 404289 443757 519680 520673 172262 96527 404519 414008 456605 466720 471445 453553 454971 459338 459890 459932 492454 497428 502811 506060 496754 511488 540553 544189 546960 566117 649081 443708 453679 457974 473858 428393 457769 422269 460174 444135 458732 ] |
||||||||||||||||||||||||||||||
|
3.31 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 96527 172262 188389 382239 385356 387785 393778 396287 396413 404289 404519 406650 409088 411338 411342 412401 414008 418948 418971 420155 422269 426007 428393 428532 428831 430348 432249 435290 443708 443756 443757 444101 444135 452085 452333 453184 453404 453540 453553 453679 454108 454971 455320 455643 455950 456605 457769 457974 458732 458759 459238 459338 459890 459932 460174 464017 466720 469487 470267 471408 471445 473492 473858 476454 476780 481466 487007 492454 492905 496754 497428 497828 499904 502811 506060 509540 511311 511488 515384 515448 515851 516070 517207 519680 520673 524796 528581 540553 544189 546869 546960 559057 565754 566117 566765 571820 572268 584975 588611 589139 589692 591552 591565 592685 596317 602674 606083 607604 615752 617087 621343 649081 665205 672771 673992 687163 708179 770123 806711 824467 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн большие boobs"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen big boobs"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.68%) |
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.