Query Metrics
7
Database Queries
7
Different statements
141.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.69 ms (85.92%) |
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 543329 544905 546988 548457 550815 550927 551074 552558 553226 553644 553766 554698 554869 557872 559413 559422 559832 559970 561763 561788 561801 565688 568179 568242 571091 571120 572722 572723 574077 577057 583580 596542 598347 601564 604906 607953 609727 610237 612979 617082 631307 636148 639683 640393 644357 646277 649714 651008 659249 660808 666142 666389 669861 669898 676696 697461 699413 699495 706430 710585 722059 725489 726814 729935 736031 740895 742340 744779 744803 744807 745215 746805 747047 748519 750347 751046 752195 753674 754531 754975 755183 759123 759816 760383 761937 761938 761952 767723 774773 775341 776780 777329 779837 779861 781268 784262 787362 795648 796952 801049 802320 803025 804077 804838 805724 806806 806990 807178 807236 807601 807673 807880 809253 809679 810460 811101 811315 811580 812230 812330 ] |
||||||||||||||||||||||||||||||
|
10.58 ms (7.47%) |
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 548457 550927 553766 554698 561788 568179 571091 583580 543329 551074 559832 572723 574077 550815 552558 557872 559413 561763 561801 565688 568242 651008 660808 669898 676696 710585 722059 646277 659249 666389 669861 699413 706430 649714 666142 697461 699495 544905 546988 553226 553644 554869 559422 559970 571120 572722 577057 604906 610237 636148 639683 598347 607953 609727 612979 617082 640393 596542 601564 631307 644357 774773 775341 779837 795648 796952 806806 806990 810460 811315 811580 776780 777329 779861 784262 801049 803025 807178 812330 736031 740895 744807 746805 752195 759123 781268 787362 802320 804077 804838 805724 807236 807601 807673 807880 809253 809679 811101 812230 726814 744803 751046 753674 759816 760383 761937 761952 767723 742340 744779 745215 747047 748519 754531 754975 755183 761938 725489 729935 750347 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.13%) |
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 543329 544905 546988 548457 550815 550927 551074 552558 553226 553644 553766 554698 554869 557872 559413 559422 559832 559970 561763 561788 561801 565688 568179 568242 571091 571120 572722 572723 574077 577057 583580 596542 598347 601564 604906 607953 609727 610237 612979 617082 631307 636148 639683 640393 644357 646277 649714 651008 659249 660808 666142 666389 669861 669898 676696 697461 699413 699495 706430 710585 722059 725489 726814 729935 736031 740895 742340 744779 744803 744807 745215 746805 747047 748519 750347 751046 752195 753674 754531 754975 755183 759123 759816 760383 761937 761938 761952 767723 774773 775341 776780 777329 779837 779861 781268 784262 787362 795648 796952 801049 802320 803025 804077 804838 805724 806806 806990 807178 807236 807601 807673 807880 809253 809679 810460 811101 811315 811580 812230 812330 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo milf masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло milf мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло milf мастурбац"
]
|
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.