Query Metrics
7
Database Queries
7
Different statements
349.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.89 ms (59.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поз milf 69 секс"
]
|
||||||||||||||||||||||||||||||
|
116.59 ms (33.39%) |
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 16679 80629 152276 191412 220788 382061 382939 384364 384904 385231 386230 386954 387447 388693 390366 390790 394451 395797 407182 417452 420127 435374 440852 470402 471559 476377 481967 508888 513836 549329 571130 581363 584423 595716 595739 609370 619682 622246 622311 626520 636050 655539 662777 663445 666415 673170 673506 675190 676405 679405 689768 690165 693149 694130 694661 716526 716634 718393 718880 719130 723965 724430 727407 728154 728887 728902 728908 729284 730806 733143 737458 738335 740978 741807 741818 741828 744692 747564 748073 749171 752278 754679 754935 756347 757311 761426 763527 763946 765545 766803 766873 766886 769556 779642 781610 782885 783315 783557 784084 789093 791173 791681 792582 795599 798321 800015 800023 800041 800063 800141 800188 804406 804813 809105 809359 812290 812558 814996 825453 826785 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (4.08%) |
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 757311 800063 800023 390790 581363 728887 769556 800188 584423 694130 784084 754935 636050 756347 626520 571130 800041 716634 792582 663445 800015 727407 761426 814996 394451 662777 622246 741828 386954 718393 766873 744692 690165 728154 741807 719130 476377 809105 826785 716526 673170 798321 747564 754679 795599 384904 80629 679405 595739 737458 417452 730806 673506 728908 693149 619682 812558 766803 749171 471559 395797 435374 791173 595716 781610 748073 740978 513836 675190 729284 385231 220788 676405 387447 689768 791681 752278 766886 763946 382939 741818 804813 390366 804406 655539 723965 470402 718880 782885 789093 800141 16679 407182 779642 783557 388693 386230 508888 724430 738335 420127 728902 733143 765545 763527 783315 609370 382061 152276 191412 549329 440852 384364 481967 694661 622311 812290 809359 825453 666415 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поз milf 69 секс"
]
|
||||||||||||||||||||||||||||||
|
2.80 ms (0.80%) |
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 16679 80629 152276 191412 220788 382061 382939 384364 384904 385231 386230 386954 387447 388693 390366 390790 394451 395797 407182 417452 420127 435374 440852 470402 471559 476377 481967 508888 513836 549329 571130 581363 584423 595716 595739 609370 619682 622246 622311 626520 636050 655539 662777 663445 666415 673170 673506 675190 676405 679405 689768 690165 693149 694130 694661 716526 716634 718393 718880 719130 723965 724430 727407 728154 728887 728902 728908 729284 730806 733143 737458 738335 740978 741807 741818 741828 744692 747564 748073 749171 752278 754679 754935 756347 757311 761426 763527 763946 765545 766803 766873 766886 769556 779642 781610 782885 783315 783557 784084 789093 791173 791681 792582 795599 798321 800015 800023 800041 800063 800141 800188 804406 804813 809105 809359 812290 812558 814996 825453 826785 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"69 milf fuck"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.46%) |
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.