Query Metrics
7
Database Queries
7
Different statements
504.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
257.66 ms (51.03%) |
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 6643 29272 75896 124062 183343 197690 385123 387324 387817 390835 394152 394772 398771 404432 406659 412018 416131 420062 420240 428513 429205 431794 437335 447834 448662 452218 462484 462970 471898 472225 473959 478854 479771 479995 480037 481282 482485 482950 483470 484148 485713 486188 486222 488086 489122 489429 489933 490152 491891 494552 496661 496859 498199 500468 501679 502036 502894 505899 505909 506886 507517 511887 512102 513721 514818 516413 516641 517699 518780 520243 521749 522490 523007 525413 526209 529288 529878 530453 530538 530599 530730 531185 531345 531377 531973 532238 532292 532692 533396 534700 534781 535544 535948 537594 538158 540192 540829 541177 544289 546293 561887 607500 612245 707739 710372 715904 716170 724202 727298 728655 734002 737448 755108 755799 759805 760127 813473 816419 816880 822177 ] |
||||||||||||||||||||||||||||||
|
215.63 ms (42.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие white сиськ"
]
|
||||||||||||||||||||||||||||||
|
16.84 ms (3.33%) |
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 428513 710372 546293 540829 516641 530453 535544 531345 532292 511887 531377 502036 734002 755799 759805 437335 516413 489122 385123 406659 404432 429205 822177 471898 488086 447834 481282 485713 490152 480037 482950 484148 489429 491891 496859 521749 523007 525413 530538 531973 532692 538158 494552 496661 498199 513721 517699 526209 530599 532238 533396 534781 500468 529878 531185 535948 501679 506886 530730 478854 482485 486222 489933 561887 716170 607500 737448 813473 755108 760127 728655 707739 448662 29272 416131 420062 505909 486188 124062 183343 75896 387817 390835 420240 816419 816880 534700 540192 472225 544289 727298 715904 6643 387324 412018 394772 507517 431794 462484 483470 452218 473959 505899 514818 529288 520243 522490 537594 541177 394152 479995 462970 479771 512102 518780 502894 724202 197690 612245 398771 ] |
||||||||||||||||||||||||||||||
|
9.33 ms (1.85%) |
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 6643 29272 75896 124062 183343 197690 385123 387324 387817 390835 394152 394772 398771 404432 406659 412018 416131 420062 420240 428513 429205 431794 437335 447834 448662 452218 462484 462970 471898 472225 473959 478854 479771 479995 480037 481282 482485 482950 483470 484148 485713 486188 486222 488086 489122 489429 489933 490152 491891 494552 496661 496859 498199 500468 501679 502036 502894 505899 505909 506886 507517 511887 512102 513721 514818 516413 516641 517699 518780 520243 521749 522490 523007 525413 526209 529288 529878 530453 530538 530599 530730 531185 531345 531377 531973 532238 532292 532692 533396 534700 534781 535544 535948 537594 538158 540192 540829 541177 544289 546293 561887 607500 612245 707739 710372 715904 716170 724202 727298 728655 734002 737448 755108 755799 759805 760127 813473 816419 816880 822177 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big white tits"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие white сиськ"
]
|
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.