Query Metrics
7
Database Queries
7
Different statements
206.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.31 ms (85.21%) |
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 395751 395826 399874 401134 401343 404698 404884 405100 414319 415658 416086 418416 419888 422513 422617 422633 422958 425878 432752 452317 453162 463118 463815 463873 465524 466599 469576 473182 477441 480945 485784 488929 493194 493232 494370 495558 497368 498119 501148 503127 508189 512049 512495 513358 514805 517217 519157 519248 519553 521588 523274 525046 525529 529846 537893 547366 551915 554472 555948 556014 556022 558119 558131 564636 565162 567424 572763 583677 595873 597227 599856 603970 605315 605323 605347 619397 622331 624175 628406 630828 632028 632033 632979 633114 633533 633733 633750 634499 637094 637427 642691 646838 651188 659215 660754 660963 666546 679387 684993 691992 718525 719011 719067 733840 733879 744704 757105 759639 766852 771180 790234 800533 801165 809899 811425 812922 815430 819579 826154 ] |
||||||||||||||||||||||||||||||
|
19.56 ms (9.45%) |
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 512049 537893 660963 662221 684993 719067 603970 401343 465524 555948 572763 637427 415658 815430 819579 463118 691992 660754 619397 605315 632028 605347 811425 800533 809899 757105 771180 719011 401134 416086 523274 556022 605323 633750 633533 634499 801165 744704 718525 812922 405100 525529 493232 512495 521588 493194 494370 422958 514805 519248 551915 558131 622331 495558 630828 766852 414319 826154 395751 404698 469576 453162 503127 508189 517217 525046 529846 558119 583677 646838 666546 556014 565162 599856 595873 633733 642691 628406 632979 624175 637094 790234 733840 633114 425878 480945 418416 463815 473182 422513 497368 498119 513358 519157 519553 395826 404884 419888 422617 422633 432752 488929 485784 452317 501148 547366 567424 554472 564636 679387 651188 659215 632033 597227 759639 733879 463873 477441 399874 466599 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.55%) |
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 395751 395826 399874 401134 401343 404698 404884 405100 414319 415658 416086 418416 419888 422513 422617 422633 422958 425878 432752 452317 453162 463118 463815 463873 465524 466599 469576 473182 477441 480945 485784 488929 493194 493232 494370 495558 497368 498119 501148 503127 508189 512049 512495 513358 514805 517217 519157 519248 519553 521588 523274 525046 525529 529846 537893 547366 551915 554472 555948 556014 556022 558119 558131 564636 565162 567424 572763 583677 595873 597227 599856 603970 605315 605323 605347 619397 622331 624175 628406 630828 632028 632033 632979 633114 633533 633733 633750 634499 637094 637427 642691 646838 651188 659215 660754 660963 666546 679387 684993 691992 718525 719011 719067 733840 733879 744704 757105 759639 766852 771180 790234 800533 801165 809899 811425 812922 815430 819579 826154 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal young tits"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал young сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал young сиськ"
]
|
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.