Query Metrics
7
Database Queries
7
Different statements
178.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.94 ms (87.79%) |
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 172340 355652 385040 387304 387346 388226 390574 390970 391048 398609 401414 401513 408766 408783 409743 417650 419585 424729 424918 425366 425424 427449 428850 431497 435618 435645 443582 446480 457407 457749 457752 459262 460074 460474 462288 469800 469803 471168 473755 473774 484281 492637 500684 512204 529825 530639 533132 535555 538674 546039 547130 552013 552016 553259 554340 571157 575344 578559 582669 583406 584093 587898 595056 600455 602691 602983 610017 613040 618318 622336 622643 623568 635061 645662 645673 650495 651565 655882 658187 658556 660979 674463 674469 678758 694200 707727 711290 712184 715293 717274 717281 717289 721756 724590 729857 731503 731576 734492 740831 741098 741812 749807 749812 750447 750943 753216 760216 762136 766781 772011 777426 787884 788987 790344 791307 797376 805057 811868 826441 828213 ] |
||||||||||||||||||||||||||||||
|
12.78 ms (7.15%) |
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 622643 602983 618318 711290 712184 797376 419585 484281 717274 694200 492637 750943 741098 760216 741812 575344 457407 584093 655882 645673 658187 658556 674463 595056 613040 731503 707727 471168 398609 390970 622336 750447 387304 387346 553259 587898 417650 678758 811868 571157 401414 469800 469803 401513 408783 425424 435618 457749 552013 552016 390574 435645 172340 530639 715293 717289 788987 790344 753216 724590 731576 762136 749807 749812 772011 623568 535555 583406 651565 674469 645662 660979 547130 610017 635061 602691 600455 427449 457752 385040 512204 650495 828213 554340 428850 424729 443582 446480 460074 473755 473774 500684 533132 546039 582669 460474 538674 408766 391048 424918 425366 462288 826441 529825 791307 734492 805057 409743 459262 355652 388226 431497 578559 717281 740831 766781 729857 721756 777426 787884 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.51%) |
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 172340 355652 385040 387304 387346 388226 390574 390970 391048 398609 401414 401513 408766 408783 409743 417650 419585 424729 424918 425366 425424 427449 428850 431497 435618 435645 443582 446480 457407 457749 457752 459262 460074 460474 462288 469800 469803 471168 473755 473774 484281 492637 500684 512204 529825 530639 533132 535555 538674 546039 547130 552013 552016 553259 554340 571157 575344 578559 582669 583406 584093 587898 595056 600455 602691 602983 610017 613040 618318 622336 622643 623568 635061 645662 645673 650495 651565 655882 658187 658556 660979 674463 674469 678758 694200 707727 711290 712184 715293 717274 717281 717289 721756 724590 729857 731503 731576 734492 740831 741098 741812 749807 749812 750447 750943 753216 760216 762136 766781 772011 777426 787884 788987 790344 791307 797376 805057 811868 826441 828213 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк любительск"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк любительск"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian amateur"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.