Query Metrics
7
Database Queries
7
Different statements
164.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.91 ms (78.56%) |
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 96917 114710 341596 382313 389418 391909 402670 404368 404952 405525 406109 406558 407884 409904 410870 412925 413263 415703 416031 417634 419867 421025 421078 421323 427306 433211 434046 434282 441024 443986 445513 445751 446198 448036 449784 451663 452131 453346 453349 454530 459358 462608 463756 463783 468044 469137 470391 472317 473184 474509 478108 480504 482982 484692 486199 490685 492907 495741 498212 502274 502575 504158 505041 509507 509552 511829 512447 512785 516769 518592 519849 520037 520393 521375 522568 522939 524621 532945 533053 536864 537671 541656 543854 543919 548666 550063 550763 554537 556785 558439 560204 562110 562810 566375 575140 587920 593992 603240 603382 603682 610668 619569 639258 640708 640939 641671 647837 648740 662000 674118 681304 681681 683369 684913 720480 722871 726301 809413 813568 828277 ] |
||||||||||||||||||||||||||||||
|
22.99 ms (14.01%) |
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 404368 404952 405525 407884 409904 413263 416031 421025 421078 427306 434046 813568 453346 463756 469137 472317 480504 451663 462608 522939 532945 537671 502274 520393 512785 509552 511829 490685 554537 566375 550063 562110 562810 575140 681304 683369 648740 674118 681681 684913 548666 550763 560204 640708 641671 603682 610668 587920 603240 640939 809413 726301 603382 720480 722871 417634 443986 448036 96917 382313 402670 463783 406109 445513 389418 410870 415703 470391 406558 445751 521375 492907 522568 504158 505041 498212 502575 341596 433211 449784 478108 516769 519849 556785 558439 619569 473184 419867 509507 495741 114710 391909 828277 524621 518592 647837 639258 593992 441024 512447 484692 412925 421323 434282 446198 452131 468044 453349 459358 454530 520037 533053 536864 474509 482982 486199 541656 543919 543854 662000 ] |
||||||||||||||||||||||||||||||
|
4.20 ms (2.56%) |
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 96917 114710 341596 382313 389418 391909 402670 404368 404952 405525 406109 406558 407884 409904 410870 412925 413263 415703 416031 417634 419867 421025 421078 421323 427306 433211 434046 434282 441024 443986 445513 445751 446198 448036 449784 451663 452131 453346 453349 454530 459358 462608 463756 463783 468044 469137 470391 472317 473184 474509 478108 480504 482982 484692 486199 490685 492907 495741 498212 502274 502575 504158 505041 509507 509552 511829 512447 512785 516769 518592 519849 520037 520393 521375 522568 522939 524621 532945 533053 536864 537671 541656 543854 543919 548666 550063 550763 554537 556785 558439 560204 562110 562810 566375 575140 587920 593992 603240 603382 603682 610668 619569 639258 640708 640939 641671 647837 648740 662000 674118 681304 681681 683369 684913 720480 722871 726301 809413 813568 828277 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"such and fuck"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.09%) |
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.