Query Metrics
7
Database Queries
7
Different statements
171.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.39 ms (85.20%) |
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 187842 379559 385381 386658 389980 396030 396243 397605 402874 407274 407570 408164 409728 409931 413135 417986 427994 447529 458927 459496 459498 463922 466831 467992 468581 468706 469613 470151 475277 479266 481166 484792 485084 485311 485363 486192 490106 495067 497878 501757 505033 505043 508777 511262 513436 515476 518424 518916 519925 522951 534990 536554 537138 537882 538204 542303 542544 571214 595731 596917 604977 630633 631245 633772 635274 637755 638248 641951 642290 642697 654412 670753 675525 677714 698423 703437 704214 705556 707429 709854 717800 720726 721400 722212 722909 726836 727744 727794 728437 730100 731832 741906 747313 747439 747459 753492 758880 759087 767265 769997 770376 770403 770520 777509 778289 779114 780634 785062 788978 789521 790387 791486 795857 797504 803450 805586 810261 811119 819490 823593 ] |
||||||||||||||||||||||||||||||
|
15.73 ms (9.15%) |
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 790387 795857 730100 731832 759087 703437 779114 396030 823593 819490 542303 677714 707429 722212 670753 705556 810261 785062 769997 770403 604977 637755 386658 187842 396243 407274 413135 458927 468706 485311 497878 536554 537882 495067 518916 522951 537138 542544 704214 721400 722909 654412 698423 571214 596917 638248 641951 791486 797504 805586 811119 778289 780634 803450 788978 741906 747439 747459 753492 758880 747313 767265 726836 770376 770520 642697 777509 789521 379559 468581 479266 385381 459496 459498 470151 402874 409728 417986 463922 467992 427994 501757 511262 515476 505043 508777 519925 538204 485363 486192 490106 631245 408164 407570 466831 475277 534990 513436 720726 595731 633772 630633 642290 728437 727744 727794 635274 709854 447529 389980 469613 481166 518424 505033 484792 485084 397605 409931 675525 717800 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.35%) |
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 187842 379559 385381 386658 389980 396030 396243 397605 402874 407274 407570 408164 409728 409931 413135 417986 427994 447529 458927 459496 459498 463922 466831 467992 468581 468706 469613 470151 475277 479266 481166 484792 485084 485311 485363 486192 490106 495067 497878 501757 505033 505043 508777 511262 513436 515476 518424 518916 519925 522951 534990 536554 537138 537882 538204 542303 542544 571214 595731 596917 604977 630633 631245 633772 635274 637755 638248 641951 642290 642697 654412 670753 675525 677714 698423 703437 704214 705556 707429 709854 717800 720726 721400 722212 722909 726836 727744 727794 728437 730100 731832 741906 747313 747439 747459 753492 758880 759087 767265 769997 770376 770403 770520 777509 778289 779114 780634 785062 788978 789521 790387 791486 795857 797504 803450 805586 810261 811119 819490 823593 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal big pussy"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал большие pussy"
]
|
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.