Query Metrics
7
Database Queries
7
Different statements
180.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.23 ms (84.96%) |
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 12594 95557 123554 143010 143026 261001 302771 382794 382977 384786 399395 399421 400810 403074 405406 408508 434656 456428 462368 463188 470656 471371 477864 482782 484863 487735 489294 489447 515545 516306 538840 546829 548725 551070 554745 554877 556362 558619 559219 559902 562249 580608 580705 590732 596105 603110 606579 608931 612430 614992 623508 624173 624193 624788 632676 644300 644388 645919 653440 671710 672112 672355 672380 673048 676345 677088 679098 679099 680195 681127 681307 683202 692432 692796 693110 693205 698398 698597 700816 703046 703098 709404 714813 717856 721687 722545 731816 741213 748470 756234 775037 775046 775942 787387 787670 787691 789980 790981 794923 802471 806383 808000 813355 814432 815181 815219 815269 817354 817526 817946 818517 818538 818965 819151 819193 820882 822287 822428 824050 827925 ] |
||||||||||||||||||||||||||||||
|
16.53 ms (9.17%) |
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 261001 302771 12594 399421 403074 408508 824050 815219 817526 818965 819193 820882 814432 463188 538840 546829 558619 559902 671710 676345 679099 683202 703098 681127 681307 645919 672112 672355 692432 709404 717856 556362 580608 632676 644388 608931 624193 775046 790981 802471 808000 813355 748470 787387 787670 756234 731816 741213 698398 703046 714813 775037 787691 789980 806383 123554 382794 382977 400810 484863 515545 680195 624173 603110 614992 384786 143026 143010 95557 399395 405406 434656 817354 818538 818517 819151 822287 822428 815181 815269 817946 827925 456428 487735 462368 482782 470656 489294 516306 471371 477864 489447 548725 554877 559219 554745 562249 672380 673048 693205 677088 679098 698597 700816 722545 653440 692796 693110 721687 551070 580705 644300 596105 612430 624788 590732 606579 623508 775942 794923 ] |
||||||||||||||||||||||||||||||
|
3.15 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 12594 95557 123554 143010 143026 261001 302771 382794 382977 384786 399395 399421 400810 403074 405406 408508 434656 456428 462368 463188 470656 471371 477864 482782 484863 487735 489294 489447 515545 516306 538840 546829 548725 551070 554745 554877 556362 558619 559219 559902 562249 580608 580705 590732 596105 603110 606579 608931 612430 614992 623508 624173 624193 624788 632676 644300 644388 645919 653440 671710 672112 672355 672380 673048 676345 677088 679098 679099 680195 681127 681307 683202 692432 692796 693110 693205 698398 698597 700816 703046 703098 709404 714813 717856 721687 722545 731816 741213 748470 756234 775037 775046 775942 787387 787670 787691 789980 790981 794923 802471 806383 808000 813355 814432 815181 815219 815269 817354 817526 817946 818517 818538 818965 819151 819193 820882 822287 822428 824050 827925 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group pussy"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group pussy"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.