Query Metrics
7
Database Queries
7
Different statements
226.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.70 ms (87.62%) |
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 392277 397255 400143 402999 403600 407154 408293 411310 422807 430835 432834 437583 442426 448362 450830 452335 453151 455281 455976 460189 476909 478107 486251 507115 510287 515022 515047 518858 525551 529518 531979 532063 532064 532120 532126 532825 534845 535944 536330 537116 539611 545874 545908 547912 548320 551035 551154 554525 559008 563157 563443 563898 563920 563925 569952 571508 579371 583201 585155 586150 590533 592856 601234 602959 603834 604561 609238 612977 620780 622668 622710 632549 661991 663274 674249 680854 688100 688646 695707 698312 698834 709540 710146 710310 710575 711354 714049 714156 715423 718920 720545 721233 724502 726588 726606 728352 728443 728447 742321 748892 757866 760875 770006 783485 784304 786453 799936 800097 803595 804620 804675 807394 807407 807515 810718 815353 820096 823976 824434 825102 ] |
||||||||||||||||||||||||||||||
|
18.28 ms (8.06%) |
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 452335 455976 515022 529518 532126 539611 507115 532063 569952 551154 563898 714049 807394 757866 770006 397255 403600 432834 622710 408293 478107 437583 407154 518858 453151 532064 783485 422807 442426 815353 460189 486251 531979 525551 545874 545908 563920 563925 710146 674249 698834 714156 715423 620780 585155 804675 724502 726588 728443 632549 476909 534845 455281 579371 559008 563443 571508 602959 784304 430835 825102 448362 535944 532120 551035 554525 612977 803595 748892 726606 810718 402999 622668 698312 799936 609238 392277 823976 824434 820096 532825 536330 537116 547912 688100 710575 711354 710310 721233 592856 604561 590533 586150 603834 800097 807515 728352 742321 760875 601234 807407 400143 510287 583201 548320 411310 450830 515047 680854 718920 720545 663274 688646 695707 661991 563157 804620 728447 709540 786453 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.16%) |
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 392277 397255 400143 402999 403600 407154 408293 411310 422807 430835 432834 437583 442426 448362 450830 452335 453151 455281 455976 460189 476909 478107 486251 507115 510287 515022 515047 518858 525551 529518 531979 532063 532064 532120 532126 532825 534845 535944 536330 537116 539611 545874 545908 547912 548320 551035 551154 554525 559008 563157 563443 563898 563920 563925 569952 571508 579371 583201 585155 586150 590533 592856 601234 602959 603834 604561 609238 612977 620780 622668 622710 632549 661991 663274 674249 680854 688100 688646 695707 698312 698834 709540 710146 710310 710575 711354 714049 714156 715423 718920 720545 721233 724502 726588 726606 728352 728443 728447 742321 748892 757866 760875 770006 783485 784304 786453 799936 800097 803595 804620 804675 807394 807407 807515 810718 815353 820096 823976 824434 825102 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big step mom"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие step mom"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие step mom"
]
|
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.