Query Metrics
7
Database Queries
7
Different statements
371.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.54 ms (56.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy man"
]
|
||||||||||||||||||||||||||||||
|
132.61 ms (35.71%) |
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 80777 95557 143010 189004 317166 320879 325660 325910 363488 382371 382950 383036 383466 383671 385092 386326 386876 391585 392760 393458 393745 393751 393775 400466 401985 402081 402249 402252 404059 411433 415836 418421 420829 425605 426406 434656 442370 447448 448089 451554 456414 462803 467170 470359 470847 476808 477348 479560 480420 481154 489130 496356 499051 507815 518212 519227 519973 522695 524138 524253 525749 527421 529125 538660 549768 556320 559877 560079 560219 562996 563528 566348 567521 569427 569668 569672 572111 572382 578159 580197 584537 598550 604065 625757 631044 640432 664599 671703 694533 708399 725616 730323 730859 734613 742904 744095 746333 750547 759581 766042 766043 770110 775641 784145 784198 788969 789212 790884 792825 795515 796986 812082 812127 814148 820122 821928 822172 824355 827964 828819 ] |
||||||||||||||||||||||||||||||
|
20.66 ms (5.56%) |
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 525749 827964 522695 708399 792825 770110 625757 820122 415836 538660 556320 569668 790884 518212 529125 560219 80777 385092 393751 393775 401985 426406 442370 470359 451554 456414 559877 569427 549768 566348 580197 584537 567521 569672 404059 479560 481154 383671 411433 476808 480420 418421 462803 400466 470847 447448 519973 489130 496356 519227 524253 527421 383466 143010 363488 95557 386876 402252 434656 814148 477348 467170 524138 560079 562996 563528 578159 671703 694533 598550 604065 640432 788969 784198 789212 795515 796986 734613 746333 730323 742904 750547 759581 784145 812127 402081 393458 425605 317166 320879 499051 507815 631044 744095 448089 386326 383036 402249 420829 824355 822172 821928 572111 572382 664599 725616 766042 730859 766043 775641 812082 828819 382950 189004 393745 392760 391585 325660 325910 382371 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (0.83%) |
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 80777 95557 143010 189004 317166 320879 325660 325910 363488 382371 382950 383036 383466 383671 385092 386326 386876 391585 392760 393458 393745 393751 393775 400466 401985 402081 402249 402252 404059 411433 415836 418421 420829 425605 426406 434656 442370 447448 448089 451554 456414 462803 467170 470359 470847 476808 477348 479560 480420 481154 489130 496356 499051 507815 518212 519227 519973 522695 524138 524253 525749 527421 529125 538660 549768 556320 559877 560079 560219 562996 563528 566348 567521 569427 569668 569672 572111 572382 578159 580197 584537 598550 604065 625757 631044 640432 664599 671703 694533 708399 725616 730323 730859 734613 742904 744095 746333 750547 759581 766042 766043 770110 775641 784145 784198 788969 789212 790884 792825 795515 796986 812082 812127 814148 820122 821928 822172 824355 827964 828819 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy мужчин"
]
|
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.