Query Metrics
7
Database Queries
7
Different statements
181.27 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.68 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.12 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.14 ms |
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 796904 748965 736959 791623 6806 416820 495747 631947 615915 807580 432268 434374 418219 515440 182206 448522 499789 460804 662129 806952 803676 731813 784713 761674 786872 798639 751610 769865 761180 720190 545605 647948 707391 666894 545469 600252 601578 426043 713163 400915 391604 435078 464188 688581 444956 386732 653268 761461 540269 425820 633435 639751 631593 391674 413958 413404 824320 459646 720717 782547 799695 803019 787952 788954 790069 748927 752652 733887 735772 765683 766611 630793 765388 502089 533481 583665 469465 501958 535056 600312 440876 516025 826455 531868 508292 531677 555288 718746 685807 782731 806924 771452 805935 754470 726064 704275 785574 441106 591661 700997 586899 526894 531223 527428 679799 595977 639823 756413 770271 756479 388532 543476 696103 788922 800633 765349 757395 78887 405990 416153 ] |
||||||||||||||||||||||||||||||
| 4 | 3.31 ms |
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 6806 78887 182206 386732 388532 391604 391674 400915 405990 413404 413958 416153 416820 418219 425820 426043 432268 434374 435078 440876 441106 444956 448522 459646 460804 464188 469465 495747 499789 501958 502089 508292 515440 516025 526894 527428 531223 531677 531868 533481 535056 540269 543476 545469 545605 555288 583665 586899 591661 595977 600252 600312 601578 615915 630793 631593 631947 633435 639751 639823 647948 653268 662129 666894 679799 685807 688581 696103 700997 704275 707391 713163 718746 720190 720717 726064 731813 733887 735772 736959 748927 748965 751610 752652 754470 756413 756479 757395 761180 761461 761674 765349 765388 765683 766611 769865 770271 771452 782547 782731 784713 785574 786872 787952 788922 788954 790069 791623 796904 798639 799695 800633 803019 803676 805935 806924 806952 824320 826455 ] |
||||||||||||||||||||||||||||||
| 5 | 154.64 ms |
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 6806 78887 182206 386732 388532 391604 391674 400915 405990 413404 413958 416153 416820 418219 425820 426043 432268 434374 435078 440876 441106 444956 448522 459646 460804 464188 469465 495747 499789 501958 502089 508292 515440 516025 526894 527428 531223 531677 531868 533481 535056 540269 543476 545469 545605 555288 583665 586899 591661 595977 600252 600312 601578 615915 630793 631593 631947 633435 639751 639823 647948 653268 662129 666894 679799 685807 688581 696103 700997 704275 707391 713163 718746 720190 720717 726064 731813 733887 735772 736959 748927 748965 751610 752652 754470 756413 756479 757395 761180 761461 761674 765349 765388 765683 766611 769865 770271 771452 782547 782731 784713 785574 786872 787952 788922 788954 790069 791623 796904 798639 799695 800633 803019 803676 805935 806924 806952 824320 826455 ] |
||||||||||||||||||||||||||||||
| 6 | 1.81 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.57 ms |
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.