Query Metrics
7
Database Queries
7
Different statements
165.13 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.31 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.87 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"громкий секс"
]
|
||||||||||||||||||||||||||||||
| 3 | 23.03 ms |
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 652931 636834 586431 552969 576723 625533 600046 615623 620124 597550 581117 554798 663888 652610 610419 610574 505794 580280 623235 527611 516015 554790 655609 626892 622375 598524 620559 595510 624776 511345 527451 512741 530777 583457 653541 657361 614717 618743 480808 560924 670971 605746 609892 624150 529567 538290 605545 622778 512050 572886 621265 533534 474125 545643 550329 622067 523929 538270 486665 561480 595507 536924 598505 484632 689013 613488 590408 527465 516472 545828 590796 486400 514782 613215 619407 585716 594231 617212 602658 520355 584514 493163 594958 601094 559378 558432 568045 554392 612256 499882 ] |
||||||||||||||||||||||||||||||
| 4 | 2.83 ms |
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 474125 480808 484632 486400 486665 493163 499882 511345 512050 512741 514782 516015 516472 520355 523929 527451 527465 527611 529567 530777 533534 536924 538270 538290 545643 545828 550329 552969 554392 554790 554798 558432 559378 560924 561480 568045 572886 576723 580280 581117 583457 584514 585716 586431 590408 590796 594231 594958 595507 595510 597550 598505 598524 600046 601094 602658 605545 605746 609892 610419 610574 612256 613215 613488 614717 615623 617212 618743 619407 620124 620559 621265 622067 622375 622778 623235 624150 624776 625533 626892 636834 652610 652931 653541 655609 657361 663888 670971 689013 ] |
||||||||||||||||||||||||||||||
| 5 | 131.88 ms |
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 474125 480808 484632 486400 486665 493163 499882 511345 512050 512741 514782 516015 516472 520355 523929 527451 527465 527611 529567 530777 533534 536924 538270 538290 545643 545828 550329 552969 554392 554790 554798 558432 559378 560924 561480 568045 572886 576723 580280 581117 583457 584514 585716 586431 590408 590796 594231 594958 595507 595510 597550 598505 598524 600046 601094 602658 605545 605746 609892 610419 610574 612256 613215 613488 614717 615623 617212 618743 619407 620124 620559 621265 622067 622375 622778 623235 624150 624776 625533 626892 636834 652610 652931 653541 655609 657361 663888 670971 689013 ] |
||||||||||||||||||||||||||||||
| 6 | 1.73 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"громк секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.46 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.