Query Metrics
7
Database Queries
7
Different statements
400.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.24 ms (53.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbw любительск"
]
|
||||||||||||||||||||||||||||||
|
163.96 ms (40.91%) |
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 383400 385955 386877 391940 398263 407442 410781 415753 423971 426294 427907 438487 441799 443518 443581 443588 446012 447238 453316 453415 453992 454565 454956 456707 457392 457431 459379 459472 459637 459657 459897 460010 460097 463148 468018 469284 471653 473823 476316 482952 483885 485599 485689 486553 487575 489721 492462 495287 506075 511061 513581 514761 515964 517452 519754 523622 524617 526682 527842 528512 529294 532471 533945 537354 545631 550514 550685 552569 554110 554793 560828 562462 563734 571131 574267 577037 578169 584012 585964 587298 588430 589242 592386 592690 593728 599638 601660 605644 606081 609071 615031 615919 630670 641807 658445 667756 710916 714925 733148 747186 749048 750948 757724 758170 758280 761066 781826 781849 781857 781873 781875 781924 784922 794622 795295 796829 802256 802291 813552 813822 ] |
||||||||||||||||||||||||||||||
|
14.46 ms (3.61%) |
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 447238 459379 476316 532471 526682 537354 506075 463148 571131 578169 552569 667756 563734 606081 588430 587298 593728 781873 802291 794622 758170 750948 795295 423971 454565 443588 459897 391940 469284 468018 483885 386877 453316 658445 733148 601660 615919 630670 385955 383400 813822 758280 528512 443518 589242 524617 574267 545631 599638 615031 459472 485599 446012 710916 407442 438487 441799 453415 454956 459637 471653 485689 486553 487575 517452 513581 519754 523622 511061 489721 554793 550685 554110 714925 560828 641807 592690 609071 585964 592386 781924 781826 757724 781875 747186 761066 410781 529294 527842 482952 398263 443581 426294 415753 427907 813552 456707 457431 460097 453992 492462 457392 459657 460010 473823 495287 514761 515964 533945 550514 584012 562462 577037 605644 784922 796829 802256 749048 781849 781857 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (0.64%) |
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 383400 385955 386877 391940 398263 407442 410781 415753 423971 426294 427907 438487 441799 443518 443581 443588 446012 447238 453316 453415 453992 454565 454956 456707 457392 457431 459379 459472 459637 459657 459897 460010 460097 463148 468018 469284 471653 473823 476316 482952 483885 485599 485689 486553 487575 489721 492462 495287 506075 511061 513581 514761 515964 517452 519754 523622 524617 526682 527842 528512 529294 532471 533945 537354 545631 550514 550685 552569 554110 554793 560828 562462 563734 571131 574267 577037 578169 584012 585964 587298 588430 589242 592386 592690 593728 599638 601660 605644 606081 609071 615031 615919 630670 641807 658445 667756 710916 714925 733148 747186 749048 750948 757724 758170 758280 761066 781826 781849 781857 781873 781875 781924 784922 794622 795295 796829 802256 802291 813552 813822 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbw amateur"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbw любительск"
]
|
||||||||||||||||||||||||||||||
|
1.63 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.