Query Metrics
7
Database Queries
7
Different statements
153.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.27 ms (84.95%) |
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 191575 401837 414342 414374 426399 440906 443244 451149 454275 454954 464887 465606 468733 471125 471668 471691 473887 475227 476055 483319 488724 498279 503381 508883 511127 516684 520834 522142 524213 530375 530383 530643 530784 531088 532739 532779 532962 533837 533846 533928 534988 535826 536310 536638 536752 537204 537584 537659 540944 541846 542588 544838 547242 555104 560902 566786 569223 577371 581174 582540 585446 590411 595761 599915 599967 601585 601600 610683 619441 619935 630869 632618 633111 633458 635169 636309 637100 639717 641956 642002 642033 642043 644918 644925 644972 646242 646450 647340 647936 648795 648841 650316 670997 674082 676014 676023 676090 677773 677781 678063 678504 690749 692314 695096 697839 716887 716900 717826 717839 719057 720198 720582 724170 742356 765236 780016 784038 784054 801542 804697 ] |
||||||||||||||||||||||||||||||
|
13.41 ms (8.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 646242 676090 677781 676014 642002 633111 639717 522142 520834 765236 601585 585446 644918 488724 532739 536310 536752 537659 541846 648795 648841 677773 678063 647340 599915 601600 632618 637100 633458 636309 642043 716887 716900 742356 560902 464887 635169 454275 414342 440906 532962 530375 530643 540944 511127 503381 508883 569223 650316 784038 533846 630869 451149 476055 524213 595761 471668 465606 454954 646450 642033 468733 471691 780016 426399 670997 697839 695096 717839 690749 719057 471125 530383 532779 542588 692314 191575 547242 644972 555104 720198 498279 644925 566786 475227 544838 401837 577371 720582 619441 804697 784054 724170 801542 533837 582540 641956 535826 717826 610683 590411 443244 599967 619935 473887 537204 537584 581174 676023 414374 530784 483319 674082 516684 533928 536638 531088 534988 647936 678504 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.74%) |
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 191575 401837 414342 414374 426399 440906 443244 451149 454275 454954 464887 465606 468733 471125 471668 471691 473887 475227 476055 483319 488724 498279 503381 508883 511127 516684 520834 522142 524213 530375 530383 530643 530784 531088 532739 532779 532962 533837 533846 533928 534988 535826 536310 536638 536752 537204 537584 537659 540944 541846 542588 544838 547242 555104 560902 566786 569223 577371 581174 582540 585446 590411 595761 599915 599967 601585 601600 610683 619441 619935 630869 632618 633111 633458 635169 636309 637100 639717 641956 642002 642033 642043 644918 644925 644972 646242 646450 647340 647936 648795 648841 650316 670997 674082 676014 676023 676090 677773 677781 678063 678504 690749 692314 695096 697839 716887 716900 717826 717839 719057 720198 720582 724170 742356 765236 780016 784038 784054 801542 804697 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double dildo blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double дилд минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double дилд минет оральн секс"
]
|
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.