Query Metrics
7
Database Queries
7
Different statements
189.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.78 ms (86.80%) |
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 439441 440828 443470 443475 445667 449432 450117 450119 450123 450149 450847 452324 453463 455966 458378 463699 465001 476724 477188 482456 486751 486757 486860 486876 486881 486941 487346 491110 495221 496949 498310 502706 503506 504655 506075 506902 508239 508784 509174 511780 515320 516047 516220 516288 516904 523134 526578 528563 528931 536443 536982 539347 541313 544275 544423 545851 545939 546882 554501 555404 555987 557901 558099 574444 577509 583146 584693 590254 590270 590761 593865 598124 598862 603340 614407 614833 628661 629804 652773 653395 658459 714534 717965 719918 720530 724678 725228 726590 730494 731124 731164 731177 732744 741771 742575 742769 744786 746121 746124 753549 759014 770181 771221 776204 778289 786459 787479 788301 790998 793097 794106 795848 795963 796009 802057 804602 823928 824130 825328 825831 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (7.78%) |
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 536982 541313 658459 453463 526578 546882 486757 528563 443470 476724 653395 590761 825328 555404 614833 628661 804602 795848 787479 744786 770181 724678 742769 449432 486941 536443 450847 516220 450119 450123 496949 504655 714534 603340 598862 796009 746124 717965 719918 511780 509174 443475 450149 629804 486881 508784 486876 487346 502706 506075 544275 554501 584693 577509 598124 440828 515320 503506 450117 545851 486860 495221 516288 583146 652773 730494 486751 465001 590270 508239 528931 439441 823928 482456 574444 776204 786459 794106 746121 725228 742575 726590 731164 802057 458378 539347 545939 516047 558099 824130 445667 506902 498310 544423 557901 720530 614407 731124 731177 795963 753549 771221 741771 732744 759014 477188 463699 523134 555987 593865 590254 516904 452324 491110 825831 455966 790998 778289 788301 793097 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.74%) |
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 439441 440828 443470 443475 445667 449432 450117 450119 450123 450149 450847 452324 453463 455966 458378 463699 465001 476724 477188 482456 486751 486757 486860 486876 486881 486941 487346 491110 495221 496949 498310 502706 503506 504655 506075 506902 508239 508784 509174 511780 515320 516047 516220 516288 516904 523134 526578 528563 528931 536443 536982 539347 541313 544275 544423 545851 545939 546882 554501 555404 555987 557901 558099 574444 577509 583146 584693 590254 590270 590761 593865 598124 598862 603340 614407 614833 628661 629804 652773 653395 658459 714534 717965 719918 720530 724678 725228 726590 730494 731124 731164 731177 732744 741771 742575 742769 744786 746121 746124 753549 759014 770181 771221 776204 778289 786459 787479 788301 790998 793097 794106 795848 795963 796009 802057 804602 823928 824130 825328 825831 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature дрочк член cum"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature дрочк член cum"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature handjob cum"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.