Query Metrics
7
Database Queries
7
Different statements
397.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.77 ms (51.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
159.33 ms (40.04%) |
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 24356 24374 55524 73204 80505 91345 172688 338993 383791 385105 389680 390734 390858 391754 397919 398362 401875 416925 417565 418669 421395 423942 425587 426218 426998 427911 433249 435472 439775 440838 440913 441785 446989 450663 453552 457616 459146 465475 466383 467028 467946 468291 475696 483649 483685 486773 487923 488527 491181 494548 495032 495443 496891 503201 506760 508382 509028 509365 518151 518160 518810 523845 524781 527159 536456 536457 542297 542348 545114 559881 560867 561016 563171 564048 585750 588077 591977 601311 604981 618494 636505 638038 653077 660779 665470 666468 672820 685093 691432 697457 702280 710671 714476 723965 728060 739906 740175 741567 746605 759913 764241 765717 766439 767377 768450 768997 780873 785006 791531 792685 795198 795303 795744 796891 800586 801018 804028 809874 811704 825872 ] |
||||||||||||||||||||||||||||||
|
18.84 ms (4.73%) |
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 435472 440913 440838 467946 486773 509028 518151 518160 465475 560867 563171 697457 714476 564048 591977 588077 604981 585750 390734 418669 439775 389680 446989 391754 466383 536457 483649 491181 523845 524781 503201 506760 536456 383791 73204 80505 385105 172688 338993 24374 55524 24356 398362 397919 401875 421395 441785 425587 426218 416925 417565 423942 426998 427911 433249 825872 453552 457616 459146 467028 487923 450663 483685 509365 494548 495032 495443 518810 527159 496891 508382 468291 475696 488527 542297 542348 559881 561016 545114 665470 672820 653077 702280 710671 660779 666468 685093 691432 601311 638038 618494 636505 780873 800586 801018 809874 785006 795303 811704 746605 795198 741567 766439 768450 723965 728060 739906 740175 759913 764241 765717 767377 768997 791531 792685 795744 796891 804028 91345 390858 ] |
||||||||||||||||||||||||||||||
|
5.58 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf рак"
]
|
||||||||||||||||||||||||||||||
|
3.39 ms (0.85%) |
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 24356 24374 55524 73204 80505 91345 172688 338993 383791 385105 389680 390734 390858 391754 397919 398362 401875 416925 417565 418669 421395 423942 425587 426218 426998 427911 433249 435472 439775 440838 440913 441785 446989 450663 453552 457616 459146 465475 466383 467028 467946 468291 475696 483649 483685 486773 487923 488527 491181 494548 495032 495443 496891 503201 506760 508382 509028 509365 518151 518160 518810 523845 524781 527159 536456 536457 542297 542348 545114 559881 560867 561016 563171 564048 585750 588077 591977 601311 604981 618494 636505 638038 653077 660779 665470 666468 672820 685093 691432 697457 702280 710671 714476 723965 728060 739906 740175 741567 746605 759913 764241 765717 766439 767377 768450 768997 780873 785006 791531 792685 795198 795303 795744 796891 800586 801018 804028 809874 811704 825872 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf doggy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf рак"
]
|
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.