Query Metrics
7
Database Queries
7
Different statements
149.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.19 ms (82.14%) |
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 189743 199188 358193 385386 385638 385991 390150 391546 394439 397219 398551 398567 400807 403376 411627 411998 419145 443142 443770 444117 452379 453100 453122 454225 454267 454408 455026 455910 457303 462085 462095 462106 462315 462562 463171 463803 463825 464535 465363 466989 466997 467043 469360 469453 474104 474826 474874 475039 475080 475298 476257 476260 476312 480480 480745 485733 485752 485981 486835 491109 494282 498722 499112 503801 506049 508420 516053 516137 517238 518774 518864 518869 519143 519151 522594 525492 525511 526843 529400 537837 538826 545897 546084 548065 549222 549239 549245 550636 550652 554449 558286 565931 567083 567427 567731 574257 574384 580667 591265 598649 599732 603342 607132 615631 664956 665195 665513 666811 667294 667684 678778 678790 678791 678804 724290 736765 743767 760176 781978 801053 ] |
||||||||||||||||||||||||||||||
|
17.57 ms (11.72%) |
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 529400 549222 554449 567731 666811 462106 465363 455026 462562 580667 486835 508420 558286 463171 526843 550636 598649 199188 453122 464535 567083 391546 538826 548065 443142 475039 574257 462095 474826 474874 463803 475080 476257 463825 476260 485733 518774 466997 565931 567427 607132 480480 519151 485752 519143 518864 518869 358193 469453 665513 736765 397219 615631 467043 546084 419145 474104 457303 411998 516137 455910 522594 525492 678791 453100 400807 454225 454267 462315 506049 189743 403376 537837 550652 667294 591265 801053 724290 743767 398551 411627 462085 385638 394439 476312 485981 494282 678804 525511 466989 499112 516053 443770 480745 549245 678778 678790 498722 452379 385991 398567 545897 664956 665195 667684 599732 781978 760176 385386 390150 491109 574384 549239 444117 503801 475298 517238 469360 454408 603342 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.80%) |
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 189743 199188 358193 385386 385638 385991 390150 391546 394439 397219 398551 398567 400807 403376 411627 411998 419145 443142 443770 444117 452379 453100 453122 454225 454267 454408 455026 455910 457303 462085 462095 462106 462315 462562 463171 463803 463825 464535 465363 466989 466997 467043 469360 469453 474104 474826 474874 475039 475080 475298 476257 476260 476312 480480 480745 485733 485752 485981 486835 491109 494282 498722 499112 503801 506049 508420 516053 516137 517238 518774 518864 518869 519143 519151 522594 525492 525511 526843 529400 537837 538826 545897 546084 548065 549222 549239 549245 550636 550652 554449 558286 565931 567083 567427 567731 574257 574384 580667 591265 598649 599732 603342 607132 615631 664956 665195 665513 666811 667294 667684 678778 678790 678791 678804 724290 736765 743767 760176 781978 801053 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная бабушк в"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"полненькие бабушки вÑ%…"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.98%) |
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.