Query Metrics
7
Database Queries
7
Different statements
259.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
231.73 ms (89.38%) |
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 205133 382113 383281 383650 385398 403769 406085 423351 426452 446404 450277 452300 453989 457453 461845 461848 463984 464035 465661 467961 468478 468750 473501 488402 495870 495876 495892 496091 500732 522165 530001 530008 530133 530203 532781 533877 536424 543165 543452 548515 551063 553972 554321 556018 562190 563706 565134 566216 566222 566711 569099 569546 570850 570851 571217 574105 576176 576557 577363 580361 580971 591003 595177 598058 598324 601007 601105 601581 601644 603056 603284 603545 603890 604767 604782 604823 604936 610040 614026 614935 630679 631657 642029 645826 660412 693325 710424 712006 714966 715128 720622 725352 725407 727569 727754 727910 727985 727987 729804 730104 730478 735907 736369 740833 749254 749615 752622 753610 756103 758074 777790 796879 797342 800056 807565 815559 819395 819533 822462 ] |
||||||||||||||||||||||||||||||
|
17.32 ms (6.68%) |
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 563706 382113 725352 383281 426452 453989 464035 530133 548515 566711 749615 727987 383650 467961 710424 598058 610040 614935 614026 642029 796879 725407 468478 693325 205133 463984 603890 461845 450277 403769 530001 574105 566216 570850 645826 720622 580361 465661 423351 522165 536424 580971 576557 604782 604823 604767 740833 819533 570851 601105 777790 601007 461848 604936 488402 562190 457453 727569 473501 385398 495876 496091 495892 495870 576176 815559 553972 577363 566222 571217 591003 603056 601644 730104 756103 603545 712006 727754 446404 468750 532781 660412 551063 630679 807565 736369 749254 822462 533877 569099 569546 715128 601581 603284 819395 543165 543452 714966 598324 595177 797342 727910 800056 735907 752622 729804 730478 758074 452300 500732 530008 530203 688681 727985 753610 554321 565134 406085 631657 556018 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.24%) |
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 205133 382113 383281 383650 385398 403769 406085 423351 426452 446404 450277 452300 453989 457453 461845 461848 463984 464035 465661 467961 468478 468750 473501 488402 495870 495876 495892 496091 500732 522165 530001 530008 530133 530203 532781 533877 536424 543165 543452 548515 551063 553972 554321 556018 562190 563706 565134 566216 566222 566711 569099 569546 570850 570851 571217 574105 576176 576557 577363 580361 580971 591003 595177 598058 598324 601007 601105 601581 601644 603056 603284 603545 603890 604767 604782 604823 604936 610040 614026 614935 630679 631657 642029 645826 660412 693325 710424 712006 714966 715128 720622 725352 725407 727569 727754 727910 727985 727987 729804 730104 730478 735907 736369 740833 749254 749615 752622 753610 756103 758074 777790 796879 797342 800056 807565 815559 819395 819533 822462 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие butt мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big butt mother"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие butt мам женщин"
]
|
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.