Query Metrics
7
Database Queries
7
Different statements
367.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
344.07 ms (93.59%) |
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 384317 496582 531909 606316 608664 621633 633002 699894 701226 701427 702332 702863 703968 705353 705446 714507 715117 715571 716576 716968 717660 718639 719916 721197 721272 722855 724727 724910 726973 726999 727060 727293 727458 727683 728526 728754 728907 728942 728978 729097 730052 730482 730944 731212 731622 731711 731735 731766 732840 732996 734357 734362 734370 734528 735314 736502 736642 737290 737336 737756 738243 738450 738736 739111 739521 740538 740789 741056 742125 742614 742674 743029 743364 744378 744430 744571 744821 744885 745011 746610 746705 747241 748385 749662 750016 750020 751222 751749 753233 753634 753668 754255 755579 756909 757712 759938 760935 761051 761380 762245 762371 762514 762560 762819 764124 765305 765424 765731 777450 789719 793089 797547 797867 798271 800388 803909 805523 808200 810869 824900 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (3.72%) |
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 808200 777450 793089 724910 726973 727683 730482 734357 734370 734528 740538 743029 744885 745011 746705 749662 750020 756909 761051 762560 765424 797547 797867 798271 803909 805523 810869 724727 727293 728942 729097 730944 731766 732840 734362 737756 738450 744571 744821 746610 755579 761380 762245 727060 727458 728978 735314 736502 739111 742614 742674 744378 751749 754255 757712 759938 762371 764124 728754 736642 739521 741056 742125 743364 744430 747241 750016 753634 753668 760935 762514 762819 726999 728526 728907 730052 731212 731622 731711 731735 732996 737290 737336 738243 738736 740789 748385 751222 753233 765305 765731 606316 608664 621633 633002 699894 701226 701427 702332 702863 703968 705353 705446 714507 715117 715571 716576 716968 717660 718639 719916 721197 721272 722855 789719 800388 384317 824900 496582 531909 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (0.84%) |
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 384317 496582 531909 606316 608664 621633 633002 699894 701226 701427 702332 702863 703968 705353 705446 714507 715117 715571 716576 716968 717660 718639 719916 721197 721272 722855 724727 724910 726973 726999 727060 727293 727458 727683 728526 728754 728907 728942 728978 729097 730052 730482 730944 731212 731622 731711 731735 731766 732840 732996 734357 734362 734370 734528 735314 736502 736642 737290 737336 737756 738243 738450 738736 739111 739521 740538 740789 741056 742125 742614 742674 743029 743364 744378 744430 744571 744821 744885 745011 746610 746705 747241 748385 749662 750016 750020 751222 751749 753233 753634 753668 754255 755579 756909 757712 759938 760935 761051 761380 762245 762371 762514 762560 762819 764124 765305 765424 765731 777450 789719 793089 797547 797867 798271 800388 803909 805523 808200 810869 824900 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking cock"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking cock"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking 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.