Query Metrics
7
Database Queries
7
Different statements
389.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.39 ms (52.98%) |
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 381888 382827 388067 404395 406982 409621 414194 431587 433049 436758 438787 439349 442344 443858 444691 446950 447012 447073 447501 447562 447902 449171 449404 452220 452671 452683 452782 452978 453058 455028 455190 458488 459278 459560 460988 461319 461716 462797 464244 465129 471916 473849 475829 476675 478791 482850 484053 484061 487995 489874 494099 499685 499868 501909 504553 504711 507434 513690 527332 545750 548912 552763 564984 565722 567315 574886 575275 578189 578387 586727 587883 587890 592429 598528 610833 622722 623120 624527 625288 626220 635079 636149 636760 658311 658713 659151 659300 666006 684722 692032 695789 722816 732119 743447 751063 751592 754432 754548 754915 755244 759441 766475 768431 771772 773144 778249 778253 778875 779323 780123 785870 788645 790531 791439 794009 797125 799544 803609 816247 ] |
||||||||||||||||||||||||||||||
|
160.87 ms (41.29%) |
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 381888 382827 388067 404395 406982 409621 414194 431587 433049 436758 438787 439349 442344 443858 444691 446950 447012 447073 447501 447562 447902 449171 449404 452220 452671 452683 452782 452978 453058 455028 455190 458488 459278 459560 460988 461319 461716 462797 464244 465129 471916 473849 475829 476675 478791 482850 484053 484061 487995 489874 494099 499685 499868 501909 504553 504711 507434 513690 527332 545750 548912 552763 564984 565722 567315 574886 575275 578189 578387 586727 587883 587890 592429 598528 610833 622722 623120 624527 625288 626220 635079 636149 636760 658311 658713 659151 659300 666006 684722 692032 695789 722816 732119 743447 751063 751592 754432 754548 754915 755244 759441 766475 768431 771772 773144 778249 778253 778875 779323 780123 785870 788645 790531 791439 794009 797125 799544 803609 816247 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (3.89%) |
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 684722 658311 658713 659151 692032 695789 636149 636760 624527 625288 635079 778249 788645 791439 754432 790531 797125 766475 765166 771772 773144 754548 759441 743447 755244 778253 778875 785870 799544 388067 504553 442344 504711 578387 574886 439349 464244 381888 382827 431587 452220 507434 449404 575275 565722 659300 587890 587883 404395 465129 436758 447012 460988 447562 501909 482850 487995 494099 527332 545750 751063 754915 751592 768431 779323 780123 484053 499868 598528 803609 732119 414194 458488 452683 459560 476675 447501 489874 484061 513690 816247 475829 409621 471916 499685 446950 452978 666006 548912 722816 592429 794009 433049 443858 452782 478791 447902 564984 567315 552763 578189 610833 622722 586727 626220 623120 438787 455190 444691 447073 449171 452671 453058 455028 459278 461319 461716 462797 473849 406982 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian tattoo girl"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск татуированные девушк"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.41%) |
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.