Query Metrics
7
Database Queries
7
Different statements
377.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.69 ms (54.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
146.01 ms (38.73%) |
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 377241 382633 384917 389733 412220 417226 418388 423311 423324 424352 432418 435106 438339 438444 438452 438816 441659 443519 446561 448894 449957 451638 453204 453905 454836 455396 456342 459521 459949 461615 463343 466642 466708 467982 468398 468434 469658 475390 476664 493427 510483 519110 524622 528346 528520 537757 539470 540911 542055 545568 545821 547881 551597 551604 552998 558519 560457 560931 564999 566083 566294 566595 566917 568258 568757 570889 573293 575699 580786 582835 583694 584868 587212 589390 590485 593561 594053 600373 603330 608881 622874 624287 626120 626379 626746 636059 639133 650206 662537 667047 673006 676208 679306 683449 694442 694958 706411 713062 719192 719794 728048 737552 740084 744070 749482 754453 757566 785541 785610 786898 791445 795554 797149 799212 799459 803600 805198 806938 808463 810787 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (4.34%) |
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 448894 412220 438816 475390 454836 384917 377241 382633 389733 423324 438444 438452 418388 438339 441659 435106 423311 424352 446561 459949 461615 466642 466708 467982 468434 476664 493427 449957 451638 453905 455396 463343 459521 468398 469658 524622 510483 537757 539470 519110 528346 528520 547881 568757 570889 580786 583694 584868 545568 545821 551597 551604 560457 573293 540911 542055 552998 564999 566083 566917 568258 575699 662537 667047 713062 673006 676208 706411 719192 650206 679306 683449 694442 694958 719794 558519 560931 566294 566595 582835 590485 626379 626746 639133 587212 594053 608881 626120 636059 589390 624287 593561 600373 785541 799459 803600 805198 740084 744070 754453 785610 791445 806938 808463 810787 728048 757566 749482 737552 603330 622874 786898 795554 797149 799212 417226 432418 443519 453204 456342 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (1.10%) |
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 377241 382633 384917 389733 412220 417226 418388 423311 423324 424352 432418 435106 438339 438444 438452 438816 441659 443519 446561 448894 449957 451638 453204 453905 454836 455396 456342 459521 459949 461615 463343 466642 466708 467982 468398 468434 469658 475390 476664 493427 510483 519110 524622 528346 528520 537757 539470 540911 542055 545568 545821 547881 551597 551604 552998 558519 560457 560931 564999 566083 566294 566595 566917 568258 568757 570889 573293 575699 580786 582835 583694 584868 587212 589390 590485 593561 594053 600373 603330 608881 622874 624287 626120 626379 626746 636059 639133 650206 662537 667047 673006 676208 679306 683449 694442 694958 706411 713062 719192 719794 728048 737552 740084 744070 749482 754453 757566 785541 785610 786898 791445 795554 797149 799212 799459 803600 805198 806938 808463 810787 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер babe"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam babe"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер babe"
]
|
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.