Query Metrics
7
Database Queries
7
Different statements
289.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
255.65 ms (88.40%) |
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 2779 6698 122767 233532 353774 382761 383244 385138 386775 387186 387296 388559 401088 401582 410873 429830 431213 435520 436862 443415 449249 453652 455363 460962 461464 465903 469813 470387 475899 484131 485019 485958 489071 490806 491800 492663 495801 502920 510637 510642 511202 511638 512302 512533 514785 515015 516736 519238 520033 521366 521379 526480 527737 528046 528254 532023 535108 535365 537678 538379 538847 538996 546719 546732 548648 549309 549328 549961 552238 552243 552563 555253 556843 556864 557001 558829 560397 562280 562836 564370 566716 570245 570256 570526 571895 572121 572124 572350 572442 572525 572568 572801 572822 573095 573855 574389 575796 578257 581301 612303 617102 627056 628175 631986 657674 659105 670177 677584 679104 679108 687098 701505 730790 733202 765306 772118 803648 810384 811820 813312 ] |
||||||||||||||||||||||||||||||
|
18.61 ms (6.43%) |
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 677584 546719 556864 612303 810384 813312 803648 730790 733202 772118 627056 385138 387186 401582 429830 431213 455363 475899 519238 538379 492663 512302 512533 532023 562836 581301 578257 628175 528254 386775 382761 353774 6698 410873 453652 485019 449249 537678 510642 535108 511638 535365 538847 460962 549328 552238 572525 572822 570245 570256 572801 574389 562280 572568 573095 659105 687098 657674 670177 679104 679108 701505 548648 552243 557001 558829 560397 571895 572121 573855 617102 631986 765306 811820 383244 469813 2779 233532 461464 122767 388559 435520 470387 485958 527737 510637 520033 526480 495801 514785 521366 521379 387296 401088 443415 436862 484131 490806 491800 489071 528046 502920 538996 511202 515015 516736 465903 546732 549961 556843 564370 566716 570526 572124 572350 572442 575796 549309 552563 555253 ] |
||||||||||||||||||||||||||||||
|
7.88 ms (2.72%) |
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 2779 6698 122767 233532 353774 382761 383244 385138 386775 387186 387296 388559 401088 401582 410873 429830 431213 435520 436862 443415 449249 453652 455363 460962 461464 465903 469813 470387 475899 484131 485019 485958 489071 490806 491800 492663 495801 502920 510637 510642 511202 511638 512302 512533 514785 515015 516736 519238 520033 521366 521379 526480 527737 528046 528254 532023 535108 535365 537678 538379 538847 538996 546719 546732 548648 549309 549328 549961 552238 552243 552563 555253 556843 556864 557001 558829 560397 562280 562836 564370 566716 570245 570256 570526 571895 572121 572124 572350 572442 572525 572568 572801 572822 573095 573855 574389 575796 578257 581301 612303 617102 627056 628175 631986 657674 659105 670177 677584 679104 679108 687098 701505 730790 733202 765306 772118 803648 810384 811820 813312 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поцел"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"взасос"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.56%) |
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.