Query Metrics
7
Database Queries
7
Different statements
252.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
223.46 ms (88.44%) |
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 183074 290304 382578 384118 389339 391994 398051 398113 398114 398198 408885 408928 413341 414103 415878 416607 419644 420140 429366 442430 444235 448008 448351 453221 453788 454172 465454 466476 467563 467634 468797 470473 475336 475425 476710 483543 491103 491497 493443 494530 504085 512027 513220 513977 514155 514233 516684 519722 520913 521540 522143 529632 529696 531217 531844 531891 534443 534828 535963 536527 538309 545379 545445 545455 547486 550550 559360 560106 560269 564291 567063 583358 584046 584999 588617 589166 592259 597029 602281 607569 607599 614350 634180 640859 641806 648733 665083 674087 674959 691598 695866 700990 709786 716568 718785 722395 728571 730074 738496 739158 739558 745384 749259 751615 752706 752767 762673 765712 766415 770270 774699 778172 780684 781301 799693 800442 802906 810776 813206 824733 ] |
||||||||||||||||||||||||||||||
|
18.69 ms (7.40%) |
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 534828 521540 529696 529632 535963 531891 534443 634180 597029 810776 813206 739158 602281 745384 483543 824733 467634 514233 491497 674959 700990 429366 536527 781301 419644 453788 512027 665083 607569 728571 739558 802906 514155 567063 290304 584999 448008 493443 584046 751615 520913 762673 504085 516684 513977 592259 398051 465454 475425 531844 519722 475336 560269 709786 641806 391994 384118 466476 494530 444235 691598 774699 730074 607599 531217 640859 398114 408885 513220 545379 648733 718785 589166 588617 800442 752706 408928 398198 414103 413341 416607 448351 453221 454172 545455 547486 560106 550550 722395 583358 799693 766415 749259 738496 770270 752767 765712 442430 382578 470473 420140 415878 467563 468797 538309 545445 614350 183074 491103 389339 398113 476710 522143 559360 564291 674087 716568 695866 780684 778172 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.28%) |
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 183074 290304 382578 384118 389339 391994 398051 398113 398114 398198 408885 408928 413341 414103 415878 416607 419644 420140 429366 442430 444235 448008 448351 453221 453788 454172 465454 466476 467563 467634 468797 470473 475336 475425 476710 483543 491103 491497 493443 494530 504085 512027 513220 513977 514155 514233 516684 519722 520913 521540 522143 529632 529696 531217 531844 531891 534443 534828 535963 536527 538309 545379 545445 545455 547486 550550 559360 560106 560269 564291 567063 583358 584046 584999 588617 589166 592259 597029 602281 607569 607599 614350 634180 640859 641806 648733 665083 674087 674959 691598 695866 700990 709786 716568 718785 722395 728571 730074 738496 739158 739558 745384 749259 751615 752706 752767 762673 765712 766415 770270 774699 778172 780684 781301 799693 800442 802906 810776 813206 824733 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge big dildo"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.56%) |
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.