Query Metrics
7
Database Queries
7
Different statements
231.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.95 ms (89.11%) |
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 1061 39114 40000 58313 58336 72802 86926 97055 102892 150322 191601 197389 197574 198127 234200 250695 311201 358815 382160 382439 382488 386023 388200 388392 388945 391216 391556 392511 393886 395520 395603 395750 395938 396476 398919 399773 400014 401794 402526 403243 403268 403651 405125 405466 405479 407793 408334 411621 413963 417133 420722 421154 422106 422117 422256 422487 424943 431735 432370 432391 432485 433814 433981 437712 438551 438736 440263 441419 441453 441477 441892 444038 444232 444237 444706 445731 446154 447461 447974 451012 452332 452737 453641 454030 455405 455540 455769 456200 456794 457671 457956 459048 459405 460006 460553 460901 461119 465508 467840 468002 469492 472885 475193 475517 476894 479066 480908 486808 487748 487871 488843 490811 497642 502999 511479 515508 552159 552243 555665 570571 ] |
||||||||||||||||||||||||||||||
|
15.08 ms (6.53%) |
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 515508 386023 72802 197574 102892 234200 250695 191601 150322 393886 391556 395520 395603 395750 395938 392511 311201 358815 382488 382160 382439 86926 58336 39114 40000 58313 97055 1061 388392 388945 391216 388200 396476 399773 398919 402526 401794 403243 403651 422256 438551 438736 441419 441453 441477 444232 444706 411621 432391 437712 440263 407793 420722 422106 424943 441892 417133 421154 422117 413963 433814 452332 455405 461119 465508 469492 487748 490811 445731 452737 454030 455540 456200 456794 459405 472885 455769 457671 475193 486808 487871 511479 497642 502999 460553 468002 476894 488843 552159 570571 555665 552243 198127 432485 447974 451012 453641 457956 460901 467840 475517 480908 400014 408334 432370 433981 447461 459048 460006 479066 197389 403268 405125 405466 405479 422487 431735 444038 444237 446154 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.38%) |
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 1061 39114 40000 58313 58336 72802 86926 97055 102892 150322 191601 197389 197574 198127 234200 250695 311201 358815 382160 382439 382488 386023 388200 388392 388945 391216 391556 392511 393886 395520 395603 395750 395938 396476 398919 399773 400014 401794 402526 403243 403268 403651 405125 405466 405479 407793 408334 411621 413963 417133 420722 421154 422106 422117 422256 422487 424943 431735 432370 432391 432485 433814 433981 437712 438551 438736 440263 441419 441453 441477 441892 444038 444232 444237 444706 445731 446154 447461 447974 451012 452332 452737 453641 454030 455405 455540 455769 456200 456794 457671 457956 459048 459405 460006 460553 460901 461119 465508 467840 468002 469492 472885 475193 475517 476894 479066 480908 486808 487748 487871 488843 490811 497642 502999 511479 515508 552159 552243 555665 570571 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен мужскойрод"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ухажеру"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.59%) |
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.