Query Metrics
7
Database Queries
7
Different statements
190.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.83 ms (83.16%) |
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 403141 413461 415329 415503 417212 423329 428126 430314 433297 440625 446030 448633 449425 453037 455941 456518 463780 469552 470015 473464 476123 476244 477097 477744 479788 481904 481910 487774 493163 496756 496874 503831 504399 508673 513025 515633 517923 522917 527923 532172 534823 536712 539351 540535 541587 541630 541633 541639 541643 541644 541664 541667 541671 541673 541740 541759 541774 541821 541822 542193 542195 542199 542954 544800 550579 555317 556535 563535 564203 569132 570747 571434 576710 576713 580613 583913 597963 599854 599977 600003 600022 601046 601324 602519 604517 604528 605345 605521 607355 613508 619407 632595 632616 632646 632680 633445 634178 634212 635243 636033 637092 639722 639790 639824 641644 642061 643061 647663 651607 653052 665776 666850 676428 686843 699397 711283 788262 803455 807191 824455 ] |
||||||||||||||||||||||||||||||
|
21.31 ms (11.16%) |
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 473464 449425 481910 446030 469552 563535 824455 532172 534823 515633 479788 647663 653052 642061 605345 613508 607355 788262 455941 476244 522917 517923 536712 463780 476123 477744 487774 576713 571434 634212 504399 541630 542193 541644 605521 711283 604528 807191 477097 493163 428126 570747 481904 503831 569132 550579 651607 665776 602519 599977 601046 599854 639790 641644 632646 430314 583913 541759 699397 632680 417212 541821 632595 803455 604517 632616 539351 556535 597963 470015 564203 415503 639824 643061 600003 637092 600022 456518 496756 541587 542954 541633 635243 415329 666850 440625 541673 541664 541740 541774 576710 544800 634178 633445 636033 513025 496874 555317 541643 541639 527923 541822 403141 580613 639722 423329 540535 541667 676428 686843 453037 413461 542195 601324 508673 619407 448633 433297 542199 541671 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.71%) |
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 403141 413461 415329 415503 417212 423329 428126 430314 433297 440625 446030 448633 449425 453037 455941 456518 463780 469552 470015 473464 476123 476244 477097 477744 479788 481904 481910 487774 493163 496756 496874 503831 504399 508673 513025 515633 517923 522917 527923 532172 534823 536712 539351 540535 541587 541630 541633 541639 541643 541644 541664 541667 541671 541673 541740 541759 541774 541821 541822 542193 542195 542199 542954 544800 550579 555317 556535 563535 564203 569132 570747 571434 576710 576713 580613 583913 597963 599854 599977 600003 600022 601046 601324 602519 604517 604528 605345 605521 607355 613508 619407 632595 632616 632646 632680 633445 634178 634212 635243 636033 637092 639722 639790 639824 641644 642061 643061 647663 651607 653052 665776 666850 676428 686843 699397 711283 788262 803455 807191 824455 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал mature подборк"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал mature подборк"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mature compilation"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.82%) |
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.