Query Metrics
7
Database Queries
7
Different statements
172.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.45 ms (75.80%) |
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 35136 197609 198609 300296 371790 382861 384511 385452 386497 389676 391817 395986 397586 401648 404440 415750 416037 423435 424242 426103 429696 431747 432928 436116 444414 445834 448900 449001 452861 454005 454586 456245 456904 457567 462962 465104 465725 466567 468299 471104 480494 480498 484254 484948 486857 487783 492836 494532 495542 495543 495554 495557 497594 499940 506683 507340 511862 513015 517795 519644 520649 520923 528575 536005 536895 538708 543759 547740 561168 561920 568215 575299 577726 579234 579246 584893 595881 598401 600242 601820 602295 602993 604847 614504 618507 621287 631695 641319 641753 648569 652954 654049 663262 683061 688703 698381 700246 701968 723171 749207 751335 757832 760569 765808 773747 774755 778862 780329 785579 790264 790567 792867 796385 803028 804766 806555 807564 811293 825790 827777 ] |
||||||||||||||||||||||||||||||
|
17.56 ms (10.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam solo girl"
]
|
||||||||||||||||||||||||||||||
|
14.22 ms (8.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 448900 452861 436116 456245 547740 480498 429696 416037 517795 445834 495554 723171 536895 663262 688703 698381 790567 778862 792867 749207 796385 465104 520923 538708 495542 825790 465725 785579 631695 618507 471104 780329 654049 700246 641753 806555 371790 389676 404440 790264 456904 507340 595881 621287 449001 386497 484254 486857 804766 604847 807564 506683 579246 385452 432928 598401 600242 520649 492836 513015 384511 197609 457567 391817 424242 401648 575299 701968 648569 561920 641319 751335 765808 803028 198609 561168 774755 494532 536005 773747 511862 519644 602993 811293 431747 444414 484948 495543 760569 757832 426103 584893 568215 652954 579234 601820 397586 577726 423435 480494 495557 382861 300296 454586 466567 499940 462962 683061 395986 487783 497594 528575 827777 35136 415750 454005 468299 543759 602295 614504 ] |
||||||||||||||||||||||||||||||
|
4.22 ms (2.45%) |
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 35136 197609 198609 300296 371790 382861 384511 385452 386497 389676 391817 395986 397586 401648 404440 415750 416037 423435 424242 426103 429696 431747 432928 436116 444414 445834 448900 449001 452861 454005 454586 456245 456904 457567 462962 465104 465725 466567 468299 471104 480494 480498 484254 484948 486857 487783 492836 494532 495542 495543 495554 495557 497594 499940 506683 507340 511862 513015 517795 519644 520649 520923 528575 536005 536895 538708 543759 547740 561168 561920 568215 575299 577726 579234 579246 584893 595881 598401 600242 601820 602295 602993 604847 614504 618507 621287 631695 641319 641753 648569 652954 654049 663262 683061 688703 698381 700246 701968 723171 749207 751335 757832 760569 765808 773747 774755 778862 780329 785579 790264 790567 792867 796385 803028 804766 806555 807564 811293 825790 827777 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер соло девушк"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
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.