Query Metrics
7
Database Queries
7
Different statements
225.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.48 ms (89.95%) |
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 61243 134210 336058 360351 381772 382215 382326 383971 384487 385073 385388 389719 397625 402648 405042 405852 413716 419569 425864 430397 442429 444449 454480 454957 460342 463210 466185 466841 466909 466933 470426 471178 473383 477611 490383 491099 497329 502608 517678 517685 518615 527417 527913 527919 532856 535898 536716 542884 558178 558324 569529 580229 583359 584051 585928 585963 586199 592632 592662 612243 617536 617540 618514 627731 633527 634697 652799 658108 663358 663469 663906 664314 665359 666094 668880 685509 698127 700855 705755 709266 714242 714845 715268 724489 725207 725218 725507 742642 743839 744212 744460 749636 753025 753108 755345 755911 755936 755958 759747 776403 778490 781860 781976 782411 782423 789721 794872 796577 797341 802912 803897 805875 808231 808314 812390 814721 824303 824572 824833 824845 ] |
||||||||||||||||||||||||||||||
|
12.19 ms (5.42%) |
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 336058 382215 583359 663469 664314 663358 666094 585928 627731 812390 753108 782423 755958 382326 824833 585963 384487 814721 714242 61243 824303 473383 665359 658108 668880 808314 802912 824572 471178 497329 536716 652799 715268 714845 617540 634697 805875 725507 781976 755936 749636 778490 803897 360351 402648 413716 558324 580229 700855 592632 444449 517685 569529 742642 477611 454480 385388 385073 389719 405852 442429 824845 491099 705755 663906 789721 808231 744460 725207 743839 755911 466909 618514 134210 463210 527417 532856 535898 527913 470426 542884 685509 558178 584051 633527 586199 796577 797341 755345 782411 460342 425864 527919 490383 383971 397625 612243 617536 794872 781860 724489 753025 725218 759747 698127 709266 776403 454957 517678 430397 466841 592662 744212 466933 466185 405042 518615 502608 381772 419569 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.33%) |
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 61243 134210 336058 360351 381772 382215 382326 383971 384487 385073 385388 389719 397625 402648 405042 405852 413716 419569 425864 430397 442429 444449 454480 454957 460342 463210 466185 466841 466909 466933 470426 471178 473383 477611 490383 491099 497329 502608 517678 517685 518615 527417 527913 527919 532856 535898 536716 542884 558178 558324 569529 580229 583359 584051 585928 585963 586199 592632 592662 612243 617536 617540 618514 627731 633527 634697 652799 658108 663358 663469 663906 664314 665359 666094 668880 685509 698127 700855 705755 709266 714242 714845 715268 724489 725207 725218 725507 742642 743839 744212 744460 749636 753025 753108 755345 755911 755936 755958 759747 776403 778490 781860 781976 782411 782423 789721 794872 796577 797341 802912 803897 805875 808231 808314 812390 814721 824303 824572 824833 824845 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby girl"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby девушк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby девушк"
]
|
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.