Query Metrics
7
Database Queries
7
Different statements
214.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.69 ms (84.54%) |
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 396555 411201 420358 425143 434455 436230 457022 460381 473963 474872 476417 479768 485681 489729 494121 494210 498228 498717 508554 516696 518622 521535 522043 522142 524626 525785 526160 530011 531785 533653 536689 536752 537659 537928 541846 541857 545608 546884 552272 558992 559453 561105 562282 562460 563419 564984 569223 569439 569766 572226 578327 579271 579377 582787 583710 589133 592384 593016 595256 599861 599875 599915 601600 605306 613839 617428 623205 625412 630297 630522 631178 632618 632690 633111 633458 633799 634790 636309 637021 637100 639717 639784 641683 642002 642018 642043 642066 646029 646242 647340 647895 647939 648220 648795 648809 648825 648839 648841 649970 653503 656568 663467 666475 668526 674927 676014 676090 676097 677773 677781 678128 678514 679029 688617 708441 716887 716900 790234 815520 815699 ] |
||||||||||||||||||||||||||||||
|
22.86 ms (10.64%) |
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 530011 536689 536752 537659 537928 541857 559453 562282 569223 541846 545608 552272 646242 647895 648220 649970 656568 674927 676090 677781 688617 648795 648839 648841 668526 676014 677773 678514 679029 646029 647340 647939 648809 648825 676097 678128 708441 595256 599861 599915 630297 630522 639784 642002 642018 601600 637021 642066 599875 623205 632618 605306 613839 625412 634790 637100 641683 790234 617428 631178 632690 633111 633458 633799 636309 639717 642043 716887 716900 436230 473963 420358 476417 411201 425143 479768 521535 494121 508554 518622 522043 522142 489729 498717 396555 434455 815520 815699 474872 457022 460381 485681 516696 526160 494210 525785 533653 498228 524626 531785 562460 564984 569766 579377 546884 563419 582787 583710 561105 579271 653503 666475 663467 558992 569439 572226 578327 589133 592384 593016 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.30%) |
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 396555 411201 420358 425143 434455 436230 457022 460381 473963 474872 476417 479768 485681 489729 494121 494210 498228 498717 508554 516696 518622 521535 522043 522142 524626 525785 526160 530011 531785 533653 536689 536752 537659 537928 541846 541857 545608 546884 552272 558992 559453 561105 562282 562460 563419 564984 569223 569439 569766 572226 578327 579271 579377 582787 583710 589133 592384 593016 595256 599861 599875 599915 601600 605306 613839 617428 623205 625412 630297 630522 631178 632618 632690 633111 633458 633799 634790 636309 637021 637100 639717 639784 641683 642002 642018 642043 642066 646029 646242 647340 647895 647939 648220 648795 648809 648825 648839 648841 649970 653503 656568 663467 666475 668526 674927 676014 676090 676097 677773 677781 678128 678514 679029 688617 708441 716887 716900 790234 815520 815699 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock dildo"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock дилд"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.80%) |
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.