Query Metrics
7
Database Queries
7
Different statements
170.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.93 ms (85.47%) |
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 357915 359089 386781 389733 395623 400452 401996 405409 417063 417947 426006 433386 433997 438631 440831 441363 442348 443019 445946 449264 449291 449303 450156 454332 459811 461457 468616 473536 474384 482018 485822 486399 503773 508994 512078 513092 513682 515070 519624 534389 535102 536129 555982 555998 558573 559520 561734 569913 569950 570525 570672 571585 572508 573223 573286 574978 576276 579445 583655 584527 586776 591771 593466 593915 595690 601602 610065 624854 631137 636270 641707 646246 651909 658223 670460 671721 672092 676927 677899 679385 682963 683094 709458 716528 717182 718996 722465 723941 726503 731754 735385 739053 772443 775090 775585 789007 790795 791307 794860 795070 795918 807513 810682 812426 817707 818197 818315 818717 818831 819002 822295 823551 823716 824306 826054 826059 826346 826561 827326 828599 ] |
||||||||||||||||||||||||||||||
|
14.78 ms (8.66%) |
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 810682 449291 395623 417947 433997 482018 474384 512078 519624 508994 823716 828599 817707 819002 826059 826054 826561 818831 824306 818197 823551 485822 535102 670460 672092 683094 722465 610065 593466 791307 794860 775585 789007 723941 735385 772443 739053 641707 795070 417063 717182 624854 486399 718996 812426 442348 443019 826346 731754 818717 818315 573223 386781 357915 359089 389733 400452 401996 405409 433386 426006 438631 440831 441363 822295 827326 449303 450156 454332 459811 468616 473536 445946 449264 513682 515070 534389 503773 536129 513092 461457 555982 572508 583655 570525 573286 584527 555998 558573 569913 569950 570672 571585 574978 576276 579445 651909 677899 716528 646246 671721 676927 709458 658223 679385 682963 559520 561734 586776 593915 595690 601602 631137 591771 636270 775090 790795 795918 807513 726503 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.75%) |
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 357915 359089 386781 389733 395623 400452 401996 405409 417063 417947 426006 433386 433997 438631 440831 441363 442348 443019 445946 449264 449291 449303 450156 454332 459811 461457 468616 473536 474384 482018 485822 486399 503773 508994 512078 513092 513682 515070 519624 534389 535102 536129 555982 555998 558573 559520 561734 569913 569950 570525 570672 571585 572508 573223 573286 574978 576276 579445 583655 584527 586776 591771 593466 593915 595690 601602 610065 624854 631137 636270 641707 646246 651909 658223 670460 671721 672092 676927 677899 679385 682963 683094 709458 716528 717182 718996 722465 723941 726503 731754 735385 739053 772443 775090 775585 789007 790795 791307 794860 795070 795918 807513 810682 812426 817707 818197 818315 818717 818831 819002 822295 823551 823716 824306 826054 826059 826346 826561 827326 828599 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy tits"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.92%) |
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.