Query Metrics
7
Database Queries
7
Different statements
254.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
225.78 ms (88.85%) |
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 72431 80777 122190 358438 384253 386813 387200 388160 395863 396957 397361 400125 400139 400178 400237 401223 402997 406041 406109 407052 407721 408293 410724 425784 434044 449880 469061 471183 472252 476270 478074 478433 487383 496329 510287 511422 511569 516838 522918 524351 527776 531498 531991 532918 532999 541725 542482 557159 560081 563536 564648 578208 584711 591789 599904 600173 600237 605415 606148 609816 621317 621976 628653 632038 634851 640008 645241 647599 650829 671730 673056 677712 682001 682914 690102 690323 690842 691254 694056 700752 707370 711998 713065 714870 724425 724758 725359 727818 730933 738054 743939 744639 751643 758719 766034 770844 771221 777241 781905 785381 789658 794609 799553 801467 803343 805541 805779 807907 809440 811220 814924 814949 815318 815545 815555 816065 816068 818456 819146 821612 ] |
||||||||||||||||||||||||||||||
|
17.15 ms (6.75%) |
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 516838 650829 743939 801467 815555 511569 714870 671730 794609 476270 584711 645241 600237 819146 690842 384253 682001 563536 397361 469061 818456 522918 711998 600173 621976 449880 814924 815545 694056 591789 599904 751643 805541 527776 724425 510287 472252 386813 816065 606148 811220 758719 805779 724758 744639 402997 401223 511422 621317 406109 532999 632038 407721 395863 400178 434044 647599 605415 770844 807907 425784 400125 816068 578208 122190 781905 738054 80777 814949 408293 396957 487383 407052 532918 564648 677712 690323 713065 524351 766034 358438 72431 388160 410724 541725 400237 387200 542482 815318 821612 496329 557159 691254 789658 725359 727818 730933 785381 478433 560081 406041 471183 531991 531498 628653 707370 400139 673056 700752 640008 777241 771221 690102 609816 809440 478074 682914 634851 803343 799553 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (1.55%) |
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 72431 80777 122190 358438 384253 386813 387200 388160 395863 396957 397361 400125 400139 400178 400237 401223 402997 406041 406109 407052 407721 408293 410724 425784 434044 449880 469061 471183 472252 476270 478074 478433 487383 496329 510287 511422 511569 516838 522918 524351 527776 531498 531991 532918 532999 541725 542482 557159 560081 563536 564648 578208 584711 591789 599904 600173 600237 605415 606148 609816 621317 621976 628653 632038 634851 640008 645241 647599 650829 671730 673056 677712 682001 682914 690102 690323 690842 691254 694056 700752 707370 711998 713065 714870 724425 724758 725359 727818 730933 738054 743939 744639 751643 758719 766034 770844 771221 777241 781905 785381 789658 794609 799553 801467 803343 805541 805779 807907 809440 811220 814924 814949 815318 815545 815555 816065 816068 818456 819146 821612 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жмж мамкы"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.61%) |
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.