Query Metrics
7
Database Queries
7
Different statements
160.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.70 ms (84.17%) |
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 78994 96484 97107 118234 130060 392111 412775 413446 417066 421377 424248 429044 429362 432944 445406 448651 452632 452805 457776 460168 460292 466356 467715 473005 473764 475907 479077 479723 480073 481861 482135 482147 488713 489305 492072 493088 494210 494591 500910 501406 502369 505143 505725 507243 507814 508564 508679 512079 512363 512940 514848 521345 528315 529897 532746 533653 533658 533736 533794 536419 537220 544510 550264 550665 550852 555354 564528 566432 577706 590204 590262 592027 597018 599888 603216 603468 603622 606514 609606 609875 613757 630670 635050 649100 649651 662389 669514 691179 691808 692444 693596 694958 695878 698095 699201 701237 705520 714626 715089 716124 720139 732257 735198 750477 751452 766830 770216 775879 782633 783105 788294 794230 796221 797080 803043 804700 806943 817444 817445 817451 ] |
||||||||||||||||||||||||||||||
|
15.20 ms (9.50%) |
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 751452 766830 735198 750477 603468 714626 716124 720139 775879 797080 392111 473005 96484 597018 609875 473764 603622 78994 413446 817444 466356 479723 489305 460168 481861 533794 500910 537220 505143 512079 528315 529897 508564 508679 514848 533736 536419 564528 577706 550852 715089 662389 669514 691808 692444 699201 701237 694958 695878 698095 555354 590204 590262 782633 788294 803043 804700 806943 770216 732257 606514 609606 613757 796221 118234 429044 512363 492072 505725 493088 494591 502369 599888 457776 467715 592027 794230 412775 130060 97107 705520 550264 533658 533653 566432 635050 501406 507814 512940 649100 693596 649651 603216 630670 448651 494210 550665 691179 783105 475907 482147 421377 488713 429362 432944 417066 424248 445406 817445 817451 480073 479077 482135 452632 452805 532746 521345 507243 460292 544510 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.98%) |
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 78994 96484 97107 118234 130060 392111 412775 413446 417066 421377 424248 429044 429362 432944 445406 448651 452632 452805 457776 460168 460292 466356 467715 473005 473764 475907 479077 479723 480073 481861 482135 482147 488713 489305 492072 493088 494210 494591 500910 501406 502369 505143 505725 507243 507814 508564 508679 512079 512363 512940 514848 521345 528315 529897 532746 533653 533658 533736 533794 536419 537220 544510 550264 550665 550852 555354 564528 566432 577706 590204 590262 592027 597018 599888 603216 603468 603622 606514 609606 609875 613757 630670 635050 649100 649651 662389 669514 691179 691808 692444 693596 694958 695878 698095 699201 701237 705520 714626 715089 716124 720139 732257 735198 750477 751452 766830 770216 775879 782633 783105 788294 794230 796221 797080 803043 804700 806943 817444 817445 817451 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.