Query Metrics
7
Database Queries
7
Different statements
146.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.20 ms (81.98%) |
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 338116 370928 387285 390669 393027 398128 400179 408334 419263 421965 429482 433982 437146 437790 441159 449712 451141 451145 452976 458119 460051 460211 460362 460574 465970 473071 477597 478803 486877 499840 507483 512875 514766 516599 517466 542700 544895 569544 577204 578761 596505 599645 607589 608372 608449 608608 611033 618272 618807 632193 635202 635250 635351 638369 640411 656621 666403 667751 693399 697182 699168 705755 707127 712096 718441 719019 721882 723106 724307 724478 724495 724797 725062 727925 727969 730996 732201 732640 733232 733564 736273 738333 739353 739648 740802 741728 742009 742288 742362 750711 750873 758754 761216 764077 764693 765489 766668 773908 778384 786252 787670 788225 788226 789031 789096 792566 794858 795484 796374 798177 801539 802823 803860 804114 804323 804602 805241 814116 824340 824434 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (10.41%) |
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 473071 421965 419263 437146 465970 460211 486877 608372 824434 814116 666403 618807 608449 786252 805241 738333 750711 758754 727969 721882 764693 707127 798177 730996 739353 478803 569544 460574 512875 460362 400179 437790 460051 451145 458119 433982 499840 507483 452976 338116 824340 514766 517466 542700 544895 577204 578761 667751 693399 718441 719019 656621 697182 635202 635250 599645 788225 801539 802823 804602 789031 795484 733564 741728 742009 773908 787670 788226 794858 796374 803860 725062 727925 733232 739648 766668 724307 724478 742288 761216 765489 732201 750873 724495 732640 742362 778384 789096 804114 449712 596505 393027 390669 699168 705755 712096 723106 638369 611033 607589 608608 640411 740802 724797 736273 764077 632193 635351 792566 804323 370928 408334 441159 387285 398128 429482 451141 477597 618272 516599 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.20%) |
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 338116 370928 387285 390669 393027 398128 400179 408334 419263 421965 429482 433982 437146 437790 441159 449712 451141 451145 452976 458119 460051 460211 460362 460574 465970 473071 477597 478803 486877 499840 507483 512875 514766 516599 517466 542700 544895 569544 577204 578761 596505 599645 607589 608372 608449 608608 611033 618272 618807 632193 635202 635250 635351 638369 640411 656621 666403 667751 693399 697182 699168 705755 707127 712096 718441 719019 721882 723106 724307 724478 724495 724797 725062 727925 727969 730996 732201 732640 733232 733564 736273 738333 739353 739648 740802 741728 742009 742288 742362 750711 750873 758754 761216 764077 764693 765489 766668 773908 778384 786252 787670 788225 788226 789031 789096 792566 794858 795484 796374 798177 801539 802823 803860 804114 804323 804602 805241 814116 824340 824434 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits creampie"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон creampie"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон creampie"
]
|
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.