Query Metrics
7
Database Queries
7
Different statements
214.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.25 ms (87.44%) |
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 12066 123541 185377 338022 383606 384269 384270 384775 385510 387403 387548 389631 402523 407773 407804 409767 413252 413946 416164 417837 418655 421366 421628 442552 446397 448351 448512 451383 452342 452434 453521 455377 459060 462268 462550 462722 463010 464809 470809 473330 474160 475805 477959 480472 482068 483340 488692 488782 493479 495166 495982 499847 500670 501442 503870 510559 511305 514621 515246 516793 518313 520953 523804 524435 524929 528344 528534 533564 550827 561882 563110 564000 566042 567633 569886 571557 575366 575720 578445 580029 580640 581896 591005 591028 593486 598688 614671 618967 620145 651218 655348 660351 671458 675547 686089 689464 693302 697126 712882 714630 715152 716405 718070 720473 726534 727474 732127 743134 743144 744319 755203 761028 770599 789658 791442 802783 806362 808288 824735 ] |
||||||||||||||||||||||||||||||
|
17.32 ms (8.09%) |
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 808288 451383 384270 185377 12066 387548 387403 418655 421628 824735 464809 575720 697126 689464 675547 598688 591005 806362 727474 791442 755203 384775 462722 463010 383606 402523 448762 452342 480472 566042 571557 580640 671458 718070 693302 720473 618967 802783 743144 715152 524435 567633 591028 503870 523804 459060 477959 470809 528534 561882 563110 580029 564000 660351 651218 655348 714630 620145 789658 726534 770599 732127 482068 446397 385510 338022 421366 473330 520953 524929 488692 495166 515246 407804 407773 413946 448512 453521 448351 488782 499847 500670 533564 475805 575366 581896 716405 686089 593486 614671 744319 743134 761028 384269 389631 123541 442552 462550 455377 501442 516793 495982 493479 483340 514621 518313 578445 712882 528344 417837 416164 413252 409767 474160 452434 462268 510559 511305 569886 550827 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.32%) |
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 12066 123541 185377 338022 383606 384269 384270 384775 385510 387403 387548 389631 402523 407773 407804 409767 413252 413946 416164 417837 418655 421366 421628 442552 446397 448351 448512 451383 452342 452434 453521 455377 459060 462268 462550 462722 463010 464809 470809 473330 474160 475805 477959 480472 482068 483340 488692 488782 493479 495166 495982 499847 500670 501442 503870 510559 511305 514621 515246 516793 518313 520953 523804 524435 524929 528344 528534 533564 550827 561882 563110 564000 566042 567633 569886 571557 575366 575720 578445 580029 580640 581896 591005 591028 593486 598688 614671 618967 620145 651218 655348 660351 671458 675547 686089 689464 693302 697126 712882 714630 715152 716405 718070 720473 726534 727474 732127 743134 743144 744319 755203 761028 770599 789658 791442 802783 806362 808288 824735 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy nice"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy nice"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy nice"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.67%) |
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.