Query Metrics
7
Database Queries
7
Different statements
149.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.71 ms (82.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 293499 383599 397655 405699 418146 419666 423324 424270 425452 429217 429706 433581 434576 435788 439264 439271 440637 441210 444204 448609 449546 449963 451695 451701 452757 452890 452914 458212 460070 461022 465439 467982 468907 469080 471020 478029 478991 483313 493789 495636 496351 497719 509760 510029 510766 511612 516373 522082 524122 524935 524953 526095 527271 528374 529769 529997 530420 531559 533922 536064 539302 540752 542509 545774 547881 547945 553229 554083 554204 554620 555442 556449 557582 558098 560738 560789 562449 569627 575610 576254 577482 579159 580001 581092 582829 583384 584284 586170 586285 586757 590702 590807 590963 595524 595574 600467 600491 601138 601367 602874 609146 611192 617146 621048 624174 625762 639102 639133 640975 650075 650518 652052 659361 662518 678950 714289 748996 757421 772441 784896 ] |
||||||||||||||||||||||||||||||
|
15.53 ms (10.36%) |
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 511612 554620 583384 576254 748996 471020 539302 529997 545774 652052 557582 577482 600467 590807 609146 617146 586757 772441 757421 429706 433581 423324 419666 452914 478029 516373 526095 533922 536064 579159 580001 586170 595574 293499 451695 452890 483313 524935 441210 435788 449546 449963 460070 531559 524953 528374 497719 582829 678950 621048 624174 601367 590963 640975 434576 439271 448609 451701 439264 429217 444204 529769 496351 383599 452757 478991 530420 405699 418146 467982 469080 458212 522082 540752 510766 524122 465439 553229 560738 569627 575610 547945 556449 562449 584284 662518 650075 714289 639133 600491 590702 595524 602874 639102 784896 424270 461022 425452 468907 510029 555442 601138 625762 611192 397655 440637 509760 527271 495636 493789 547881 542509 558098 560789 554083 554204 581092 659361 650518 586285 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.18%) |
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 293499 383599 397655 405699 418146 419666 423324 424270 425452 429217 429706 433581 434576 435788 439264 439271 440637 441210 444204 448609 449546 449963 451695 451701 452757 452890 452914 458212 460070 461022 465439 467982 468907 469080 471020 478029 478991 483313 493789 495636 496351 497719 509760 510029 510766 511612 516373 522082 524122 524935 524953 526095 527271 528374 529769 529997 530420 531559 533922 536064 539302 540752 542509 545774 547881 547945 553229 554083 554204 554620 555442 556449 557582 558098 560738 560789 562449 569627 575610 576254 577482 579159 580001 581092 582829 583384 584284 586170 586285 586757 590702 590807 590963 595524 595574 600467 600491 601138 601367 602874 609146 611192 617146 621048 624174 625762 639102 639133 640975 650075 650518 652052 659361 662518 678950 714289 748996 757421 772441 784896 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam girl finger"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер девушк палец"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.05%) |
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.