Query Metrics
7
Database Queries
7
Different statements
140.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.80 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.06 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen skirt"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.61 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 497422 521489 533370 566035 568078 579389 564810 580256 663458 581806 597532 603092 612799 632569 614434 467604 476223 497951 620205 594231 527273 494694 544529 579592 648575 652893 653544 654449 654322 659419 571244 598545 604960 600060 604873 431986 454984 523354 523335 524628 563852 577362 580296 547658 560925 563388 547241 553272 564412 654374 657361 655609 652610 680176 624927 609892 637049 597542 600084 601917 595437 600035 614992 626448 436074 518996 521126 525965 535338 528788 512059 530637 551913 571198 621259 591235 597575 609880 522403 523995 564456 418686 522878 596839 619746 ] |
||||||||||||||||||||||||||||||
| 4 | 3.15 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 418686 431986 436074 454984 467604 476223 494694 497422 497951 512059 518996 521126 521489 522403 522878 523335 523354 523995 524628 525965 527273 528788 530637 533370 535338 544529 547241 547658 551913 553272 560925 563388 563852 564412 564456 564810 566035 568078 571198 571244 577362 579389 579592 580256 580296 581806 591235 594231 595437 596839 597532 597542 597575 598545 600035 600060 600084 601917 603092 604873 604960 609880 609892 612799 614434 614992 619746 620205 621259 624927 626448 632569 637049 648575 652610 652893 653544 654322 654374 654449 655609 657361 659419 663458 680176 ] |
||||||||||||||||||||||||||||||
| 5 | 114.02 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 418686 431986 436074 454984 467604 476223 494694 497422 497951 512059 518996 521126 521489 522403 522878 523335 523354 523995 524628 525965 527273 528788 530637 533370 535338 544529 547241 547658 551913 553272 560925 563388 563852 564412 564456 564810 566035 568078 571198 571244 577362 579389 579592 580256 580296 581806 591235 594231 595437 596839 597532 597542 597575 598545 600035 600060 600084 601917 603092 604873 604960 609880 609892 612799 614434 614992 619746 620205 621259 624927 626448 632569 637049 648575 652610 652893 653544 654322 654374 654449 655609 657361 659419 663458 680176 ] |
||||||||||||||||||||||||||||||
| 6 | 1.59 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen юбк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.38 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen юбк"
]
|
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.