Query Metrics
7
Database Queries
7
Different statements
146.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.83 ms (81.83%) |
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 472299 473211 494702 494739 507167 512810 512812 521569 522432 532287 541855 542335 543006 543076 543084 543144 543172 543191 543222 543779 549146 549151 550240 550241 550247 552046 552051 556930 556932 556934 556935 556936 556938 556939 556945 556948 556951 556976 557424 564225 565929 566563 568050 574969 574981 574989 575000 575025 576869 577056 577066 577128 584137 585108 585109 585111 585112 586452 586463 586473 586476 586478 586495 586497 586498 586501 586504 586508 586513 586515 586520 591597 612245 617111 617116 618749 622912 622931 626355 626794 628631 629375 641094 650676 660008 660779 660851 671375 681463 682099 687512 687523 687525 687560 687564 687572 687578 687594 687608 688267 688268 688299 709439 710278 710356 711658 713085 713087 713258 737138 741152 748074 748084 748097 748110 752455 796814 813846 818709 818722 ] |
||||||||||||||||||||||||||||||
|
16.74 ms (11.43%) |
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 748110 748074 512812 748084 549151 748097 550247 629375 543222 532287 576869 710356 618749 577066 713087 543172 660779 628631 687578 552051 622931 512810 556938 521569 473211 556976 566563 550240 543144 577056 507167 550241 472299 494702 549146 568050 574981 586476 556932 585112 556948 586508 586478 556930 586452 585108 586504 556939 586473 585109 556936 556934 585111 586498 626355 586463 617111 543084 543779 552046 586513 565929 543191 586495 586501 556935 556945 586515 586520 556951 681463 617116 543006 688267 557424 752455 713258 586497 682099 711658 584137 650676 626794 494739 641094 574969 687560 542335 687608 687525 687564 796814 543076 612245 622912 574989 575000 710278 687512 688299 737138 713085 818722 522432 575025 688268 660008 577128 660851 818709 564225 671375 687523 687572 687594 709439 591597 741152 813846 541855 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.75%) |
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 472299 473211 494702 494739 507167 512810 512812 521569 522432 532287 541855 542335 543006 543076 543084 543144 543172 543191 543222 543779 549146 549151 550240 550241 550247 552046 552051 556930 556932 556934 556935 556936 556938 556939 556945 556948 556951 556976 557424 564225 565929 566563 568050 574969 574981 574989 575000 575025 576869 577056 577066 577128 584137 585108 585109 585111 585112 586452 586463 586473 586476 586478 586495 586497 586498 586501 586504 586508 586513 586515 586520 591597 612245 617111 617116 618749 622912 622931 626355 626794 628631 629375 641094 650676 660008 660779 660851 671375 681463 682099 687512 687523 687525 687560 687564 687572 687578 687594 687608 688267 688268 688299 709439 710278 710356 711658 713085 713087 713258 737138 741152 748074 748084 748097 748110 752455 796814 813846 818709 818722 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hijab girl"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hijab девушк"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hijab девушк"
]
|
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.