Query Metrics
7
Database Queries
7
Different statements
166.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.53 ms (81.98%) |
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 399520 417738 448445 452082 452441 461394 463215 463266 463963 464138 465824 475796 476709 479322 482602 484650 484661 484708 488301 498501 502277 512194 513358 513689 513751 515152 516795 517067 518206 518273 518549 518558 520159 521785 523008 541076 544295 544505 545393 545602 545604 549176 557608 563874 564213 565259 565262 567151 567474 577502 580377 581193 583622 583897 587598 589786 592034 594863 596069 598032 598092 598498 598546 598653 600503 603622 603970 606571 619439 619569 623840 623874 627809 627814 628366 628384 628387 628390 628396 628398 628406 630524 631202 631965 632588 632689 632979 633718 634482 637004 637080 637093 637094 637422 640772 640797 642043 642751 645019 647333 647906 648543 649525 650158 666878 668525 680159 680167 680182 704523 716043 721846 722796 733840 733870 748957 800588 811497 820759 823298 ] |
||||||||||||||||||||||||||||||
|
19.05 ms (11.44%) |
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 680167 721846 583897 587598 598498 627809 631965 598546 606571 632689 598092 600503 628366 628387 628390 628406 632588 632979 642751 596069 637004 637080 637094 640772 640797 800588 811497 733840 748957 733870 642043 716043 722796 465824 518206 484650 484708 513358 518558 502277 484661 515152 823298 463963 482602 464138 479322 452441 512194 518273 523008 513751 498501 520159 544505 577502 580377 564213 567474 544295 557608 563874 589786 598032 603970 623840 623874 594863 417738 461394 463266 399520 513689 516795 567151 820759 452082 463215 476709 448445 488301 518549 517067 521785 475796 545602 545604 581193 583622 541076 565259 645019 648543 649525 668525 680182 666878 704523 647333 647906 650158 680159 545393 549176 565262 592034 619569 633718 634482 637093 637422 628384 630524 598653 603622 619439 627814 628396 628398 631202 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.63%) |
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 399520 417738 448445 452082 452441 461394 463215 463266 463963 464138 465824 475796 476709 479322 482602 484650 484661 484708 488301 498501 502277 512194 513358 513689 513751 515152 516795 517067 518206 518273 518549 518558 520159 521785 523008 541076 544295 544505 545393 545602 545604 549176 557608 563874 564213 565259 565262 567151 567474 577502 580377 581193 583622 583897 587598 589786 592034 594863 596069 598032 598092 598498 598546 598653 600503 603622 603970 606571 619439 619569 623840 623874 627809 627814 628366 628384 628387 628390 628396 628398 628406 630524 631202 631965 632588 632689 632979 633718 634482 637004 637080 637093 637094 637422 640772 640797 642043 642751 645019 647333 647906 648543 649525 650158 666878 668525 680159 680167 680182 704523 716043 721846 722796 733840 733870 748957 800588 811497 820759 823298 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man jerking"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин дрочк"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин дрочк"
]
|
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.