Query Metrics
7
Database Queries
7
Different statements
163.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.18 ms (82.48%) |
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 91891 118258 187843 233151 233556 233686 314617 323041 382183 388552 389124 391909 404247 418417 419151 420468 421826 421867 422382 424155 425037 426683 426699 426902 427093 435943 440901 443407 443587 444241 447750 447877 448489 453102 454080 454627 455727 455771 455941 457972 459154 462515 464732 466572 470230 470607 470705 471908 475927 476882 477633 479082 483660 484666 484681 486762 489849 490789 492690 496776 502868 504669 506142 509479 509910 509913 513426 516550 517187 520339 520660 521382 521532 522779 527645 527913 528853 529434 530005 531282 533742 534208 546741 555787 557938 557954 560858 567007 573557 574493 576394 582593 588975 589750 590377 590482 590598 597049 597501 598026 598473 600364 605742 610595 615248 622386 624487 628282 631600 650056 655609 659323 659419 662405 714560 735367 759329 778279 787990 803234 ] |
||||||||||||||||||||||||||||||
|
19.27 ms (11.76%) |
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 447750 557954 662405 492690 422382 453102 424155 454627 455727 610595 504669 582593 624487 650056 496776 421826 435943 426683 426699 605742 443407 448489 447877 440901 462515 520339 589750 427093 509479 527645 576394 522779 489849 470230 443587 421867 521382 520660 598473 528853 759329 530005 516550 459154 527913 466572 475927 509910 464732 529434 471908 426902 560858 476882 455941 531282 509913 521532 517187 534208 506142 454080 455771 470607 419151 600364 597501 567007 615248 187843 479082 513426 628282 557938 418417 502868 425037 457972 484681 631600 590482 484666 574493 622386 590377 573557 598026 659419 588975 590598 659323 655609 483660 486762 546741 787990 555787 803234 118258 391909 477633 444241 533742 420468 382183 323041 314617 389124 470705 490789 735367 233151 404247 714560 91891 778279 388552 233556 597049 233686 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.63%) |
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 91891 118258 187843 233151 233556 233686 314617 323041 382183 388552 389124 391909 404247 418417 419151 420468 421826 421867 422382 424155 425037 426683 426699 426902 427093 435943 440901 443407 443587 444241 447750 447877 448489 453102 454080 454627 455727 455771 455941 457972 459154 462515 464732 466572 470230 470607 470705 471908 475927 476882 477633 479082 483660 484666 484681 486762 489849 490789 492690 496776 502868 504669 506142 509479 509910 509913 513426 516550 517187 520339 520660 521382 521532 522779 527645 527913 528853 529434 530005 531282 533742 534208 546741 555787 557938 557954 560858 567007 573557 574493 576394 582593 588975 589750 590377 590482 590598 597049 597501 598026 598473 600364 605742 610595 615248 622386 624487 628282 631600 650056 655609 659323 659419 662405 714560 735367 759329 778279 787990 803234 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian fuck"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск секс"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.80%) |
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.