Query Metrics
7
Database Queries
7
Different statements
164.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.20 ms (88.28%) |
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 173963 197711 385267 390949 412582 463351 522166 524476 528870 532398 533843 536521 536531 539751 541488 542259 544965 547004 550147 550152 557872 558092 558110 559832 559970 562553 562561 562704 565117 565128 566672 567542 568112 568179 568243 573209 575634 576478 578643 580900 583755 593206 601079 601590 603972 604906 604926 607072 613067 613527 618678 619899 627696 629528 629757 633460 633694 634453 636710 644035 644048 644127 644344 650446 651074 664528 671554 672743 674483 686601 692135 702615 709191 712239 712617 725433 726814 731806 736031 744217 745057 752188 752195 752330 753038 754666 754938 756393 761952 772544 772902 774730 776452 777430 778524 780998 781926 781940 786110 793051 797199 797784 800146 801390 802320 803023 803754 806359 806956 807179 808041 808313 808395 808607 811094 811959 812769 817640 819273 825642 ] |
||||||||||||||||||||||||||||||
|
9.36 ms (5.69%) |
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 550147 568179 541488 559832 580900 583755 557872 558092 558110 562553 672743 674483 671554 712617 709191 559970 562561 575634 578643 604906 634453 644344 633694 603972 627696 636710 644048 644035 808395 800146 811094 736031 752195 752330 753038 786110 802320 803023 725433 726814 761952 754938 772902 754666 756393 776452 777430 778524 793051 797199 803754 807179 808607 811959 812769 412582 197711 385267 390949 532398 565128 173963 819273 817640 825642 463351 536521 536531 524476 533843 522166 528870 539751 547004 550152 568112 573209 576478 542259 544965 565117 568243 567542 650446 664528 651074 686601 692135 702615 712239 562704 566672 601079 601590 607072 629528 644127 593206 613067 613527 629757 633460 604926 618678 619899 774730 780998 781926 781940 797784 806956 808313 808041 772544 801390 806359 731806 745057 744217 752188 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.64%) |
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 173963 197711 385267 390949 412582 463351 522166 524476 528870 532398 533843 536521 536531 539751 541488 542259 544965 547004 550147 550152 557872 558092 558110 559832 559970 562553 562561 562704 565117 565128 566672 567542 568112 568179 568243 573209 575634 576478 578643 580900 583755 593206 601079 601590 603972 604906 604926 607072 613067 613527 618678 619899 627696 629528 629757 633460 633694 634453 636710 644035 644048 644127 644344 650446 651074 664528 671554 672743 674483 686601 692135 702615 709191 712239 712617 725433 726814 731806 736031 744217 745057 752188 752195 752330 753038 754666 754938 756393 761952 772544 772902 774730 776452 777430 778524 780998 781926 781940 786110 793051 797199 797784 800146 801390 802320 803023 803754 806359 806956 807179 808041 808313 808395 808607 811094 811959 812769 817640 819273 825642 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло сиськи"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.48 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.