Query Metrics
7
Database Queries
7
Different statements
207.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.35 ms (86.63%) |
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 38452 56464 73421 191312 266184 382436 383443 389806 389864 395662 395731 396315 398348 399295 400747 401637 402128 402135 402963 403000 406378 413109 413216 419598 420926 425299 428685 432189 434541 437676 460974 469094 469202 477876 483259 485912 487548 490679 491916 493115 495508 495582 497189 498061 502321 504335 505186 505494 505834 515392 515486 515662 518771 519937 523491 524263 524755 524902 533351 534660 535318 535672 536279 537548 537576 537717 539446 539458 539570 544339 547741 547780 559881 566063 569582 573179 590231 593149 598310 604086 604877 608432 609977 612110 625451 638550 644253 645366 649859 663786 665076 670748 676248 676388 676581 693991 702793 716568 718769 722035 726593 737397 741052 752161 756671 757562 768560 768591 774141 774728 775679 783151 784237 800416 803233 803972 804116 806508 808468 810675 ] |
||||||||||||||||||||||||||||||
|
15.99 ms (7.72%) |
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 515486 524902 498061 518771 535672 487548 491916 523491 524263 490679 497189 504335 505834 56464 420926 539570 644253 604877 609977 625451 806508 741052 774141 718769 395731 401637 432189 434541 547741 670748 716568 722035 808468 756671 389806 398348 469094 519937 485912 515662 400747 702793 803233 402963 191312 537576 537548 537717 676248 590231 612110 73421 403000 406378 396315 539458 559881 544339 649859 593149 604086 774728 757562 768560 768591 726593 775679 803972 804116 810675 413109 413216 266184 402135 383443 460974 515392 495508 539446 535318 399295 402128 524755 566063 569582 676388 547780 598310 638550 784237 752161 737397 783151 419598 425299 477876 38452 389864 395662 428685 469202 437676 502321 505186 505494 483259 493115 495582 533351 382436 536279 534660 573179 665076 663786 676581 693991 645366 608432 800416 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.67%) |
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 38452 56464 73421 191312 266184 382436 383443 389806 389864 395662 395731 396315 398348 399295 400747 401637 402128 402135 402963 403000 406378 413109 413216 419598 420926 425299 428685 432189 434541 437676 460974 469094 469202 477876 483259 485912 487548 490679 491916 493115 495508 495582 497189 498061 502321 504335 505186 505494 505834 515392 515486 515662 518771 519937 523491 524263 524755 524902 533351 534660 535318 535672 536279 537548 537576 537717 539446 539458 539570 544339 547741 547780 559881 566063 569582 573179 590231 593149 598310 604086 604877 608432 609977 612110 625451 638550 644253 645366 649859 663786 665076 670748 676248 676388 676581 693991 702793 716568 718769 722035 726593 737397 741052 752161 756671 757562 768560 768591 774141 774728 775679 783151 784237 800416 803233 803972 804116 806508 808468 810675 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милф красивая"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"милфы красивые"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"милф красивая"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.76%) |
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.