Query Metrics
7
Database Queries
7
Different statements
201.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.85 ms (86.81%) |
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 221827 383464 391258 398651 413637 418382 419096 419303 427753 427843 431893 435503 436765 440895 440954 444370 449545 449586 449998 450715 452754 453820 454452 455543 457901 458371 459942 461034 461193 463053 463400 463471 467970 469780 480508 480697 483786 493937 494096 496750 497748 498550 507287 507440 508226 510238 513975 516537 517121 518600 519536 524991 525234 525301 526259 529455 529976 530648 537814 539790 545439 566205 572266 577458 577865 584317 586121 587134 587342 589931 592203 594219 595150 595244 595279 595318 600128 602072 602575 626280 636046 637965 642162 647547 647590 649249 651373 652784 656635 656636 662927 673954 676895 711417 727923 728720 741702 748443 752565 755498 762414 762756 762817 762843 762913 767236 768880 779938 784507 792050 792587 793627 794071 796248 797349 804564 812533 812697 812842 ] |
||||||||||||||||||||||||||||||
|
15.81 ms (7.85%) |
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 647547 652784 587134 589931 797349 792050 792587 794071 762756 762843 530648 577458 656635 762913 587342 221827 804564 762414 752565 383464 444370 427753 539790 577865 651373 673954 586121 741702 768880 762817 398651 436765 449545 662927 626899 595279 812842 755498 455543 418382 413637 453820 525301 496750 493937 656636 592203 636046 767236 463400 419303 440895 391258 452754 458371 529976 517121 494096 529455 647590 676895 595150 602072 784507 812533 748443 626280 711417 779938 480697 518600 513975 480508 637965 812697 459942 572266 566205 584317 595318 449998 497748 431893 435503 463471 454452 508226 649249 602575 595244 727923 427843 519536 461034 449586 450715 526259 507440 545439 642162 594219 796248 793627 728720 461193 463053 419096 469780 525234 498550 483786 524991 516537 537814 440954 457901 507287 510238 467970 600128 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.58%) |
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 221827 383464 391258 398651 413637 418382 419096 419303 427753 427843 431893 435503 436765 440895 440954 444370 449545 449586 449998 450715 452754 453820 454452 455543 457901 458371 459942 461034 461193 463053 463400 463471 467970 469780 480508 480697 483786 493937 494096 496750 497748 498550 507287 507440 508226 510238 513975 516537 517121 518600 519536 524991 525234 525301 526259 529455 529976 530648 537814 539790 545439 566205 572266 577458 577865 584317 586121 587134 587342 589931 592203 594219 595150 595244 595279 595318 600128 602072 602575 626280 636046 637965 642162 647547 647590 649249 651373 652784 656635 656636 662927 673954 676895 711417 727923 728720 741702 748443 752565 755498 762414 762756 762817 762843 762913 767236 768880 779938 784507 792050 792587 793627 794071 796248 797349 804564 812533 812697 812842 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"reverse cowgirl жоп"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"reverse cowgirl ass"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"reverse cowgirl жоп"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.76%) |
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.