Query Metrics
7
Database Queries
7
Different statements
260.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
234.79 ms (90.15%) |
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 384390 391951 397104 397396 397457 397523 408532 427358 429960 432803 441420 441425 441430 441495 441503 441511 442121 448636 455897 457380 459635 460773 475472 484318 489271 493573 493775 495364 498872 509163 509600 511357 511481 512506 515003 520790 529082 531557 534801 537504 537974 542348 543648 560643 561703 571421 580210 580423 581064 583151 585296 586589 592399 593372 602580 602862 603824 607928 618021 626842 640390 640792 651097 652353 657160 667033 680266 693369 695892 703457 703713 720284 720828 722222 722583 722640 724052 727575 729082 731224 742861 750494 752613 755846 757394 759961 761496 765493 765514 766677 767046 769883 770295 773387 777742 779010 780361 782441 787506 792938 793896 794368 794772 794823 794847 795300 795461 795687 796153 796165 796180 800404 801737 802053 803722 805502 810186 812069 814457 817171 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (6.11%) |
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 770295 794847 441425 537974 795300 731224 795461 429960 652353 626842 750494 727575 640390 794772 537504 542348 583151 391951 794368 796153 408532 442121 695892 722583 602580 602862 779010 769883 571421 384390 817171 493775 667033 680266 720284 657160 703457 801737 724052 773387 427358 795687 812069 397457 593372 814457 498872 693369 640792 780361 793896 782441 755846 800404 766677 729082 767046 802053 460773 531557 796180 794823 792938 448636 560643 561703 580423 607928 592399 511357 484318 515003 581064 703713 586589 618021 777742 742861 441420 441503 509163 651097 810186 722222 585296 803722 765514 759961 722640 397523 493573 580210 720828 796165 805502 757394 752613 787506 512506 765493 761496 441430 495364 397104 455897 459635 509600 511481 603824 432803 397396 489271 543648 441495 441511 457380 475472 520790 534801 529082 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.33%) |
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 384390 391951 397104 397396 397457 397523 408532 427358 429960 432803 441420 441425 441430 441495 441503 441511 442121 448636 455897 457380 459635 460773 475472 484318 489271 493573 493775 495364 498872 509163 509600 511357 511481 512506 515003 520790 529082 531557 534801 537504 537974 542348 543648 560643 561703 571421 580210 580423 581064 583151 585296 586589 592399 593372 602580 602862 603824 607928 618021 626842 640390 640792 651097 652353 657160 667033 680266 693369 695892 703457 703713 720284 720828 722222 722583 722640 724052 727575 729082 731224 742861 750494 752613 755846 757394 759961 761496 765493 765514 766677 767046 769883 770295 773387 777742 779010 780361 782441 787506 792938 793896 794368 794772 794823 794847 795300 795461 795687 796153 796165 796180 800404 801737 802053 803722 805502 810186 812069 814457 817171 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крича вперв анал крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"крича вперв анал крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"painful anal crying"
]
|
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.