Query Metrics
7
Database Queries
7
Different statements
175.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.76 ms (83.27%) |
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 446476 448024 452547 454113 454535 456341 457171 457893 457915 459148 459163 461898 464042 465501 468545 468750 469597 471721 471864 473154 474031 474691 477197 479971 480474 485616 488510 492308 492470 494335 495737 496361 496686 500100 507360 510683 512513 514598 515268 515699 516696 517308 523374 537971 538077 544507 548537 548572 548581 549697 551894 551984 552584 553223 555591 556393 556872 557915 559293 560065 560940 564366 565327 565473 569214 569261 569740 569761 569769 571221 576214 577581 579406 581969 584291 587951 588037 588226 590622 590843 593514 593664 597892 598069 599302 602849 605601 607742 623713 626482 635968 643046 659398 663374 663482 664307 667552 674130 675541 683955 691990 696973 709688 716577 727594 727747 728370 731869 733906 742151 752523 760004 761566 775802 788821 793901 800535 811944 819530 821854 ] |
||||||||||||||||||||||||||||||
|
18.90 ms (10.80%) |
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 819530 821854 454113 454535 456341 457171 459148 468750 473154 477197 480474 448024 452547 465501 471721 471864 474691 479971 485616 488510 492308 492470 446476 457893 457915 459163 464042 468545 474031 515699 516696 496361 514598 517308 523374 537971 500100 512513 494335 495737 496686 507360 510683 515268 538077 461898 469597 548581 549697 551984 556393 565327 569261 544507 548572 552584 564366 569761 548537 551894 557915 559293 569214 571221 577581 581969 584291 659398 691990 663374 663482 664307 667552 674130 696973 709688 716577 675541 683955 553223 555591 556872 560065 560940 565473 569740 569769 576214 579406 593514 598069 605601 626482 590622 593664 602849 607742 623713 635968 588226 590843 643046 587951 588037 597892 599302 775802 793901 800535 727594 727747 733906 752523 760004 761566 788821 811944 731869 742151 728370 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.92%) |
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 446476 448024 452547 454113 454535 456341 457171 457893 457915 459148 459163 461898 464042 465501 468545 468750 469597 471721 471864 473154 474031 474691 477197 479971 480474 485616 488510 492308 492470 494335 495737 496361 496686 500100 507360 510683 512513 514598 515268 515699 516696 517308 523374 537971 538077 544507 548537 548572 548581 549697 551894 551984 552584 553223 555591 556393 556872 557915 559293 560065 560940 564366 565327 565473 569214 569261 569740 569761 569769 571221 576214 577581 579406 581969 584291 587951 588037 588226 590622 590843 593514 593664 597892 598069 599302 602849 605601 607742 623713 626482 635968 643046 659398 663374 663482 664307 667552 674130 675541 683955 691990 696973 709688 716577 727594 727747 728370 731869 733906 742151 752523 760004 761566 775802 788821 793901 800535 811944 819530 821854 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man toys"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин toys"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин toys"
]
|
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.