Query Metrics
7
Database Queries
7
Different statements
140.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.34 ms (83.81%) |
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 458277 467225 475966 568753 569105 585956 586967 589191 591223 594780 600521 603554 603838 606804 606970 612388 613400 614379 616524 617261 617382 620642 624816 625328 626398 626473 626501 626623 626853 627268 628342 628685 630767 631024 631073 631352 632330 632938 633071 633381 639229 639381 644705 650408 652283 662158 663416 664681 668939 671446 677337 680485 696246 698603 699564 703807 704127 705220 705769 710194 711342 714914 715379 718301 718588 719437 720158 722081 722142 724078 724596 726217 726999 727293 729097 729694 730118 730457 731766 732101 732208 733030 734522 734966 735525 737005 737051 737572 737933 739160 739188 740699 741183 743756 746942 747366 747372 747383 748055 748697 748941 751247 751868 754220 755112 755174 757185 757239 757712 758977 759131 759346 761615 762168 762560 764264 802788 810152 827567 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (10.38%) |
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 696246 704127 705769 710194 711342 714914 715379 722081 722142 650408 652283 662158 663416 664681 668939 671446 677337 680485 703807 718301 719437 568753 569105 606804 613400 614379 617261 625328 626473 628685 631073 585956 586967 603554 603838 612388 626398 633071 639381 644705 591223 594780 616524 624816 626623 628342 632330 633381 589191 600521 606970 617382 620642 626501 626853 627268 630767 631024 631352 810152 729694 739188 740699 748055 755112 757239 761615 762560 724078 727293 729097 731766 732208 733030 735525 737005 737572 743756 751247 751868 724596 726217 730457 734966 739160 748697 755174 757712 758977 762168 732101 734522 741183 747366 754220 759346 726999 730118 737051 737933 746942 747372 747383 748941 757185 764264 627511 632938 639229 698603 699564 705220 718588 720158 802788 475966 759131 827567 467225 458277 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.43%) |
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 458277 467225 475966 568753 569105 585956 586967 589191 591223 594780 600521 603554 603838 606804 606970 612388 613400 614379 616524 617261 617382 620642 624816 625328 626398 626473 626501 626623 626853 627268 628342 628685 630767 631024 631073 631352 632330 632938 633071 633381 639229 639381 644705 650408 652283 662158 663416 664681 668939 671446 677337 680485 696246 698603 699564 703807 704127 705220 705769 710194 711342 714914 715379 718301 718588 719437 720158 722081 722142 724078 724596 726217 726999 727293 729097 729694 730118 730457 731766 732101 732208 733030 734522 734966 735525 737005 737051 737572 737933 739160 739188 740699 741183 743756 746942 747366 747372 747383 748055 748697 748941 751247 751868 754220 755112 755174 757185 757239 757712 758977 759131 759346 761615 762168 762560 764264 802788 810152 827567 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation dick"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац член"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.98%) |
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.