Query Metrics
7
Database Queries
7
Different statements
264.02 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.76 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.25 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"два в киске"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.63 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 456585 485970 494290 491385 507352 623644 515571 584537 556050 359918 381812 420252 449322 466646 447705 404927 388903 452444 511228 526121 462236 435064 476529 430956 511577 492610 511294 395513 398756 411954 429873 409783 457267 607924 404240 466231 571979 380962 382636 509199 810867 382697 388754 338025 403268 147400 233147 546966 605655 608775 581626 516171 445971 400834 405699 419459 441495 478111 526122 531326 521030 488750 555014 543623 551099 551810 582605 741046 442647 36832 385436 401184 429375 439365 444449 485944 521595 124494 167756 382078 359441 96239 47689 123147 389553 399727 400944 408709 424985 425354 426721 482450 450243 487307 517081 469600 602337 188129 332249 382365 391204 391904 398908 453855 466299 466712 479727 29403 381846 474056 476681 388066 514458 524430 507415 444022 418534 445945 548666 420216 ] |
||||||||||||||||||||||||||||||
| 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 29403 36832 47689 96239 123147 124494 147400 167756 188129 233147 332249 338025 359441 359918 380962 381812 381846 382078 382365 382636 382697 385436 388066 388754 388903 389553 391204 391904 395513 398756 398908 399727 400834 400944 401184 403268 404240 404927 405699 408709 409783 411954 418534 419459 420216 420252 424985 425354 426721 429375 429873 430956 435064 439365 441495 442647 444022 444449 445945 445971 447705 449322 450243 452444 453855 456585 457267 462236 466231 466299 466646 466712 469600 474056 476529 476681 478111 479727 482450 485944 485970 487307 488750 491385 492610 494290 507352 507415 509199 511228 511294 511577 514458 515571 516171 517081 521030 521595 524430 526121 526122 531326 543623 546966 548666 551099 551810 555014 556050 571979 581626 582605 584537 602337 605655 607924 608775 623644 741046 810867 ] |
||||||||||||||||||||||||||||||
| 5 | 236.18 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 29403 36832 47689 96239 123147 124494 147400 167756 188129 233147 332249 338025 359441 359918 380962 381812 381846 382078 382365 382636 382697 385436 388066 388754 388903 389553 391204 391904 395513 398756 398908 399727 400834 400944 401184 403268 404240 404927 405699 408709 409783 411954 418534 419459 420216 420252 424985 425354 426721 429375 429873 430956 435064 439365 441495 442647 444022 444449 445945 445971 447705 449322 450243 452444 453855 456585 457267 462236 466231 466299 466646 466712 469600 474056 476529 476681 478111 479727 482450 485944 485970 487307 488750 491385 492610 494290 507352 507415 509199 511228 511294 511577 514458 515571 516171 517081 521030 521595 524430 526121 526122 531326 543623 546966 548666 551099 551810 555014 556050 571979 581626 582605 584537 602337 605655 607924 608775 623644 741046 810867 ] |
||||||||||||||||||||||||||||||
| 6 | 2.14 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"два в вагин"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.89 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.