Query Metrics
7
Database Queries
7
Different statements
173.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.56 ms (84.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 393043 393968 395249 397099 397474 398132 408047 410811 420050 420231 421360 422523 422529 422993 423062 423080 423139 423202 423261 423398 427299 429276 429569 431664 432317 435759 435975 444938 445233 446355 446481 451981 451999 452532 456637 459819 462573 471355 472952 473752 473768 473771 476149 484374 497420 499035 499041 506139 510578 510622 512216 513802 515279 515844 516816 521242 527997 535992 537201 538657 540183 540187 541840 542692 546862 547284 550138 550638 550738 550752 551972 554885 556379 558391 559174 559865 559885 562849 565468 565471 565992 568852 574467 574468 575276 581362 583267 583280 585390 587243 590924 594960 597499 597502 598478 600596 600599 600626 600830 603481 605430 618483 622644 623542 628916 647297 649640 658208 658223 658226 688606 718309 730867 730875 734995 735558 741109 748631 757130 768123 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (9.39%) |
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 597499 600596 600830 550738 398132 423261 432317 444938 421360 429276 435759 456637 451981 497420 510578 538657 558391 559865 551972 575276 565992 574467 550138 583280 618483 423080 431664 422529 445233 471355 473768 420231 423398 459819 446481 515279 512216 410811 559885 583267 513802 516816 535992 562849 587243 600626 603481 451999 565468 550752 734995 537201 395249 649640 420050 748631 397474 521242 540183 554885 581362 547284 574468 622644 473771 422523 393043 435975 423202 452532 462573 446355 540187 506139 499041 472952 546862 556379 658208 718309 658223 658226 688606 559174 590924 597502 757130 730867 730875 768123 476149 397099 423062 408047 429569 473752 527997 484374 541840 427299 565471 393968 422993 499035 510622 542692 600599 585390 605430 594960 741109 423139 647297 568852 515844 598478 623542 735558 628916 550638 ] |
||||||||||||||||||||||||||||||
|
4.07 ms (2.35%) |
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 393043 393968 395249 397099 397474 398132 408047 410811 420050 420231 421360 422523 422529 422993 423062 423080 423139 423202 423261 423398 427299 429276 429569 431664 432317 435759 435975 444938 445233 446355 446481 451981 451999 452532 456637 459819 462573 471355 472952 473752 473768 473771 476149 484374 497420 499035 499041 506139 510578 510622 512216 513802 515279 515844 516816 521242 527997 535992 537201 538657 540183 540187 541840 542692 546862 547284 550138 550638 550738 550752 551972 554885 556379 558391 559174 559865 559885 562849 565468 565471 565992 568852 574467 574468 575276 581362 583267 583280 585390 587243 590924 594960 597499 597502 598478 600596 600599 600626 600830 603481 605430 618483 622644 623542 628916 647297 649640 658208 658223 658226 688606 718309 730867 730875 734995 735558 741109 748631 757130 768123 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худые маленькие азиатки"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые маленькая азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.87%) |
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.