Query Metrics
7
Database Queries
7
Different statements
391.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.55 ms (54.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
152.52 ms (38.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 21478 204376 381753 387033 387215 389803 392918 394768 396037 399869 400668 401549 401840 406314 408206 411925 414156 419644 428082 429405 432081 435487 444477 445553 446701 446968 448670 448678 453325 453438 454091 454699 456079 457600 458934 461029 466524 468797 468956 469561 476946 481637 494758 497653 500949 501055 510199 513909 519694 521186 528700 529190 530572 530574 534781 545288 553367 555754 558194 564152 568930 572265 572858 582445 592953 593831 608422 617441 621066 630751 635194 642723 642851 645795 646001 650431 678959 702571 731458 735610 748340 752229 758567 760739 766886 767189 770546 773813 774293 775754 797505 800667 804193 807533 807583 809334 810249 811897 812502 813654 813879 818871 819081 819340 819463 821355 821590 821611 821621 822079 822470 822769 823043 824177 824472 824740 826100 826301 828411 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (3.99%) |
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 534781 387033 408206 528700 642723 592953 810249 774293 821355 821621 381753 401549 824177 572265 807533 419644 630751 646001 501055 645795 809334 432081 823043 396037 819081 821611 828411 444477 454091 453438 466524 445553 468956 760739 400668 387215 797505 553367 811897 752229 735610 773813 731458 608422 807583 813654 454699 540323 572858 678959 642851 775754 800667 804193 204376 448678 582445 428082 469561 635194 389803 468797 530574 564152 617441 770546 401840 497653 819340 558194 826100 822470 824472 824740 813879 545288 555754 702571 621066 758567 513909 521186 392918 435487 414156 446701 500949 529190 767189 826301 456079 458934 476946 461029 481637 568930 399869 406314 394768 21478 812502 429405 650431 821590 448670 457600 494758 822769 818871 819463 822079 748340 766886 510199 530572 593831 446968 453325 519694 411925 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (0.88%) |
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 21478 204376 381753 387033 387215 389803 392918 394768 396037 399869 400668 401549 401840 406314 408206 411925 414156 419644 428082 429405 432081 435487 444477 445553 446701 446968 448670 448678 453325 453438 454091 454699 456079 457600 458934 461029 466524 468797 468956 469561 476946 481637 494758 497653 500949 501055 510199 513909 519694 521186 528700 529190 530572 530574 534781 545288 553367 555754 558194 564152 568930 572265 572858 582445 592953 593831 608422 617441 621066 630751 635194 642723 642851 645795 646001 650431 678959 702571 731458 735610 748340 752229 758567 760739 766886 767189 770546 773813 774293 775754 797505 800667 804193 807533 807583 809334 810249 811897 812502 813654 813879 818871 819081 819340 819463 821355 821590 821611 821621 822079 822470 822769 823043 824177 824472 824740 826100 826301 828411 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina big tits"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.45%) |
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.