Query Metrics
7
Database Queries
7
Different statements
172.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.00 ms (78.64%) |
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 33431 386259 388365 393330 397574 404113 415863 416686 418569 419052 419834 420373 426794 428521 429959 434531 435351 437946 440202 441923 442587 444228 444431 445325 445721 446006 448532 453002 454338 454570 454763 455266 456132 456245 456310 456370 457120 457323 457807 457843 459641 461493 461880 462247 466470 467895 468657 471092 472580 473839 474334 474336 475189 475784 476068 476672 482398 482925 483466 485604 486856 487217 488902 489107 489378 490632 491000 492992 494399 496009 496418 499517 499715 500282 507404 509366 509446 509456 509586 510543 511014 511428 512558 514082 516931 517317 517801 519422 520548 521332 526126 526393 526717 528820 529860 533782 537042 545677 546764 547740 550891 553007 554852 558165 559795 566726 568195 591278 593289 595214 596402 601145 601774 627695 631641 714727 723845 757219 806437 826625 ] |
||||||||||||||||||||||||||||||
|
16.02 ms (9.27%) |
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 806437 444228 474336 448532 474334 445325 591278 631641 461880 489107 457323 416686 491000 596402 520548 537042 485604 499715 428521 33431 445721 476672 454338 456245 456370 457807 459641 466470 476068 517801 509586 529860 488902 545677 547740 566726 553007 558165 568195 714727 546764 595214 601774 601145 593289 757219 393330 397574 455266 429959 462247 489378 492992 496009 526393 494399 388365 415863 440202 471092 559795 446006 482925 526126 528820 511428 486856 418569 472580 490632 456310 550891 554852 454570 454763 516931 517317 444431 419052 437946 482398 457120 468657 456132 457843 509366 511014 467895 473839 461493 509446 499517 507404 509456 496418 519422 521332 627695 723845 512558 404113 514082 475189 826625 419834 420373 435351 442587 510543 533782 500282 426794 475784 453002 434531 441923 487217 483466 526717 386259 ] |
||||||||||||||||||||||||||||||
|
10.83 ms (6.26%) |
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 33431 386259 388365 393330 397574 404113 415863 416686 418569 419052 419834 420373 426794 428521 429959 434531 435351 437946 440202 441923 442587 444228 444431 445325 445721 446006 448532 453002 454338 454570 454763 455266 456132 456245 456310 456370 457120 457323 457807 457843 459641 461493 461880 462247 466470 467895 468657 471092 472580 473839 474334 474336 475189 475784 476068 476672 482398 482925 483466 485604 486856 487217 488902 489107 489378 490632 491000 492992 494399 496009 496418 499517 499715 500282 507404 509366 509446 509456 509586 510543 511014 511428 512558 514082 516931 517317 517801 519422 520548 521332 526126 526393 526717 528820 529860 533782 537042 545677 546764 547740 550891 553007 554852 558165 559795 566726 568195 591278 593289 595214 596402 601145 601774 627695 631641 714727 723845 757219 806437 826625 ] |
||||||||||||||||||||||||||||||
|
3.99 ms (2.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur webcam sex"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск вебкамер секс"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.10%) |
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.