Query Metrics
7
Database Queries
7
Different statements
122.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.87 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.10 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"little teen webcam"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.41 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 756387 779659 778930 746458 773402 779695 433751 510012 646076 783076 747425 711000 469224 531369 655225 810807 745584 154573 656944 656556 780630 783087 768018 738835 723003 657565 648671 619612 441770 825442 761995 752615 449531 435830 686749 594236 634100 605669 737140 435816 438730 463324 430103 502230 787510 740900 787515 740407 486084 443572 474583 457869 464874 465293 485031 487172 539293 655275 592364 753960 615281 527914 475405 508938 523541 544206 576959 567503 602199 616472 607377 571235 616315 610552 620783 414137 420517 539280 499734 416512 456523 561980 622666 ] |
||||||||||||||||||||||||||||||
| 4 | 3.17 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 154573 414137 416512 420517 430103 433751 435816 435830 438730 441770 443572 449531 456523 457869 463324 464874 465293 469224 474583 475405 485031 486084 487172 499734 502230 508938 510012 523541 527914 531369 539280 539293 544206 561980 567503 571235 576959 592364 594236 602199 605669 607377 610552 615281 616315 616472 619612 620783 622666 634100 646076 648671 655225 655275 656556 656944 657565 686749 711000 723003 737140 738835 740407 740900 745584 746458 747425 752615 753960 756387 761995 768018 773402 778930 779659 779695 780630 783076 783087 787510 787515 810807 825442 ] |
||||||||||||||||||||||||||||||
| 5 | 100.55 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 154573 414137 416512 420517 430103 433751 435816 435830 438730 441770 443572 449531 456523 457869 463324 464874 465293 469224 474583 475405 485031 486084 487172 499734 502230 508938 510012 523541 527914 531369 539280 539293 544206 561980 567503 571235 576959 592364 594236 602199 605669 607377 610552 615281 616315 616472 619612 620783 622666 634100 646076 648671 655225 655275 656556 656944 657565 686749 711000 723003 737140 738835 740407 740900 745584 746458 747425 752615 753960 756387 761995 768018 773402 778930 779659 779695 780630 783076 783087 787510 787515 810807 825442 ] |
||||||||||||||||||||||||||||||
| 6 | 1.78 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"little teen вебкамер"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.52 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"little 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.