Query Metrics
7
Database Queries
7
Different statements
143.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.95 ms (83.14%) |
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 315244 386156 399853 401810 410267 412852 413826 414253 414771 416523 416634 416653 416668 416694 416701 416725 416989 420295 420358 422511 422670 423000 423025 423260 439320 439396 443248 449687 452847 454674 458305 466161 468085 469852 473038 490741 495467 511721 514113 519592 529129 529854 530494 532843 532906 532967 533049 536674 536676 537184 537893 539938 543659 544840 545501 546200 556911 565249 565265 580727 582179 595458 598675 600071 600290 605315 605851 605874 612399 613832 624833 628082 628117 631202 633533 634512 640813 642033 642043 646824 648583 651136 651161 657489 657567 663412 663441 665238 665475 666968 670041 699627 699682 702164 706311 712162 720186 720698 720701 726292 740596 743383 747140 747439 747597 750719 753971 758615 758723 784227 788800 790234 800175 815999 817507 818235 819586 819608 825133 826672 ] |
||||||||||||||||||||||||||||||
|
14.59 ms (10.20%) |
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 598675 648583 666968 416668 726292 416634 826672 651161 788800 790234 580727 657567 416701 401810 706311 712162 818235 665238 414253 720186 468085 536674 743383 532843 466161 412852 452847 473038 532906 651136 642033 628082 416523 423260 399853 533049 595458 740596 386156 657489 819586 543659 670041 605851 532967 624833 600290 747140 495467 416653 605874 454674 546200 600071 458305 556911 633533 634512 825133 753971 815999 819608 665475 747439 720701 410267 642043 315244 416725 490741 420295 747597 449687 439396 443248 529854 539938 530494 565249 702164 420358 663412 720698 646824 663441 605315 758723 758615 817507 545501 612399 631202 613832 628117 422670 422511 469852 529129 750719 416694 699627 699682 439320 511721 414771 416989 536676 537184 544840 582179 640813 413826 519592 514113 800175 784227 423000 423025 537893 565265 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.77%) |
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 315244 386156 399853 401810 410267 412852 413826 414253 414771 416523 416634 416653 416668 416694 416701 416725 416989 420295 420358 422511 422670 423000 423025 423260 439320 439396 443248 449687 452847 454674 458305 466161 468085 469852 473038 490741 495467 511721 514113 519592 529129 529854 530494 532843 532906 532967 533049 536674 536676 537184 537893 539938 543659 544840 545501 546200 556911 565249 565265 580727 582179 595458 598675 600071 600290 605315 605851 605874 612399 613832 624833 628082 628117 631202 633533 634512 640813 642033 642043 646824 648583 651136 651161 657489 657567 663412 663441 665238 665475 666968 670041 699627 699682 702164 706311 712162 720186 720698 720701 726292 740596 743383 747140 747439 747597 750719 753971 758615 758723 784227 788800 790234 800175 815999 817507 818235 819586 819608 825133 826672 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teen dildo"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young teen дилд"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young teen дилд"
]
|
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.