Query Metrics
7
Database Queries
7
Different statements
202.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.47 ms (87.63%) |
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 11177 11998 336884 382649 382823 383434 383780 384461 384775 387627 396235 403236 405048 405924 406587 407462 408217 409646 416821 419711 419882 429650 430602 439214 445781 446485 446717 454633 467373 470421 474412 476987 482786 486889 487915 490458 492266 498211 511873 524247 527556 550974 556625 565710 566258 567822 573463 576667 581821 587058 591715 599111 601547 604327 605794 609658 621603 623322 634526 640517 640526 644323 649832 650843 652982 655342 656796 659652 663427 675790 676537 680624 681012 681563 699574 704409 708460 717889 718497 724081 725133 731058 731416 736304 737171 743353 744266 745818 746958 756567 758492 762752 771525 772426 772928 784564 785629 787274 798945 800220 806225 808918 809283 809462 811545 812066 813530 815152 815393 816420 816741 817086 818177 818252 818609 818811 819995 821725 821771 822586 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (7.15%) |
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 587058 813530 467373 486889 524247 383780 403236 818177 474412 446717 527556 556625 649832 652982 680624 681012 621603 599111 806225 725133 787274 772928 745818 744266 756567 772426 731416 644323 384775 396235 419711 409646 416821 11998 405048 511873 492266 336884 655342 609658 811545 818811 605794 430602 429650 445781 482786 565710 581821 681563 470421 439214 419882 498211 407462 815152 816420 817086 819995 815393 821771 822586 550974 566258 576667 717889 699574 708460 604327 601547 623322 634526 640526 785629 808918 731058 784564 809283 736304 746958 724081 737171 758492 762752 743353 771525 640517 798945 809462 812066 383434 476987 11177 446485 487915 490458 567822 573463 663427 676537 650843 591715 454633 818609 818252 816741 704409 718497 656796 659652 675790 800220 382823 384461 382649 387627 405924 406587 408217 821725 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking cock brunette"
]
|
||||||||||||||||||||||||||||||
|
2.77 ms (1.37%) |
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 11177 11998 336884 382649 382823 383434 383780 384461 384775 387627 396235 403236 405048 405924 406587 407462 408217 409646 416821 419711 419882 429650 430602 439214 445781 446485 446717 454633 467373 470421 474412 476987 482786 486889 487915 490458 492266 498211 511873 524247 527556 550974 556625 565710 566258 567822 573463 576667 581821 587058 591715 599111 601547 604327 605794 609658 621603 623322 634526 640517 640526 644323 649832 650843 652982 655342 656796 659652 663427 675790 676537 680624 681012 681563 699574 704409 708460 717889 718497 724081 725133 731058 731416 736304 737171 743353 744266 745818 746958 756567 758492 762752 771525 772426 772928 784564 785629 787274 798945 800220 806225 808918 809283 809462 811545 812066 813530 815152 815393 816420 816741 817086 818177 818252 818609 818811 819995 821725 821771 822586 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза cock черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза cock черноволосая"
]
|
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.