Query Metrics
7
Database Queries
7
Different statements
468.64 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.63 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.63 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оргазм дедов"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.43 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 528789 523205 666535 647906 413649 524564 564416 720985 671396 673092 713156 572088 596585 778364 789854 736164 734825 747920 752538 702320 462737 524023 444611 445672 556485 673661 413826 399304 527116 531162 537531 508376 566972 647945 677681 698301 618151 590740 622509 590203 624814 605856 752523 757090 731866 741310 708390 383961 459751 465942 473018 515100 521072 545410 568555 632706 401360 814810 534771 577502 569908 723175 548684 557608 582201 587176 600016 775788 733844 734840 733862 806860 675008 472974 507661 524496 563809 580197 709524 714503 663448 588747 585711 628403 623617 757896 479978 466395 470324 487067 484478 473106 484928 544309 579368 581656 583271 623357 418595 568554 653911 550336 623849 633788 628390 491500 526003 541076 580298 663239 683508 557845 624122 461744 545755 583856 556531 624430 406075 494370 ] |
||||||||||||||||||||||||||||||
| 4 | 3.03 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 383961 399304 401360 406075 413649 413826 418595 444611 445672 459751 461744 462737 465942 466395 470324 472974 473018 473106 479978 484478 484928 487067 491500 494370 507661 508376 515100 521072 523205 524023 524496 524564 526003 527116 528789 531162 534771 537531 541076 544309 545410 545755 548684 550336 556485 556531 557608 557845 563809 564416 566972 568554 568555 569908 572088 577502 579368 580197 580298 581656 582201 583271 583856 585711 587176 588747 590203 590740 596585 600016 605856 618151 622509 623357 623617 623849 624122 624430 624814 628390 628403 632706 633788 647906 647945 653911 663239 663448 666535 671396 673092 673661 675008 677681 683508 698301 702320 708390 709524 713156 714503 720985 723175 731866 733844 733862 734825 734840 736164 741310 747920 752523 752538 757090 757896 775788 778364 789854 806860 814810 ] |
||||||||||||||||||||||||||||||
| 5 | 442.35 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 383961 399304 401360 406075 413649 413826 418595 444611 445672 459751 461744 462737 465942 466395 470324 472974 473018 473106 479978 484478 484928 487067 491500 494370 507661 508376 515100 521072 523205 524023 524496 524564 526003 527116 528789 531162 534771 537531 541076 544309 545410 545755 548684 550336 556485 556531 557608 557845 563809 564416 566972 568554 568555 569908 572088 577502 579368 580197 580298 581656 582201 583271 583856 585711 587176 588747 590203 590740 596585 600016 605856 618151 622509 623357 623617 623849 624122 624430 624814 628390 628403 632706 633788 647906 647945 653911 663239 663448 666535 671396 673092 673661 675008 677681 683508 698301 702320 708390 709524 713156 714503 720985 723175 731866 733844 733862 734825 734840 736164 741310 747920 752523 752538 757090 757896 775788 778364 789854 806860 814810 ] |
||||||||||||||||||||||||||||||
| 6 | 1.88 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"оргазм старый"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.69 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.