Query Metrics
7
Database Queries
7
Different statements
162.74 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.00 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.42 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оргазм бабы бесплатно…"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.24 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 503423 460001 461898 468033 547794 551654 396042 419111 423912 462428 481968 448369 455613 473778 434306 471355 476654 478010 478492 431221 518185 529739 483814 489318 492717 506239 527209 509813 400712 411318 449490 703950 794899 738461 427062 432383 407171 632059 469198 588532 626364 634532 601529 413649 521581 524564 577290 512938 398679 792926 21626 574700 595369 469236 392994 441527 418268 435625 437564 414932 485842 701531 808540 783319 464782 461812 481054 394620 398200 386632 604716 392981 413444 415859 418101 421310 410690 417965 446028 446330 481877 482780 495763 496809 468154 479544 598696 590788 775817 430355 434352 465237 415294 456256 430675 450255 511520 483711 486148 518458 519364 485989 489461 502868 506989 512830 499857 515031 528114 598609 482507 563630 623116 598844 418835 477641 469185 627522 712271 784744 ] |
||||||||||||||||||||||||||||||
| 4 | 3.07 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 21626 386632 392981 392994 394620 396042 398200 398679 400712 407171 410690 411318 413444 413649 414932 415294 415859 417965 418101 418268 418835 419111 421310 423912 427062 430355 430675 431221 432383 434306 434352 435625 437564 441527 446028 446330 448369 449490 450255 455613 456256 460001 461812 461898 462428 464782 465237 468033 468154 469185 469198 469236 471355 473778 476654 477641 478010 478492 479544 481054 481877 481968 482507 482780 483711 483814 485842 485989 486148 489318 489461 492717 495763 496809 499857 502868 503423 506239 506989 509813 511520 512830 512938 515031 518185 518458 519364 521581 524564 527209 528114 529739 547794 551654 563630 574700 577290 588532 590788 595369 598609 598696 598844 601529 604716 623116 626364 627522 632059 634532 701531 703950 712271 738461 775817 783319 784744 792926 794899 808540 ] |
||||||||||||||||||||||||||||||
| 5 | 133.12 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 21626 386632 392981 392994 394620 396042 398200 398679 400712 407171 410690 411318 413444 413649 414932 415294 415859 417965 418101 418268 418835 419111 421310 423912 427062 430355 430675 431221 432383 434306 434352 435625 437564 441527 446028 446330 448369 449490 450255 455613 456256 460001 461812 461898 462428 464782 465237 468033 468154 469185 469198 469236 471355 473778 476654 477641 478010 478492 479544 481054 481877 481968 482507 482780 483711 483814 485842 485989 486148 489318 489461 492717 495763 496809 499857 502868 503423 506239 506989 509813 511520 512830 512938 515031 518185 518458 519364 521581 524564 527209 528114 529739 547794 551654 563630 574700 577290 588532 590788 595369 598609 598696 598844 601529 604716 623116 626364 627522 632059 634532 701531 703950 712271 738461 775817 783319 784744 792926 794899 808540 ] |
||||||||||||||||||||||||||||||
| 6 | 1.92 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"оргазм женскийрод бесплатн"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.98 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.