Query Metrics
7
Database Queries
7
Different statements
385.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.51 ms (54.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
151.04 ms (39.17%) |
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 241603 386759 396961 404585 405114 405116 409259 422053 427543 430244 430818 431341 438284 440826 447911 448055 448084 448104 449869 449880 450312 451672 452189 453648 453686 453705 459620 463159 464308 465472 466092 468702 468724 473439 476117 478037 478933 480645 481584 485285 486868 488954 490188 495660 501529 502792 503418 503556 503565 505394 509590 509637 509656 509923 510844 512541 514004 514565 515025 520217 523034 523441 526213 529227 531435 532629 533040 533643 537591 537937 541220 546838 553283 562059 563827 569133 569544 577037 577402 580765 589708 590410 598376 599203 600453 603507 607509 607640 607694 607696 609102 621426 633521 665781 667975 668668 705424 716765 756469 758079 760211 761066 769502 770897 788260 793662 797461 801348 801941 802379 808537 811152 812911 813101 813532 814971 814981 814983 815714 819920 ] |
||||||||||||||||||||||||||||||
|
17.06 ms (4.42%) |
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 452189 490188 509590 453686 515025 797461 808537 811152 520217 529227 465472 509923 523034 541220 607696 466092 396961 405116 430244 537591 577037 603507 814981 814983 468702 607509 801348 760211 793662 761066 769502 801941 459620 512541 501529 514565 478037 485285 815714 533040 531435 553283 609102 241603 546838 590410 758079 451672 464308 523441 509656 453648 478933 448104 503565 505394 514004 819920 450312 510844 716765 812911 770897 386759 814971 509637 503418 665781 607640 463159 488954 473439 440826 802379 813101 589708 532629 449869 447911 563827 599203 405114 480645 526213 705424 422053 430818 468724 533643 598376 788260 580765 813532 453705 448055 502792 577402 621426 486868 431341 503556 404585 448084 600453 449880 476117 537937 481584 607694 495660 569133 427543 668668 633521 569544 756469 438284 409259 562059 667975 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (0.70%) |
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 241603 386759 396961 404585 405114 405116 409259 422053 427543 430244 430818 431341 438284 440826 447911 448055 448084 448104 449869 449880 450312 451672 452189 453648 453686 453705 459620 463159 464308 465472 466092 468702 468724 473439 476117 478037 478933 480645 481584 485285 486868 488954 490188 495660 501529 502792 503418 503556 503565 505394 509590 509637 509656 509923 510844 512541 514004 514565 515025 520217 523034 523441 526213 529227 531435 532629 533040 533643 537591 537937 541220 546838 553283 562059 563827 569133 569544 577037 577402 580765 589708 590410 598376 599203 600453 603507 607509 607640 607694 607696 609102 621426 633521 665781 667975 668668 705424 716765 756469 758079 760211 761066 769502 770897 788260 793662 797461 801348 801941 802379 808537 811152 812911 813101 813532 814971 814981 814983 815714 819920 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big curvy"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие curvy"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие curvy"
]
|
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.