Query Metrics
7
Database Queries
7
Different statements
170.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.62 ms (82.61%) |
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 12203 33974 40360 121555 168687 172262 191356 233135 233166 233321 237293 240982 266134 305556 323041 358933 365875 378046 381940 383036 383719 387213 390927 392489 393399 395228 396960 400722 405490 408940 408978 409680 415779 416044 418916 424447 429788 430543 433350 433929 435701 438005 439764 442392 443173 448949 450881 455125 456287 461047 461294 471491 472161 480553 480679 481345 481986 482450 489648 489758 493050 497701 499183 500053 508360 508745 508996 510273 513652 514160 514919 518438 519984 520480 522191 525062 526013 527181 531564 544639 548040 549153 549172 551491 556648 557807 558781 560238 561470 566405 588992 611283 611369 618309 623471 629436 699976 701763 715143 719872 724107 726240 728554 730132 737277 742763 745884 750862 761593 767998 768758 778559 778663 788075 795140 796316 796679 801381 801807 803851 ] |
||||||||||||||||||||||||||||||
|
19.36 ms (11.38%) |
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 396960 803851 514160 429788 233166 448949 778663 323041 233135 12203 438005 40360 305556 513652 33974 387213 418916 549172 629436 778559 408940 237293 482450 520480 378046 266134 433929 408978 358933 456287 489648 424447 439764 240982 788075 510273 551491 393399 390927 365875 409680 168687 395228 405490 557807 519984 699976 383719 493050 191356 500053 527181 480553 514919 471491 430543 750862 518438 560238 761593 548040 442392 549153 508360 481345 588992 558781 233321 480679 531564 701763 796679 415779 561470 728554 121555 416044 435701 611369 383036 508996 400722 443173 392489 381940 499183 623471 172262 433350 481986 544639 724107 737277 745884 796316 730132 497701 461294 801807 526013 556648 522191 489758 611283 472161 566405 618309 801381 719872 715143 461047 767998 726240 768758 742763 525062 455125 450881 508745 795140 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.64%) |
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 12203 33974 40360 121555 168687 172262 191356 233135 233166 233321 237293 240982 266134 305556 323041 358933 365875 378046 381940 383036 383719 387213 390927 392489 393399 395228 396960 400722 405490 408940 408978 409680 415779 416044 418916 424447 429788 430543 433350 433929 435701 438005 439764 442392 443173 448949 450881 455125 456287 461047 461294 471491 472161 480553 480679 481345 481986 482450 489648 489758 493050 497701 499183 500053 508360 508745 508996 510273 513652 514160 514919 518438 519984 520480 522191 525062 526013 527181 531564 544639 548040 549153 549172 551491 556648 557807 558781 560238 561470 566405 588992 611283 611369 618309 623471 629436 699976 701763 715143 719872 724107 726240 728554 730132 737277 742763 745884 750862 761593 767998 768758 778559 778663 788075 795140 796316 796679 801381 801807 803851 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð┐ð¥ÐÇð¢ð¥ Ðü Ðüð¥ÐüðÁð┤ð¥ð╝ ð© ð╝ð░ð╝ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн сосед мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.92%) |
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.