Query Metrics
7
Database Queries
7
Different statements
391.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.33 ms (53.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam anal gape"
]
|
||||||||||||||||||||||||||||||
|
159.02 ms (40.61%) |
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 365056 397478 403896 413398 414099 415977 416652 416677 416692 416737 419819 423663 424581 425431 426259 428178 428255 431381 436132 440414 441093 443086 445103 445401 446797 449406 451221 452889 453213 456219 457380 459306 459375 461870 464228 465320 468338 468949 469759 473368 477418 477537 479542 481861 482293 483735 486775 487416 487425 493254 493840 494495 500789 509824 513992 517509 519699 520419 520790 530402 531862 531877 532634 532778 534535 534551 534566 537138 541274 542142 542306 542701 545434 546129 548854 550899 554083 558912 564518 568770 570972 576548 579582 585296 591805 592576 598272 612060 614967 619996 634114 637203 656186 656935 686119 695387 695912 702402 713386 720216 726986 735026 742338 765266 766835 769890 775228 777533 778731 786048 787504 787510 793749 794866 796164 800502 804319 805227 816094 ] |
||||||||||||||||||||||||||||||
|
13.87 ms (3.54%) |
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 765266 468338 416677 558912 576548 481861 542701 778731 483735 416652 695912 686119 794866 735026 720216 426259 446797 509824 436132 579582 726986 445103 403896 416692 816094 464228 456219 500789 534566 473368 541274 656935 459375 445401 419819 486775 520419 532778 443086 425431 365056 469759 519699 431381 534535 570972 656186 713386 546129 637203 585296 592576 612060 796164 742338 777533 397478 487416 416737 441093 428255 477418 465320 477537 424581 423663 459306 461870 449406 493840 468949 513992 413398 482293 428178 451221 452889 453213 479542 493254 440414 414099 415977 457380 520790 494495 517509 531877 532634 534551 531862 530402 537138 487425 548854 564518 542142 542306 550899 554083 568770 695387 702402 545434 619996 634114 591805 614967 598272 775228 793749 804319 782849 786048 787510 800502 787504 805227 766835 769890 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (0.62%) |
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 365056 397478 403896 413398 414099 415977 416652 416677 416692 416737 419819 423663 424581 425431 426259 428178 428255 431381 436132 440414 441093 443086 445103 445401 446797 449406 451221 452889 453213 456219 457380 459306 459375 461870 464228 465320 468338 468949 469759 473368 477418 477537 479542 481861 482293 483735 486775 487416 487425 493254 493840 494495 500789 509824 513992 517509 519699 520419 520790 530402 531862 531877 532634 532778 534535 534551 534566 537138 541274 542142 542306 542701 545434 546129 548854 550899 554083 558912 564518 568770 570972 576548 579582 585296 591805 592576 598272 612060 614967 619996 634114 637203 656186 656935 686119 695387 695912 702402 713386 720216 726986 735026 742338 765266 766835 769890 775228 777533 778731 786048 787504 787510 793749 794866 796164 800502 804319 805227 816094 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер анал большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.