Query Metrics
7
Database Queries
7
Different statements
202.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.65 ms (88.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 399061 448499 452320 457375 457392 478985 478990 478991 478992 493053 511218 512814 522088 522399 529698 542297 542299 542340 542342 543016 543032 543113 543116 543123 543150 543189 543196 543204 543283 543292 549148 554113 554117 567572 567603 567606 574973 576869 577076 577088 577111 577112 577119 578130 578202 578319 588561 591798 600468 602293 602485 603302 604419 611044 613724 614419 615331 618763 619816 621246 622932 625027 625032 626382 628510 628634 630570 633289 633412 636660 637802 638993 642456 658135 658553 660436 660455 660834 660837 666371 670853 678850 685086 685103 717617 726624 729121 734346 736752 740554 742515 744774 747035 749510 750289 751354 752104 753128 767197 769849 769944 789488 789518 796761 797109 797130 797889 798033 800125 811536 813816 813826 813831 813856 813858 825366 825367 825404 827861 ] |
||||||||||||||||||||||||||||||
|
14.97 ms (7.39%) |
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 577111 750289 512814 542297 577088 666371 577076 600468 618763 633289 789518 767197 452320 478991 685103 567603 578202 658553 611044 813831 769944 493053 542342 543116 543196 633412 800125 744774 638993 613724 522088 543032 543292 577119 602485 637802 591798 614419 751354 813856 796761 740554 660834 813816 511218 543016 543150 567572 543123 658135 670853 621246 602293 478992 522399 813826 615331 729121 736752 769790 747035 457392 543204 588561 642456 636660 753128 749510 543113 567606 578319 603302 478985 478990 542299 811536 825367 827861 529698 660837 685086 630570 628510 798033 797130 769849 726624 742515 625032 626382 604419 825366 813858 542340 543283 554113 660455 717617 554117 576869 625027 628634 734346 797109 797889 752104 543189 578130 619816 399061 789488 622932 825404 457375 448499 549148 577112 574973 678850 660436 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.54%) |
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 399061 448499 452320 457375 457392 478985 478990 478991 478992 493053 511218 512814 522088 522399 529698 542297 542299 542340 542342 543016 543032 543113 543116 543123 543150 543189 543196 543204 543283 543292 549148 554113 554117 567572 567603 567606 574973 576869 577076 577088 577111 577112 577119 578130 578202 578319 588561 591798 600468 602293 602485 603302 604419 611044 613724 614419 615331 618763 619816 621246 622932 625027 625032 626382 628510 628634 630570 633289 633412 636660 637802 638993 642456 658135 658553 660436 660455 660834 660837 666371 670853 678850 685086 685103 717617 726624 729121 734346 736752 740554 742515 744774 747035 749510 750289 751354 752104 753128 767197 769849 769944 789488 789518 796761 797109 797130 797889 798033 800125 811536 813816 813826 813831 813856 813858 825366 825367 825404 827861 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"arab wife"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.61%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"араб жен"
]
|
||||||||||||||||||||||||||||||
|
1.13 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"араб жен"
]
|
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.