Query Metrics
7
Database Queries
7
Different statements
402.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.86 ms (51.84%) |
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 6694 40360 81022 91254 187851 188169 188395 188398 213056 231522 383171 383205 385469 386532 386630 386997 388458 389264 389612 390582 391077 391287 391913 397911 398553 398554 398563 404314 407707 407727 407763 409939 411630 411765 421890 425660 439709 443378 443691 448555 452034 452182 452252 454134 454270 454879 457466 463162 464291 465390 465598 465949 466155 466816 466986 467450 467550 469375 472905 474148 474871 475104 475452 475828 476348 478368 478517 479036 479843 483650 485695 490878 506062 506113 509479 519072 521136 521147 546125 546932 547605 549246 549779 553190 557998 558002 558013 563158 571846 573754 581616 586564 589608 591046 591130 597149 599353 601489 601911 613413 614521 619527 663461 665140 665361 667661 667898 670479 734638 736534 742389 746139 751474 759125 766398 781680 790232 790949 800771 802328 ] |
||||||||||||||||||||||||||||||
|
170.75 ms (42.38%) |
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 6694 40360 81022 91254 187851 188169 188395 188398 213056 231522 383171 383205 385469 386532 386630 386997 388458 389264 389612 390582 391077 391287 391913 397911 398553 398554 398563 404314 407707 407727 407763 409939 411630 411765 421890 425660 439709 443378 443691 448555 452034 452182 452252 454134 454270 454879 457466 463162 464291 465390 465598 465949 466155 466816 466986 467450 467550 469375 472905 474148 474871 475104 475452 475828 476348 478368 478517 479036 479843 483650 485695 490878 506062 506113 509479 519072 521136 521147 546125 546932 547605 549246 549779 553190 557998 558002 558013 563158 571846 573754 581616 586564 589608 591046 591130 597149 599353 601489 601911 613413 614521 619527 663461 665140 665361 667661 667898 670479 734638 736534 742389 746139 751474 759125 766398 781680 790232 790949 800771 802328 ] |
||||||||||||||||||||||||||||||
|
16.52 ms (4.10%) |
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 213056 398554 665361 790949 781680 800771 802328 734638 746139 766398 751474 231522 573754 553190 549246 599353 613413 521136 91254 40360 81022 506062 742389 386630 521147 581616 546932 601489 601911 614521 475828 421890 188395 425660 411630 454134 474148 475452 665140 667898 549779 591130 597149 463162 475104 478517 467450 389264 452182 478368 454270 457466 483650 506113 509479 519072 485695 188398 386997 398563 404314 407707 409939 407727 474871 452252 454879 466816 469375 557998 558002 667661 558013 589608 397911 411765 385469 389612 466155 479036 383205 467550 388458 391913 443378 465598 439709 490878 619527 187851 188169 407763 476348 466986 547605 663461 591046 398553 390582 465390 391287 472905 465949 586564 452034 546125 563158 464291 479843 670479 759125 736534 790232 6694 443691 391077 571846 448555 386532 383171 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bitch mature"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"женскийрод mature"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женскийрод mature"
]
|
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.