Query Metrics
7
Database Queries
7
Different statements
193.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.78 ms (82.93%) |
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 282558 390888 395718 408609 409774 413432 414133 414204 414636 417306 417634 417891 417960 419773 420427 422022 422688 425799 429985 431965 432296 433097 433497 435697 438844 442864 443138 443453 443524 448830 451663 451757 452256 453550 453918 454020 459171 459656 460995 461840 462342 464704 465307 465490 466025 466730 466943 467703 469070 469200 470514 470666 470864 471722 472206 473900 473915 475204 476901 477060 477437 478877 480036 484667 484719 486268 492597 492599 492907 494261 497300 498269 499148 501066 502436 506415 512451 513303 513604 514455 514997 515119 515224 516819 517024 519285 542539 548735 549225 550484 555688 559181 560205 560551 561997 562000 562367 562368 566082 566664 567003 573338 574258 574833 575729 579367 585698 593989 595754 598439 598711 598911 603854 604476 617212 617423 622187 650633 658281 660306 ] |
||||||||||||||||||||||||||||||
|
22.74 ms (11.73%) |
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 417306 443138 443453 443524 414204 459656 465490 469070 448830 466730 476901 451663 451757 453550 486268 501066 464704 470666 470864 472206 477060 560551 566664 573338 575729 542539 550484 555688 548735 390888 414133 417634 469200 282558 417960 422022 461840 477437 480036 417891 442864 467703 466025 471722 475204 414636 435697 438844 460995 470514 517024 484719 492599 492907 497300 498269 502436 515224 516819 484667 492597 494261 499148 514455 562000 658281 595754 598439 604476 420427 512451 560205 549225 617212 515119 562367 579367 598711 622187 603854 617423 408609 514997 562368 566082 650633 660306 561997 574258 585698 593989 459171 395718 513604 519285 513303 413432 425799 409774 432296 433097 419773 422688 429985 431965 453918 465307 466943 473915 454020 506415 473900 478877 567003 574833 559181 598911 433497 462342 452256 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.58%) |
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 282558 390888 395718 408609 409774 413432 414133 414204 414636 417306 417634 417891 417960 419773 420427 422022 422688 425799 429985 431965 432296 433097 433497 435697 438844 442864 443138 443453 443524 448830 451663 451757 452256 453550 453918 454020 459171 459656 460995 461840 462342 464704 465307 465490 466025 466730 466943 467703 469070 469200 470514 470666 470864 471722 472206 473900 473915 475204 476901 477060 477437 478877 480036 484667 484719 486268 492597 492599 492907 494261 497300 498269 499148 501066 502436 506415 512451 513303 513604 514455 514997 515119 515224 516819 517024 519285 542539 548735 549225 550484 555688 559181 560205 560551 561997 562000 562367 562368 566082 566664 567003 573338 574258 574833 575729 579367 585698 593989 595754 598439 598711 598911 603854 604476 617212 617423 622187 650633 658281 660306 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"две бабы"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"две женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.73%) |
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.