Query Metrics
8
Database Queries
8
Different statements
294.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.39 ms (56.22%) |
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 3575 6981 197389 282099 397457 399837 400730 400818 401267 402160 404185 417491 418871 421908 424096 424388 425601 429444 441853 445895 451221 452241 452304 454156 456202 456687 461148 461424 462113 474126 478363 479758 480004 484633 486742 486917 490410 490428 499906 500876 559682 564566 566393 566981 570241 573320 581255 591894 596274 619482 625250 626254 626256 630032 637450 641231 662171 688248 695603 704261 707429 707502 710400 712253 713405 716288 718492 722330 726245 726747 728300 728447 729002 730100 731783 731832 736836 740641 741611 744450 744996 747312 748811 749909 751434 756351 758801 759756 761090 761483 766691 768729 768949 769997 770139 770187 770242 770810 771013 771039 772480 777004 785121 794900 796527 800494 801267 801268 803108 804504 805241 807425 809654 810243 814398 817869 819609 822934 823295 823746 ] |
||||||||||||||||||||||||||||||
|
98.13 ms (33.36%) |
1 |
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance` FROM `search_log` WHERE MATCH (`query`) AGAINST (?) AND `query` <> ? AND `blocked` = 0 ORDER BY `relevance` DESC LIMIT ?
Parameters:
[ "big-natural-tits anal" "big-natural-tits anal" "big-natural-tits anal" 20 ] |
||||||||||||||||||||||||||||||
|
19.81 ms (6.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 637450 800494 722330 626254 736836 749909 770187 662171 451221 747312 445895 474126 499906 490410 484633 399837 823295 822934 817869 758801 744450 756351 761090 710400 596274 461424 424096 418871 573320 619482 823746 814398 581255 707429 777004 801268 807425 726245 726747 769997 731783 748811 785121 566393 730100 731832 729002 804504 421908 456202 462113 429444 424388 417491 695603 809654 810243 770139 771039 772480 796527 759756 768729 770242 766691 771013 803108 404185 741611 486917 479758 400818 500876 480004 486742 461148 452241 490428 626256 197389 570241 713405 559682 282099 6981 712253 744996 454156 400730 401267 819609 801267 716288 740641 768949 718492 402160 397457 425601 591894 641231 805241 770810 794900 566981 688248 630032 728300 728447 761483 751434 707502 3575 564566 704261 456687 478363 441853 452304 625250 ] |
||||||||||||||||||||||||||||||
|
4.13 ms (1.40%) |
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 3575 6981 197389 282099 397457 399837 400730 400818 401267 402160 404185 417491 418871 421908 424096 424388 425601 429444 441853 445895 451221 452241 452304 454156 456202 456687 461148 461424 462113 474126 478363 479758 480004 484633 486742 486917 490410 490428 499906 500876 559682 564566 566393 566981 570241 573320 581255 591894 596274 619482 625250 626254 626256 630032 637450 641231 662171 688248 695603 704261 707429 707502 710400 712253 713405 716288 718492 722330 726245 726747 728300 728447 729002 730100 731783 731832 736836 740641 741611 744450 744996 747312 748811 749909 751434 756351 758801 759756 761090 761483 766691 768729 768949 769997 770139 770187 770242 770810 771013 771039 772480 777004 785121 794900 796527 800494 801267 801268 803108 804504 805241 807425 809654 810243 814398 817869 819609 822934 823295 823746 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big-natural-tits anal"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие натуральная натуральные сиськ без силикон анал"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.49%) |
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.