Query Metrics
7
Database Queries
7
Different statements
136.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.80 ms (84.04%) |
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 550177 550905 554799 556745 556898 576469 576605 591780 599773 600718 604037 604487 612622 612913 616850 618242 620545 622046 625782 627512 628761 629427 636440 642526 644135 702985 705485 713325 714407 724985 725269 727527 727534 727914 728919 728983 729294 731268 731811 733023 733292 733734 734284 735126 735256 737866 738469 739168 739186 739300 739316 739805 740228 740662 740841 741130 741974 741978 743324 744233 746480 746487 746711 747252 747415 748511 749885 752074 757176 759338 766669 769097 770811 771207 771698 771860 771898 771935 772439 772866 773390 773640 774099 776412 777122 779202 784509 784829 784985 785786 786008 787550 787813 788640 788931 790242 791883 792229 793108 794431 795344 795401 796309 796367 796370 796411 796738 796750 797850 798331 798455 801197 801830 802279 803362 803364 803576 810821 812231 813060 ] |
||||||||||||||||||||||||||||||
|
11.78 ms (8.62%) |
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 550177 550905 554799 556745 556898 576469 576605 599773 612622 616850 622046 628761 629427 644135 591780 600718 620545 636440 642526 612913 625782 604037 618242 627512 777122 779202 784509 788931 790242 794431 795344 796309 796411 796738 796750 801830 810821 786008 787550 787813 791883 792229 793108 795401 796367 798331 798455 801197 802279 803362 803364 803576 813060 733734 734284 735126 735256 737866 741974 741978 743324 746711 752074 766669 772439 784985 796370 797850 812231 725269 727534 727914 728919 729294 731268 731811 739168 740228 748511 749885 759338 770811 771207 728983 733023 739805 746480 769097 727527 733292 738469 739186 739300 739316 741130 744233 746487 747252 771698 771898 771935 773390 724985 740662 740841 747415 757176 771860 772866 773640 774099 604487 702985 705485 713325 714407 776412 784829 785786 788640 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.30%) |
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 550177 550905 554799 556745 556898 576469 576605 591780 599773 600718 604037 604487 612622 612913 616850 618242 620545 622046 625782 627512 628761 629427 636440 642526 644135 702985 705485 713325 714407 724985 725269 727527 727534 727914 728919 728983 729294 731268 731811 733023 733292 733734 734284 735126 735256 737866 738469 739168 739186 739300 739316 739805 740228 740662 740841 741130 741974 741978 743324 744233 746480 746487 746711 747252 747415 748511 749885 752074 757176 759338 766669 769097 770811 771207 771698 771860 771898 771935 772439 772866 773390 773640 774099 776412 777122 779202 784509 784829 784985 785786 786008 787550 787813 788640 788931 790242 791883 792229 793108 794431 795344 795401 796309 796367 796370 796411 796738 796750 797850 798331 798455 801197 801830 802279 803362 803364 803576 810821 812231 813060 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hole pussy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дырк pussy"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дырк pussy"
]
|
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.