Query Metrics
7
Database Queries
7
Different statements
603.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
413.97 ms (68.56%) |
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 382542 385505 386929 388205 392622 402807 412539 418774 421488 423763 425654 428220 430433 430675 432776 436005 443250 445192 446095 448396 450690 455015 464200 464721 469140 473237 473416 473574 473636 475695 478508 487537 490446 490636 492072 494177 500022 503427 512081 513938 519744 520789 526498 528183 537051 540583 544509 552814 554371 554947 559770 560287 567063 567601 567990 570754 572205 573993 577531 577581 579726 585650 590778 599502 600724 600788 601862 617066 624902 628710 632090 658796 658907 662134 666055 673797 701761 704039 706136 707539 711761 714322 724636 726503 726512 726558 727808 740492 742834 750148 750976 752605 752653 757232 757402 757825 776080 780267 784593 784874 785179 787510 788524 792936 794223 796715 796976 799601 800535 800662 803488 803832 806733 807011 807293 807619 808547 811057 811696 812893 ] |
||||||||||||||||||||||||||||||
|
157.49 ms (26.08%) |
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 382542 385505 386929 388205 392622 402807 412539 418774 421488 423763 425654 428220 430433 430675 432776 436005 443250 445192 446095 448396 450690 455015 464200 464721 469140 473237 473416 473574 473636 475695 478508 487537 490446 490636 492072 494177 500022 503427 512081 513938 519744 520789 526498 528183 537051 540583 544509 552814 554371 554947 559770 560287 567063 567601 567990 570754 572205 573993 577531 577581 579726 585650 590778 599502 600724 600788 601862 617066 624902 628710 632090 658796 658907 662134 666055 673797 701761 704039 706136 707539 711761 714322 724636 726503 726512 726558 727808 740492 742834 750148 750976 752605 752653 757232 757402 757825 776080 780267 784593 784874 785179 787510 788524 792936 794223 796715 796976 799601 800535 800662 803488 803832 806733 807011 807293 807619 808547 811057 811696 812893 ] |
||||||||||||||||||||||||||||||
|
25.10 ms (4.16%) |
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 803832 811696 776080 812893 727808 726558 757402 757232 617066 704039 780267 784874 792936 808547 392622 513938 490446 492072 494177 473574 567990 388205 386929 443250 577531 624902 469140 478508 526498 512081 450690 385505 382542 520789 560287 579726 707539 475695 701761 428220 412539 503427 464200 572205 573993 666055 706136 662134 714322 600788 599502 796715 787510 788524 800662 803488 726503 794223 757825 752605 711761 785179 423763 487537 490636 658907 726512 421488 430433 540583 544509 552814 799601 742834 445192 796976 750976 418774 402807 436005 473636 446095 554947 600724 800535 740492 724636 752653 784593 455015 473237 473416 519744 528183 500022 567601 570754 567063 585650 806733 464721 430675 432776 537051 554371 577581 658796 673797 559770 601862 628710 632090 590778 807293 807011 811057 750148 807619 448396 425654 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мастурбирует пока трахает"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац пок секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.27%) |
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.