Query Metrics
7
Database Queries
7
Different statements
380.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.54 ms (56.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милф большой большие"
]
|
||||||||||||||||||||||||||||||
|
143.93 ms (37.83%) |
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 387324 393055 395398 398019 399621 401303 404590 406378 406957 408084 409630 418930 419856 425636 428347 439715 447655 450797 454526 455008 466690 471491 474150 478968 481997 483404 498484 499231 504339 504922 509881 518814 519711 535820 536831 539570 539649 544269 557125 557174 564697 565142 573214 591698 596021 603425 613079 614214 618380 645933 662030 669225 673793 679708 684106 689682 694214 696468 699011 702793 706250 711674 712026 712540 716052 717741 719350 719994 720117 721140 721562 723152 726396 726649 727282 728277 732065 732160 732164 735459 741619 742553 742918 744642 744693 745183 746459 746469 751661 755338 755396 755414 756057 756725 757366 781464 784602 786168 796236 796443 799046 799056 800696 801320 801349 801757 803289 803346 804247 805603 807389 807411 808122 808614 811389 811423 811489 813693 813770 814610 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (3.68%) |
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 439715 447655 454526 504922 557125 455008 478968 756057 539570 805603 662030 732164 483404 712540 732160 406378 803346 728277 744693 399621 404590 535820 800696 450797 813770 539649 684106 694214 689682 614214 786168 727282 387324 499231 804247 755396 799046 808122 564697 474150 498484 471491 419856 428347 719994 717741 801349 808614 784602 811489 726649 755414 742553 711674 712026 673793 723152 742918 799056 811423 781464 744642 406957 518814 398019 519711 613079 807389 811389 726396 745183 757366 746459 716052 720117 721140 409630 573214 645933 702793 796236 395398 504339 596021 755338 466690 418930 509881 393055 814610 813693 557174 679708 721562 603425 618380 807411 732065 746469 699011 803289 719350 408084 425636 544269 536831 696468 669225 565142 591698 796443 801320 741619 751661 756725 735459 706250 801757 481997 401303 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"милф большой большие"
]
|
||||||||||||||||||||||||||||||
|
2.35 ms (0.62%) |
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 387324 393055 395398 398019 399621 401303 404590 406378 406957 408084 409630 418930 419856 425636 428347 439715 447655 450797 454526 455008 466690 471491 474150 478968 481997 483404 498484 499231 504339 504922 509881 518814 519711 535820 536831 539570 539649 544269 557125 557174 564697 565142 573214 591698 596021 603425 613079 614214 618380 645933 662030 669225 673793 679708 684106 689682 694214 696468 699011 702793 706250 711674 712026 712540 716052 717741 719350 719994 720117 721140 721562 723152 726396 726649 727282 728277 732065 732160 732164 735459 741619 742553 742918 744642 744693 745183 746459 746469 751661 755338 755396 755414 756057 756725 757366 781464 784602 786168 796236 796443 799046 799056 800696 801320 801349 801757 803289 803346 804247 805603 807389 807411 808122 808614 811389 811423 811489 813693 813770 814610 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"милф большой"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.