Query Metrics
7
Database Queries
7
Different statements
141.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.73 ms (81.91%) |
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 48235 68710 79355 81656 95986 129857 130089 143026 209335 209726 210072 280674 310758 317166 325910 382793 382954 383103 383389 383501 384490 384532 384786 384808 384900 385081 385683 387195 387391 388219 388366 389176 390601 392957 394238 394646 395580 395754 396341 396571 397232 397505 397740 398022 398236 398492 399090 399387 399628 399848 400944 401167 401251 402015 402967 403966 405406 409532 410163 411291 411416 414058 421352 426368 426872 428979 444778 450539 451561 451985 455234 459162 460259 460731 461260 462541 463102 463112 464301 466733 467053 467604 468834 469477 471363 474011 474289 474473 476753 477864 487116 494363 497535 504481 517788 517844 525393 531235 538815 545382 568315 580107 580262 583948 590362 590411 598024 606537 612430 615900 624239 659042 663458 681054 698597 721949 723714 730107 809493 816576 ] |
||||||||||||||||||||||||||||||
|
15.93 ms (11.28%) |
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 460731 385081 384786 384900 143026 394238 392957 280674 397232 397740 402967 401167 405406 444778 816576 463112 469477 477864 583948 698597 615900 612430 723714 721949 401251 396571 129857 399848 68710 403966 462541 317166 411416 426872 388219 426368 421352 451985 476753 474473 468834 531235 464301 568315 545382 580262 590362 590411 517844 81656 382793 384808 383103 209726 394646 395580 395754 310758 325910 48235 388366 390601 398022 398492 399628 402015 400944 414058 411291 410163 455234 487116 450539 459162 460259 494363 461260 659042 681054 606537 624239 809493 730107 79355 385683 396341 399090 399387 428979 463102 210072 389176 398236 451561 209335 397505 474011 130089 387195 387391 409532 471363 497535 474289 466733 538815 504481 517788 525393 467053 663458 580107 598024 467604 382954 383501 95986 383389 384532 384490 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.29%) |
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 48235 68710 79355 81656 95986 129857 130089 143026 209335 209726 210072 280674 310758 317166 325910 382793 382954 383103 383389 383501 384490 384532 384786 384808 384900 385081 385683 387195 387391 388219 388366 389176 390601 392957 394238 394646 395580 395754 396341 396571 397232 397505 397740 398022 398236 398492 399090 399387 399628 399848 400944 401167 401251 402015 402967 403966 405406 409532 410163 411291 411416 414058 421352 426368 426872 428979 444778 450539 451561 451985 455234 459162 460259 460731 461260 462541 463102 463112 464301 466733 467053 467604 468834 469477 471363 474011 474289 474473 476753 477864 487116 494363 497535 504481 517788 517844 525393 531235 538815 545382 568315 580107 580262 583948 590362 590411 598024 606537 612430 615900 624239 659042 663458 681054 698597 721949 723714 730107 809493 816576 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde group"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая group"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая group"
]
|
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.