Query Metrics
7
Database Queries
7
Different statements
145.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.14 ms (82.47%) |
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 355294 357845 392279 416420 419309 419928 423842 425478 427104 427181 429141 433901 438366 441357 441973 443227 443539 443543 445070 446800 450994 451610 455189 456382 458945 459039 460512 461876 463402 465011 465614 469399 469614 469873 472541 472653 473277 476931 477674 477874 478346 478940 479743 480030 481532 483115 483491 484002 486736 487371 489779 489783 490392 490992 494816 496470 497750 498219 498743 500639 500953 502298 503495 503850 509084 509616 510367 510608 511232 513764 517589 517990 518126 519386 520747 521285 521344 521704 524598 526160 526192 526810 527252 527556 527771 528285 528351 529454 530304 530317 531308 532430 533454 534144 536740 539396 540652 541177 543908 543910 547539 552954 553496 554471 556996 557133 560417 565143 568550 596337 597217 600768 619336 630257 677524 695182 722450 741024 756080 811405 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (10.59%) |
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 355294 357845 443539 429141 441973 443227 427181 450994 451610 458945 463402 477674 490392 469873 479743 486736 489779 494816 511232 529454 500639 502298 527252 530304 530317 532430 497750 503495 527556 527771 533454 500953 536740 539396 489783 557133 568550 695182 677524 554471 630257 597217 741024 619336 722450 811405 392279 473277 480030 419309 469399 478346 427104 446800 483491 498743 513764 487371 441357 445070 416420 419928 425478 433901 443543 465614 469614 490992 465011 472541 481532 472653 476931 477874 483115 496470 517589 520747 521344 531308 503850 509084 509616 510367 521285 526160 526192 540652 510608 524598 528285 534144 498219 517990 518126 519386 521704 526810 528351 460512 478940 484002 543908 543910 547539 552954 541177 556996 560417 565143 553496 596337 600768 756080 438366 456382 423842 455189 459039 461876 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.62%) |
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 355294 357845 392279 416420 419309 419928 423842 425478 427104 427181 429141 433901 438366 441357 441973 443227 443539 443543 445070 446800 450994 451610 455189 456382 458945 459039 460512 461876 463402 465011 465614 469399 469614 469873 472541 472653 473277 476931 477674 477874 478346 478940 479743 480030 481532 483115 483491 484002 486736 487371 489779 489783 490392 490992 494816 496470 497750 498219 498743 500639 500953 502298 503495 503850 509084 509616 510367 510608 511232 513764 517589 517990 518126 519386 520747 521285 521344 521704 524598 526160 526192 526810 527252 527556 527771 528285 528351 529454 530304 530317 531308 532430 533454 534144 536740 539396 540652 541177 543908 543910 547539 552954 553496 554471 556996 557133 560417 565143 568550 596337 597217 600768 619336 630257 677524 695182 722450 741024 756080 811405 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хер"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.