Query Metrics
7
Database Queries
7
Different statements
203.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.59 ms (86.14%) |
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 401000 401007 407809 411077 413426 419218 419529 434561 439589 439680 442146 443935 443973 444100 444580 446851 447140 447235 448489 454867 457308 460599 460923 466080 466228 466312 467575 467854 470017 470935 470945 473248 476415 477955 477982 479149 479356 484163 484470 484575 484584 484686 492334 492335 492730 498012 498822 498912 503955 503961 506436 506561 509764 511119 512516 512954 513131 517577 518328 518334 518609 518840 520428 521370 521872 522386 522526 523309 524131 526956 528266 528270 529100 529381 534833 544418 545530 547889 549243 552763 556494 557571 558021 558645 559009 559561 560449 565778 567382 567383 567384 567593 567746 573744 574486 577290 579958 585711 588196 591954 594525 595799 600132 603034 605224 605851 612398 613973 614431 618612 623089 624962 626189 634725 641910 651561 675107 675374 687849 805852 ] |
||||||||||||||||||||||||||||||
|
18.82 ms (9.23%) |
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 552763 626189 613973 805852 413426 466312 498912 594525 675107 687849 600132 612398 618612 521370 529381 549243 567746 573744 476415 518609 521872 518334 442146 407809 447140 460923 467575 492730 513131 534833 522386 467854 558021 567383 547889 567384 544418 560449 574486 556494 558645 565778 579958 588196 605851 470945 477955 470935 470017 509764 492335 503955 523309 484686 492334 522526 419218 605224 447235 457308 479356 484163 651561 641910 634725 473248 454867 545530 498012 506561 443935 448489 518328 559561 567382 585711 603034 446851 401007 434561 439589 460599 466228 443973 477982 524131 528270 503961 506436 518840 557571 444580 411077 444100 466080 511119 484470 484584 526956 512954 567593 559009 614431 624962 479149 512516 484575 529100 498822 528266 419529 520428 623089 675374 401000 517577 439680 577290 595799 591954 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.25%) |
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 401000 401007 407809 411077 413426 419218 419529 434561 439589 439680 442146 443935 443973 444100 444580 446851 447140 447235 448489 454867 457308 460599 460923 466080 466228 466312 467575 467854 470017 470935 470945 473248 476415 477955 477982 479149 479356 484163 484470 484575 484584 484686 492334 492335 492730 498012 498822 498912 503955 503961 506436 506561 509764 511119 512516 512954 513131 517577 518328 518334 518609 518840 520428 521370 521872 522386 522526 523309 524131 526956 528266 528270 529100 529381 534833 544418 545530 547889 549243 552763 556494 557571 558021 558645 559009 559561 560449 565778 567382 567383 567384 567593 567746 573744 574486 577290 579958 585711 588196 591954 594525 595799 600132 603034 605224 605851 612398 613973 614431 618612 623089 624962 626189 634725 641910 651561 675107 675374 687849 805852 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur kissing"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск kissing"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск kissing"
]
|
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.