Query Metrics
7
Database Queries
7
Different statements
362.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.59 ms (58.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy horny"
]
|
||||||||||||||||||||||||||||||
|
127.10 ms (35.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 381963 386518 390214 432683 434903 435611 435625 437562 449699 454040 469486 473724 473868 482585 490664 504331 512664 524820 538024 539326 543219 545684 552192 556853 559789 559868 563114 565647 566250 569382 569852 571887 581377 583602 619147 621459 621537 621603 632296 634760 641176 641418 658853 661941 661949 665063 665134 665508 666974 668623 679698 680946 681307 684672 693388 696310 699788 704912 707981 713598 717509 721438 724197 729180 730163 730301 738461 739903 744823 746477 748322 753190 757225 758177 759575 759982 760617 762244 762369 763447 764004 764082 766698 767928 770184 773044 778864 784471 784704 785011 785014 785468 787373 790139 791301 792772 795776 796974 797053 800345 800953 801093 801474 804648 805030 807200 807235 807440 807755 809669 809948 809966 810208 810356 811351 814670 815739 817086 817957 821691 ] |
||||||||||||||||||||||||||||||
|
16.43 ms (4.53%) |
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 632296 785011 790139 800953 801093 801474 805030 807235 810208 811351 784471 785014 791301 796974 807440 809669 730163 748322 753190 759575 762244 785468 787373 792772 807200 807755 809948 810356 730301 744823 766698 767928 724197 739903 758177 763447 764004 764082 773044 729180 738461 746477 770184 757225 759982 760617 762369 634760 641176 713598 717509 778864 784704 795776 797053 800345 804648 809966 381963 386518 449699 512664 641418 390214 435611 432683 435625 434903 437562 817957 815739 814670 817086 821691 454040 469486 473724 473868 490664 539326 524820 504331 538024 482585 543219 559868 565647 563114 566250 569852 583602 545684 658853 661941 666974 699788 661949 665063 665134 665508 668623 679698 680946 681307 684672 693388 696310 704912 721438 707981 552192 556853 559789 569382 571887 581377 621603 619147 621459 621537 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (0.90%) |
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 381963 386518 390214 432683 434903 435611 435625 437562 449699 454040 469486 473724 473868 482585 490664 504331 512664 524820 538024 539326 543219 545684 552192 556853 559789 559868 563114 565647 566250 569382 569852 571887 581377 583602 619147 621459 621537 621603 632296 634760 641176 641418 658853 661941 661949 665063 665134 665508 666974 668623 679698 680946 681307 684672 693388 696310 699788 704912 707981 713598 717509 721438 724197 729180 730163 730301 738461 739903 744823 746477 748322 753190 757225 758177 759575 759982 760617 762244 762369 763447 764004 764082 766698 767928 770184 773044 778864 784471 784704 785011 785014 785468 787373 790139 791301 792772 795776 796974 797053 800345 800953 801093 801474 804648 805030 807200 807235 807440 807755 809669 809948 809966 810208 810356 811351 814670 815739 817086 817957 821691 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy horny"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy horny"
]
|
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.