Query Metrics
7
Database Queries
7
Different statements
199.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.65 ms (87.75%) |
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 383597 387359 389026 389165 390178 395720 398866 404491 421119 427219 428961 433748 447357 448837 451040 454323 467273 471410 473836 479800 481166 487514 489587 493045 505042 505397 506702 507168 507306 511902 511930 511931 513072 518328 525402 527065 528540 533000 533451 534319 554764 557519 559958 560396 566848 568129 575801 576014 576379 576384 586675 588268 592369 592844 593174 594803 595519 598315 598774 603576 603736 607139 610183 613496 613850 615674 620318 624436 628340 628614 636270 636440 640699 642999 643050 643424 643731 646183 646246 651924 661759 668549 672511 673093 675448 676463 677039 679706 689523 693946 698262 698425 706668 718967 720943 720985 721408 721447 722875 728681 734952 739300 745044 745268 746473 746758 749003 753216 756227 782008 796855 801526 807775 809877 812914 815372 815622 816963 818151 ] |
||||||||||||||||||||||||||||||
|
14.43 ms (7.25%) |
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 454323 518328 507168 576384 566848 722875 676463 615674 467273 672511 816963 447357 471410 505397 511931 525402 528540 534319 533451 493045 651924 720985 673093 721408 721447 557519 576014 588268 603576 620318 624436 812914 640699 720943 427219 505042 511930 815622 698425 718967 636440 628340 796855 745044 746473 739300 390178 598315 487514 395720 451040 507306 511902 560396 568129 576379 643731 643050 506702 513072 661759 677039 689523 593174 728681 746758 753216 749003 745268 642999 809877 389165 801526 404491 448837 473836 489587 533000 575801 646183 675448 698262 554764 559958 592844 598774 613850 592369 595519 610183 628614 586675 643424 613496 782008 807775 756227 607139 428961 433748 387359 398866 421119 479800 389026 481166 383597 668549 603736 527065 357915 646246 636270 734952 815372 818151 679706 693946 706668 594803 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.37%) |
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 383597 387359 389026 389165 390178 395720 398866 404491 421119 427219 428961 433748 447357 448837 451040 454323 467273 471410 473836 479800 481166 487514 489587 493045 505042 505397 506702 507168 507306 511902 511930 511931 513072 518328 525402 527065 528540 533000 533451 534319 554764 557519 559958 560396 566848 568129 575801 576014 576379 576384 586675 588268 592369 592844 593174 594803 595519 598315 598774 603576 603736 607139 610183 613496 613850 615674 620318 624436 628340 628614 636270 636440 640699 642999 643050 643424 643731 646183 646246 651924 661759 668549 672511 673093 675448 676463 677039 679706 689523 693946 698262 698425 706668 718967 720943 720985 721408 721447 722875 728681 734952 739300 745044 745268 746473 746758 749003 753216 756227 782008 796855 801526 807775 809877 812914 815372 815622 816963 818151 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage pussy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж pussy"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.76%) |
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.