Query Metrics
7
Database Queries
7
Different statements
186.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.57 ms (88.71%) |
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 381823 388793 390720 391873 395655 398552 400950 428180 438035 438069 446715 455999 456067 458431 461397 461619 463204 468654 469427 470188 471911 472676 472690 477038 477137 477968 478524 479959 483818 494565 494633 495278 496384 500413 505429 507985 509230 509575 511550 515003 526124 530247 533679 534943 538145 538265 539790 541317 541529 543535 544927 546566 548419 552730 557402 558087 558727 560292 563747 565603 566915 567875 572768 576783 578332 579190 584249 584385 587332 587446 595459 599796 603644 606974 610819 613929 626108 631674 637582 639957 648484 656921 662061 668710 670234 672260 676612 701548 707127 712568 713730 715121 726967 726994 727460 728255 728738 742865 747135 751581 756535 756841 757867 759891 761306 763561 779489 780410 780771 784831 786511 790122 794898 802872 804417 811773 814352 816595 823760 ] |
||||||||||||||||||||||||||||||
|
11.20 ms (6.00%) |
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 494633 395655 494565 507985 538145 530247 606974 456067 539790 500413 572768 578332 541529 579190 584385 558087 560292 701548 713730 648484 670234 672260 712568 565603 626108 637582 587332 509230 483818 496384 381823 390720 400950 428180 823760 472690 469427 533679 478524 548419 558727 662061 707127 599796 639957 790122 786511 794898 747135 756841 811773 757867 726994 727460 728738 751581 763561 761306 715121 780771 784831 804417 477038 463204 438069 438035 398552 802872 728255 391873 479959 461619 534943 515003 544927 567875 566915 576783 613929 742865 726967 538265 505429 509575 816595 526124 584249 780410 759891 756535 477968 610819 603644 552730 388793 455999 458431 543535 631674 779489 495278 668710 814352 446715 461397 468654 511550 470188 471911 472676 477137 563747 546566 554879 557402 541317 656921 676612 595459 587446 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (1.89%) |
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 381823 388793 390720 391873 395655 398552 400950 428180 438035 438069 446715 455999 456067 458431 461397 461619 463204 468654 469427 470188 471911 472676 472690 477038 477137 477968 478524 479959 483818 494565 494633 495278 496384 500413 505429 507985 509230 509575 511550 515003 526124 530247 533679 534943 538145 538265 539790 541317 541529 543535 544927 546566 548419 552730 557402 558087 558727 560292 563747 565603 566915 567875 572768 576783 578332 579190 584249 584385 587332 587446 595459 599796 603644 606974 610819 613929 626108 631674 637582 639957 648484 656921 662061 668710 670234 672260 676612 701548 707127 712568 713730 715121 726967 726994 727460 728255 728738 742865 747135 751581 756535 756841 757867 759891 761306 763561 779489 780410 780771 784831 786511 790122 794898 802872 804417 811773 814352 816595 823760 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateurs wife slut"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск жен slut"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск жен slut"
]
|
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.