Query Metrics
7
Database Queries
7
Different statements
354.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.98 ms (58.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme public money"
]
|
||||||||||||||||||||||||||||||
|
122.52 ms (34.59%) |
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 123029 404608 446755 451565 455514 459069 461495 462585 462701 464172 465964 469121 469629 470347 471177 480869 484458 484506 484546 487209 489385 489390 490217 492396 495144 496295 497974 499427 500932 504630 506559 507701 512066 512830 515333 516704 516812 519894 521898 524457 525570 527206 527822 528133 528139 532253 541542 541567 546830 550094 551909 551935 552403 552846 555076 557089 562037 567591 567960 568790 571151 571639 571689 573103 574451 590762 590900 600669 619406 620234 620259 621438 621999 623842 625711 626292 626293 627877 629886 632563 637437 641418 642662 643028 644951 656936 660029 664451 680944 683567 684949 688220 699621 703494 714140 714577 721798 722541 731063 737452 740538 758691 765055 774241 781397 783162 784419 797032 798344 800492 801348 804309 805940 806294 810689 811106 812979 814041 814918 815029 ] |
||||||||||||||||||||||||||||||
|
18.02 ms (5.09%) |
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 573103 552403 555076 574451 621999 590762 812979 627877 446755 462585 469121 528133 484458 404608 656936 123029 490217 499427 492396 515333 731063 699621 451565 527206 632563 462701 571151 623842 814041 814918 644951 550094 567591 660029 683567 688220 714140 684949 714577 567960 571639 600669 620259 626293 637437 590900 798344 783162 800492 737452 804309 758691 765055 774241 620234 626292 721798 781397 784419 480869 470347 506559 797032 484546 496295 500932 521898 524457 568790 703494 621438 459069 469629 489390 487209 806294 562037 497974 507701 516812 516704 551935 571689 625711 805940 461495 528139 471177 551909 525570 642662 664451 811106 504630 512066 519894 680944 512830 740538 815029 465964 484506 532253 527822 489385 541542 546830 557089 722541 619406 629886 801348 810689 464172 495144 541567 552846 643028 455514 641418 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (0.71%) |
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 123029 404608 446755 451565 455514 459069 461495 462585 462701 464172 465964 469121 469629 470347 471177 480869 484458 484506 484546 487209 489385 489390 490217 492396 495144 496295 497974 499427 500932 504630 506559 507701 512066 512830 515333 516704 516812 519894 521898 524457 525570 527206 527822 528133 528139 532253 541542 541567 546830 550094 551909 551935 552403 552846 555076 557089 562037 567591 567960 568790 571151 571639 571689 573103 574451 590762 590900 600669 619406 620234 620259 621438 621999 623842 625711 626292 626293 627877 629886 632563 637437 641418 642662 643028 644951 656936 660029 664451 680944 683567 684949 688220 699621 703494 714140 714577 721798 722541 731063 737452 740538 758691 765055 774241 781397 783162 784419 797032 798344 800492 801348 804309 805940 806294 810689 811106 812979 814041 814918 815029 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор на money улиц"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор на money улиц"
]
|
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.