Query Metrics
7
Database Queries
7
Different statements
200.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.23 ms (81.49%) |
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 340635 392754 397916 398559 398940 400489 400513 401006 409083 413182 413464 421945 424436 428142 428148 428840 433353 439634 439697 439722 439778 439791 439808 439824 439856 440222 442814 442997 451445 451486 451512 454166 454237 454249 454257 454271 456312 457443 457468 462095 464975 465958 466017 466228 466875 466877 467848 469390 470564 471192 472691 475883 476256 476353 478384 478790 480497 485696 485870 490438 498491 498702 502827 507281 509434 514681 518876 520584 520813 520913 521107 521115 521220 522455 524991 525234 526737 536431 546831 549731 549836 552080 560828 563616 575823 584831 590503 597151 599246 599451 609071 613676 617115 621193 623982 641807 731777 739900 741726 741733 741758 741762 741784 758210 758234 761046 761056 770896 781924 788406 788542 792670 796566 799351 799962 811736 825359 825428 825429 826682 ] |
||||||||||||||||||||||||||||||
|
27.33 ms (13.64%) |
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 546831 549731 584831 549836 560828 641807 597151 609071 599246 613676 621193 623982 781924 788406 788542 799351 811736 741762 741784 796566 731777 741726 758234 761046 741733 741758 770896 739900 758210 761056 792670 799962 340635 409083 413464 457468 462095 464975 465958 471192 472691 478384 451486 466017 476353 478790 480497 398940 428840 451512 467848 476256 400489 400513 413182 454237 454257 456312 457443 428148 433353 470564 507281 525234 526737 485870 498702 502827 520584 521107 536431 509434 520813 520913 518876 521115 521220 522455 524991 514681 575823 552080 563616 590503 599451 617115 424436 442997 451445 469390 439634 439856 454166 466228 466875 475883 428142 439722 466877 392754 397916 398559 401006 421945 439778 439791 439808 439824 440222 442814 454249 454271 439697 490438 485696 498491 825359 825428 825429 826682 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.43%) |
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 340635 392754 397916 398559 398940 400489 400513 401006 409083 413182 413464 421945 424436 428142 428148 428840 433353 439634 439697 439722 439778 439791 439808 439824 439856 440222 442814 442997 451445 451486 451512 454166 454237 454249 454257 454271 456312 457443 457468 462095 464975 465958 466017 466228 466875 466877 467848 469390 470564 471192 472691 475883 476256 476353 478384 478790 480497 485696 485870 490438 498491 498702 502827 507281 509434 514681 518876 520584 520813 520913 521107 521115 521220 522455 524991 525234 526737 536431 546831 549731 549836 552080 560828 563616 575823 584831 590503 597151 599246 599451 609071 613676 617115 621193 623982 641807 731777 739900 741726 741733 741758 741762 741784 758210 758234 761046 761056 770896 781924 788406 788542 792670 796566 799351 799962 811736 825359 825428 825429 826682 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск chubby mature"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian chubby mature"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск chubby mature"
]
|
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.