Query Metrics
7
Database Queries
7
Different statements
153.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.01 ms (85.53%) |
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 13075 89205 161581 181569 182221 208504 288045 301402 386388 387507 389832 395670 405191 418843 420023 466468 468912 478403 488306 491922 491972 492514 514687 515617 517952 518307 536012 540501 542015 544259 548313 549878 550172 556759 557251 558369 559593 559918 563494 563512 563522 565970 567732 570786 570844 585520 587541 587831 592428 592514 594804 594805 596247 600818 613610 613865 619459 620989 623557 624899 625942 632729 661908 670496 671546 673835 678837 678842 689860 689898 690126 694122 698454 699005 699359 702188 703522 706311 706513 708494 708839 715194 715332 718407 718755 718851 722673 735828 741057 741470 741606 743089 743147 744093 751631 752951 755760 760688 767960 770671 772694 774211 778716 780843 783699 787745 799044 799058 799625 805195 807492 814462 815085 815103 815125 816554 820601 823305 823360 ] |
||||||||||||||||||||||||||||||
|
12.78 ms (8.35%) |
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 514687 517952 515617 405191 468912 559918 491922 491972 466468 518307 559593 708494 715194 690126 706311 619459 743089 743147 718755 418843 420023 815085 820601 815103 540501 557251 550172 678837 689898 673835 718407 671546 715332 585520 587831 624899 799625 778716 759378 744093 741470 760688 703522 718851 395670 807492 386388 208504 161581 301402 89205 823305 816554 492514 544259 549878 556759 567732 548313 563512 702188 661908 706513 670496 699005 708839 570786 570844 594805 613610 592428 594804 596247 620989 623557 625942 632729 587541 600818 741606 772694 783699 787745 735828 751631 752951 755760 741057 478403 814462 815125 565970 689860 563522 613865 799044 780843 770671 799058 805195 182221 774211 694122 488306 699359 767960 722673 592514 181569 288045 13075 389832 387507 823360 536012 542015 558369 563494 678842 698454 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.72%) |
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 13075 89205 161581 181569 182221 208504 288045 301402 386388 387507 389832 395670 405191 418843 420023 466468 468912 478403 488306 491922 491972 492514 514687 515617 517952 518307 536012 540501 542015 544259 548313 549878 550172 556759 557251 558369 559593 559918 563494 563512 563522 565970 567732 570786 570844 585520 587541 587831 592428 592514 594804 594805 596247 600818 613610 613865 619459 620989 623557 624899 625942 632729 661908 670496 671546 673835 678837 678842 689860 689898 690126 694122 698454 699005 699359 702188 703522 706311 706513 708494 708839 715194 715332 718407 718755 718851 722673 735828 741057 741470 741606 743089 743147 744093 751631 752951 755760 760688 767960 770671 772694 774211 778716 780843 783699 787745 799044 799058 799625 805195 807492 814462 815085 815103 815125 816554 820601 823305 823360 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"office girl"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш девушк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.90%) |
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.