Query Metrics
7
Database Queries
7
Different statements
139.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.48 ms (83.45%) |
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 82091 96946 257963 382199 387174 389532 392986 398380 399865 401830 404555 407633 411470 411664 425852 441897 445468 446133 447967 450830 451719 451732 453620 453834 456261 457672 458070 460844 461661 461851 463010 467917 470712 471973 472842 474001 474497 475413 477042 477800 480536 482914 483394 487217 492676 492987 500701 502720 502928 503512 504131 504741 504790 507134 509075 510391 512199 512860 515740 517081 519224 519773 520192 521235 521574 522066 522602 522869 524711 525071 527751 529025 529528 534964 535331 538576 546969 546973 549766 552368 552443 552682 552809 555280 555546 560394 561726 565333 570151 570732 573950 574374 575865 576304 576326 577103 580027 583515 584448 591185 592157 597089 598684 599145 601857 605284 609870 613163 621360 622125 626756 630077 649847 655667 656472 656780 671296 675049 677352 702619 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (9.81%) |
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 584448 655667 546969 552443 552682 592157 605284 626756 591185 599145 613163 387174 257963 425852 461661 461851 470712 475413 483394 487217 522066 82091 96946 527751 702619 492676 398380 467917 446133 517081 522869 649847 622125 630077 474001 411470 404555 445468 471973 522602 525071 529528 500701 534964 671296 609870 389532 392986 509075 407633 411664 447967 512199 521574 474497 480536 555546 576304 583515 552368 552809 573950 561726 570151 576326 675049 677352 656472 656780 570732 598684 621360 601857 453834 399865 504131 502720 503512 504741 401830 441897 451719 458070 472842 477042 450830 520192 580027 555280 565333 575865 574374 597089 451732 463010 510391 502928 515740 529025 482914 535331 492987 507134 519773 524711 382199 456261 460844 453620 457672 477800 512860 504790 519224 521235 538576 560394 577103 546973 549766 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.90%) |
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 82091 96946 257963 382199 387174 389532 392986 398380 399865 401830 404555 407633 411470 411664 425852 441897 445468 446133 447967 450830 451719 451732 453620 453834 456261 457672 458070 460844 461661 461851 463010 467917 470712 471973 472842 474001 474497 475413 477042 477800 480536 482914 483394 487217 492676 492987 500701 502720 502928 503512 504131 504741 504790 507134 509075 510391 512199 512860 515740 517081 519224 519773 520192 521235 521574 522066 522602 522869 524711 525071 527751 529025 529528 534964 535331 538576 546969 546973 549766 552368 552443 552682 552809 555280 555546 560394 561726 565333 570151 570732 573950 574374 575865 576304 576326 577103 580027 583515 584448 591185 592157 597089 598684 599145 601857 605284 609870 613163 621360 622125 626756 630077 649847 655667 656472 656780 671296 675049 677352 702619 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skirt fuck"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"юбк секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (1.03%) |
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.