Query Metrics
7
Database Queries
7
Different statements
197.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.56 ms (87.52%) |
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 185432 205011 386781 394152 396389 398382 403579 410319 419096 420785 425636 427561 434558 435162 437335 439634 440156 444698 446755 448373 450421 451687 453890 453922 454384 456616 460172 462095 462659 463896 469381 472063 474073 474720 478596 478839 478840 481278 484754 485158 485699 487415 489184 491765 492376 492438 492711 494758 506924 506948 514273 514814 520527 524562 527054 527919 528921 528925 529133 529422 531724 535012 535455 539800 545639 547065 550517 552055 554325 554411 557129 559854 560155 560521 566323 566743 567119 572929 582792 584434 586515 594221 598038 601180 606032 606644 613152 613224 619480 619511 622459 624739 630567 638742 640895 643489 664858 676208 677279 687511 710228 715394 750454 759712 760837 784652 791034 794223 797637 798963 798966 799409 802239 802312 808068 810830 812755 813388 815594 815600 ] |
||||||||||||||||||||||||||||||
|
15.19 ms (7.70%) |
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 586515 425636 487415 552055 664858 434558 419096 531724 797637 784652 420785 492711 472063 492376 545639 619480 444698 448373 460172 485699 539800 572929 715394 640895 802239 394152 514273 489184 529133 474073 601180 462659 550517 676208 594221 453890 494758 463896 554325 567119 606644 613152 638742 813388 808068 759712 527919 524562 484754 410319 435162 560155 598038 760837 815594 687511 559854 802312 799409 437335 528921 815600 566323 427561 520527 643489 791034 624739 478839 474720 456616 485158 535455 547065 554411 481278 450421 613224 798963 453922 478840 514814 491765 469381 560521 527054 619511 440156 403579 205011 630567 750454 529422 478596 439634 528925 386781 451687 506948 506924 710228 810830 794223 622459 798966 812755 446755 492438 396389 566743 606032 462095 454384 557129 185432 398382 677279 535012 582792 584434 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.47%) |
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 185432 205011 386781 394152 396389 398382 403579 410319 419096 420785 425636 427561 434558 435162 437335 439634 440156 444698 446755 448373 450421 451687 453890 453922 454384 456616 460172 462095 462659 463896 469381 472063 474073 474720 478596 478839 478840 481278 484754 485158 485699 487415 489184 491765 492376 492438 492711 494758 506924 506948 514273 514814 520527 524562 527054 527919 528921 528925 529133 529422 531724 535012 535455 539800 545639 547065 550517 552055 554325 554411 557129 559854 560155 560521 566323 566743 567119 572929 582792 584434 586515 594221 598038 601180 606032 606644 613152 613224 619480 619511 622459 624739 630567 638742 640895 643489 664858 676208 677279 687511 710228 715394 750454 759712 760837 784652 791034 794223 797637 798963 798966 799409 802239 802312 808068 810830 812755 813388 815594 815600 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs sex"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs секс"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs секс"
]
|
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.