Query Metrics
7
Database Queries
7
Different statements
160.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.14 ms (83.60%) |
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 393724 406059 406089 410051 411201 414306 414357 414548 419406 421131 421273 421352 428372 442994 443323 447258 447444 451492 458555 467605 470135 472125 478853 484699 489285 494620 500947 508418 508430 508528 512984 514706 514798 515415 516625 517784 517857 518917 521469 525178 525731 526359 527411 527428 527464 530630 531204 531251 531254 532665 532762 534625 535038 535456 537247 538817 544824 557812 560203 565539 574149 584602 590256 597239 600289 600312 601581 603386 604061 612856 628363 628381 628402 632046 637034 637427 639258 639748 640435 640793 644025 647895 648593 650145 650476 650830 676638 677287 693078 693269 715544 715670 718970 719524 722829 724719 725310 727334 727505 736912 739915 740875 743130 759502 771321 775279 776787 781776 786924 792679 796556 797472 800252 802658 805797 807953 811004 813247 814075 825217 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (10.34%) |
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 512984 514798 538817 515415 527411 527464 470135 693269 715670 628381 478853 447444 514706 525178 508418 727334 743130 640435 637427 612856 800252 797472 811004 727505 792679 442994 518917 494620 527428 532665 535038 544824 565539 650476 648593 650830 604061 603386 807953 447258 421131 393724 521469 517857 484699 489285 759502 776787 825217 719524 722829 796556 724719 414357 421352 414306 537247 517784 530630 531254 647895 600312 637034 632046 639748 644025 421273 406059 419406 451492 467605 411201 414548 516625 535456 500947 677287 715544 693078 557812 601581 739915 771321 508430 639258 406089 526359 508528 531204 531251 534625 532762 574149 584602 590256 628402 640793 597239 600289 628363 458555 410051 718970 814075 650145 805797 802658 725310 786924 740875 775279 781776 813247 736912 443323 428372 472125 525731 560203 676638 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.65%) |
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 393724 406059 406089 410051 411201 414306 414357 414548 419406 421131 421273 421352 428372 442994 443323 447258 447444 451492 458555 467605 470135 472125 478853 484699 489285 494620 500947 508418 508430 508528 512984 514706 514798 515415 516625 517784 517857 518917 521469 525178 525731 526359 527411 527428 527464 530630 531204 531251 531254 532665 532762 534625 535038 535456 537247 538817 544824 557812 560203 565539 574149 584602 590256 597239 600289 600312 601581 603386 604061 612856 628363 628381 628402 632046 637034 637427 639258 639748 640435 640793 644025 647895 648593 650145 650476 650830 676638 677287 693078 693269 715544 715670 718970 719524 722829 724719 725310 727334 727505 736912 739915 740875 743130 759502 771321 775279 776787 781776 786924 792679 796556 797472 800252 802658 805797 807953 811004 813247 814075 825217 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facesitting extreme"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фейсситтинг хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.94%) |
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.