Query Metrics
7
Database Queries
7
Different statements
155.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.31 ms (83.73%) |
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 256218 390180 390644 395805 404710 407683 408129 415151 418817 425675 445790 451030 452421 454211 454755 459803 468355 475419 475769 477131 487548 498061 498454 500339 501557 513981 516574 520387 522184 528572 528596 590396 591355 593293 599971 600087 601115 601135 601622 604151 605199 607206 607599 613432 620055 622366 626593 627870 629851 632148 637714 639326 640676 641362 642346 643126 643656 703930 716760 736494 737521 737633 740479 744618 744968 749925 751582 752672 755800 755954 756491 756609 757331 760398 760667 761475 763720 767585 770123 770402 770877 771023 775276 775539 776621 777732 778634 780737 782610 784345 784754 785357 785909 785916 786406 787313 788119 791504 795149 800191 800293 800604 801235 802029 803343 803756 805497 806445 806455 807589 807590 807599 807619 807957 808112 809009 809428 811007 812490 812824 ] |
||||||||||||||||||||||||||||||
|
14.99 ms (9.63%) |
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 591355 604151 620055 626593 599971 601115 601135 629851 637714 641362 590396 593293 600087 601622 607206 639326 642346 643126 643656 775276 785916 800191 800604 803343 803756 807589 807599 808112 809009 775539 777732 785909 786406 800293 801235 807957 812490 736494 752672 755954 760667 761475 782610 784345 784754 787313 788119 795149 805497 807590 809428 737521 737633 740479 755800 760398 767585 751582 756491 770123 770402 770877 771023 744618 749925 756609 757331 763720 744968 605199 607599 613432 622366 627870 632148 640676 703930 716760 776621 778634 780737 785357 791504 802029 806445 806455 807619 811007 812824 395805 408129 475419 477131 390644 425675 452421 404710 407683 415151 418817 256218 390180 445790 454211 454755 459803 475769 451030 468355 513981 498061 500339 522184 528572 528596 487548 498454 501557 516574 520387 ] |
||||||||||||||||||||||||||||||
|
2.93 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 256218 390180 390644 395805 404710 407683 408129 415151 418817 425675 445790 451030 452421 454211 454755 459803 468355 475419 475769 477131 487548 498061 498454 500339 501557 513981 516574 520387 522184 528572 528596 590396 591355 593293 599971 600087 601115 601135 601622 604151 605199 607206 607599 613432 620055 622366 626593 627870 629851 632148 637714 639326 640676 641362 642346 643126 643656 703930 716760 736494 737521 737633 740479 744618 744968 749925 751582 752672 755800 755954 756491 756609 757331 760398 760667 761475 763720 767585 770123 770402 770877 771023 775276 775539 776621 777732 778634 780737 782610 784345 784754 785357 785909 785916 786406 787313 788119 791504 795149 800191 800293 800604 801235 802029 803343 803756 805497 806445 806455 807589 807590 807599 807619 807957 808112 809009 809428 811007 812490 812824 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom toys"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom toys"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom toys"
]
|
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.