Query Metrics
7
Database Queries
7
Different statements
187.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.91 ms (84.31%) |
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 28568 172662 229207 382460 395844 398348 400550 400850 401114 401902 402973 403312 404972 406210 409088 412222 413183 413223 418069 419598 420044 421263 425564 428831 430264 430777 430896 445767 447740 452256 453499 453515 455281 456980 466446 478740 485366 485912 489328 490744 494068 497478 505781 508940 509598 510774 514268 518218 519179 519717 522614 523245 524291 524482 524755 526060 531550 533717 534018 534020 534023 535488 538107 541293 541416 545300 545329 545828 548517 549356 549568 549996 552619 557527 559439 561492 562126 562398 562791 563513 570730 570796 573501 591628 592490 593009 593382 598373 598550 599951 600027 604627 607601 610104 611330 612867 621322 639253 649859 673767 683313 684064 687116 702268 707551 726282 754668 756388 756494 762671 780810 788119 789469 790028 794767 798731 798787 800509 810354 823929 ] |
||||||||||||||||||||||||||||||
|
18.43 ms (9.84%) |
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 570730 561492 494068 538107 562126 756388 466446 591628 610104 445767 403312 510774 533717 570796 598373 598550 600027 621322 430896 430264 519717 447740 524482 541416 562398 593382 409088 534020 534023 534018 548517 549356 549996 684064 687116 683313 557527 612867 607601 509598 418069 453515 497478 485366 400850 425564 823929 531550 490744 524291 428831 401902 611330 526060 456980 514268 455281 549568 430777 593009 505781 452256 519179 559439 421263 453499 523245 541293 535488 545329 639253 489328 604627 573501 552619 545300 545828 599951 563513 412222 508940 780810 420044 702268 794767 789469 413223 28568 798731 798787 800509 398348 382460 413183 478740 522614 592490 401114 726282 524755 419598 172662 402973 707551 810354 788119 754668 649859 756494 790028 485912 395844 562791 762671 400550 404972 518218 229207 406210 673767 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.53%) |
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 28568 172662 229207 382460 395844 398348 400550 400850 401114 401902 402973 403312 404972 406210 409088 412222 413183 413223 418069 419598 420044 421263 425564 428831 430264 430777 430896 445767 447740 452256 453499 453515 455281 456980 466446 478740 485366 485912 489328 490744 494068 497478 505781 508940 509598 510774 514268 518218 519179 519717 522614 523245 524291 524482 524755 526060 531550 533717 534018 534020 534023 535488 538107 541293 541416 545300 545329 545828 548517 549356 549568 549996 552619 557527 559439 561492 562126 562398 562791 563513 570730 570796 573501 591628 592490 593009 593382 598373 598550 599951 600027 604627 607601 610104 611330 612867 621322 639253 649859 673767 683313 684064 687116 702268 707551 726282 754668 756388 756494 762671 780810 788119 789469 790028 794767 798731 798787 800509 810354 823929 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful mother"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
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.