Query Metrics
7
Database Queries
7
Different statements
194.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.61 ms (87.14%) |
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 383638 415003 425490 425491 430504 448987 458570 458784 461506 462038 462042 466113 466915 472352 477209 479814 480779 480858 481673 481679 487028 489621 492386 494596 496606 508754 508819 509677 512668 513246 513274 514384 516270 518401 519927 527630 530799 533191 533195 533267 540073 545210 546022 548660 552632 558436 558841 560607 566657 566849 567341 568313 568314 574489 574803 574904 574978 575132 575481 575806 586765 586776 586785 587997 594561 594935 594980 602970 604997 605025 605410 605544 606253 611902 618592 654574 655074 655366 655624 658358 658728 660530 660942 661969 664842 665221 665276 666103 666767 667568 668857 669761 670495 677133 697548 698511 704889 710957 720287 725864 725921 729576 732938 732953 734371 742169 742181 744892 745793 757210 789233 789301 789310 789401 793314 796468 807710 814606 815233 820149 ] |
||||||||||||||||||||||||||||||
|
14.46 ms (7.43%) |
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 479814 516270 820149 487028 548660 574978 661969 586776 605025 734371 448987 575806 519927 415003 815233 533191 575481 545210 655366 660530 677133 655074 664842 665221 666103 710957 667568 669761 670495 594561 594980 586765 789233 789301 793314 789401 732953 742181 729576 725864 757210 807710 472352 477209 480779 513246 540073 530799 533195 558841 575132 546022 552632 560607 566849 574489 574803 666767 720287 668857 566657 574904 789310 458784 461506 481673 481679 383638 425491 462038 462042 480858 466113 518401 489621 496606 513274 527630 509677 512668 514384 492386 508754 508819 611902 605544 430504 466915 558436 567341 618592 458570 494596 533267 568314 654574 658358 658728 660942 665276 655624 606253 586785 594935 602970 604997 605410 796468 725921 745793 742169 732938 744892 697548 698511 704889 425490 814606 568313 587997 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.71%) |
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 383638 415003 425490 425491 430504 448987 458570 458784 461506 462038 462042 466113 466915 472352 477209 479814 480779 480858 481673 481679 487028 489621 492386 494596 496606 508754 508819 509677 512668 513246 513274 514384 516270 518401 519927 527630 530799 533191 533195 533267 540073 545210 546022 548660 552632 558436 558841 560607 566657 566849 567341 568313 568314 574489 574803 574904 574978 575132 575481 575806 586765 586776 586785 587997 594561 594935 594980 602970 604997 605025 605410 605544 606253 611902 618592 654574 655074 655366 655624 658358 658728 660530 660942 661969 664842 665221 665276 666103 666767 667568 668857 669761 670495 677133 697548 698511 704889 710957 720287 725864 725921 729576 732938 732953 734371 742169 742181 744892 745793 757210 789233 789301 789310 789401 793314 796468 807710 814606 815233 820149 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд лиза pussy"
]
|
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.