Query Metrics
7
Database Queries
7
Different statements
354.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.50 ms (58.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tits interracial"
]
|
||||||||||||||||||||||||||||||
|
124.67 ms (35.18%) |
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 6666 69611 129722 382475 383336 385438 386563 388855 399387 403293 404060 405979 406853 410739 414110 414976 418337 419104 421519 429290 430278 446752 446853 448041 448619 449370 458917 460501 461738 463271 464161 468020 468471 468561 468764 474764 475725 478032 483570 484863 490806 502710 508902 511713 530639 531915 536227 537186 541089 548628 557933 560610 564251 565361 565368 571627 571865 573568 573704 573717 580589 586692 590156 601733 604329 604440 604553 604760 605624 607101 612395 613452 617411 623009 624508 629870 630711 637077 640120 646246 649496 652586 652697 654711 655973 656372 657101 657959 658000 658337 659258 659793 665332 674009 701309 709915 712326 729893 734632 737589 737728 738855 742984 747023 747389 748658 753281 766845 776265 778056 791368 796719 808893 814219 817184 817767 822988 823305 823414 823421 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (4.37%) |
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 701309 709915 564251 623009 748658 383336 429290 410739 468020 490806 449370 404060 414976 464161 458917 484863 483570 446752 537186 536227 403293 617411 385438 814219 817184 817767 822988 823305 823421 823414 530639 531915 649496 655973 657959 674009 654711 658000 658337 712326 652697 657101 605624 612395 630711 590156 778056 808893 747023 747389 753281 729893 737589 742984 766845 734632 604440 386563 129722 463271 478032 414110 69611 6666 421519 419104 475725 399387 448041 511713 571627 541089 548628 573704 573568 573717 646246 652586 659258 659793 557933 565368 571865 604760 601733 604329 624508 586692 607101 637077 737728 738855 604553 629870 508902 791368 613452 388855 405979 406853 430278 460501 468561 446853 468764 474764 382475 461738 418337 468471 502710 656372 665332 640120 776265 560610 448619 796719 580589 565361 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (0.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 6666 69611 129722 382475 383336 385438 386563 388855 399387 403293 404060 405979 406853 410739 414110 414976 418337 419104 421519 429290 430278 446752 446853 448041 448619 449370 458917 460501 461738 463271 464161 468020 468471 468561 468764 474764 475725 478032 483570 484863 490806 502710 508902 511713 530639 531915 536227 537186 541089 548628 557933 560610 564251 565361 565368 571627 571865 573568 573704 573717 580589 586692 590156 601733 604329 604440 604553 604760 605624 607101 612395 613452 617411 623009 624508 629870 630711 637077 640120 646246 649496 652586 652697 654711 655973 656372 657101 657959 658000 658337 659258 659793 665332 674009 701309 709915 712326 729893 734632 737589 737728 738855 742984 747023 747389 748658 753281 766845 776265 778056 791368 796719 808893 814219 817184 817767 822988 823305 823414 823421 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая сиськ межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.41%) |
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.