Query Metrics
7
Database Queries
7
Different statements
170.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.42 ms (84.13%) |
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 383599 397655 399598 405699 418146 419666 423324 426995 429106 429706 433581 435788 435816 439257 440637 441210 448577 448906 449484 449546 449963 452757 452914 458212 460070 465439 467982 469080 478029 478991 482900 493789 495636 496890 497719 503482 509760 510766 513176 514769 516373 517763 518807 521625 522082 523606 524122 524953 525466 526095 527271 528374 530420 531559 533922 536064 540752 542509 546720 547546 547881 547945 553229 553601 554083 554204 555384 555418 555432 556449 557582 558098 560738 560789 562203 562449 568864 569627 574446 575610 577482 579159 580001 581092 582829 584284 586170 586285 586757 590807 591406 598917 600467 600473 600491 601138 601798 604356 609146 611192 617146 625762 629208 639133 642895 650075 650518 652052 659361 660821 662518 669303 678950 686133 686972 714289 757421 772441 782070 782094 ] |
||||||||||||||||||||||||||||||
|
16.24 ms (9.52%) |
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 652052 660821 686133 669303 686972 557582 562203 577482 600467 590807 600473 609146 642895 601138 617146 586757 604356 625762 772441 757421 611192 782070 782094 399598 429706 433581 426995 435816 439257 429106 448577 448906 513176 514769 523606 525466 496890 517763 383599 452757 449484 478991 530420 546720 518807 482900 397655 405699 423324 440637 441210 418146 435788 419666 449546 449963 452914 467982 469080 458212 460070 478029 516373 522082 531559 540752 509760 510766 521625 524953 526095 527271 528374 533922 536064 495636 497719 524122 503482 465439 493789 547546 547881 553229 555384 560738 569627 575610 542509 547945 555418 555432 556449 558098 560789 579159 554083 554204 562449 568864 580001 581092 582829 584284 659361 662518 650075 650518 678950 714289 553601 574446 586285 591406 629208 639133 586170 598917 600491 601798 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.75%) |
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 383599 397655 399598 405699 418146 419666 423324 426995 429106 429706 433581 435788 435816 439257 440637 441210 448577 448906 449484 449546 449963 452757 452914 458212 460070 465439 467982 469080 478029 478991 482900 493789 495636 496890 497719 503482 509760 510766 513176 514769 516373 517763 518807 521625 522082 523606 524122 524953 525466 526095 527271 528374 530420 531559 533922 536064 540752 542509 546720 547546 547881 547945 553229 553601 554083 554204 555384 555418 555432 556449 557582 558098 560738 560789 562203 562449 568864 569627 574446 575610 577482 579159 580001 581092 582829 584284 586170 586285 586757 590807 591406 598917 600467 600473 600491 601138 601798 604356 609146 611192 617146 625762 629208 639133 642895 650075 650518 652052 659361 660821 662518 669303 678950 686133 686972 714289 757421 772441 782070 782094 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam finger"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер палец"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.