Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "stepmommy amateurs"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'stepmommy amateurs' LIMIT 1;

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  718386
  817559
  778020
  540104
  718053
  727559
  563092
  827630
  816697
  724649
  794638
  782600
  539632
  787859
  799979
  823992
  760168
  579839
  824530
  730641
  823955
  793913
  826703
  716010
  739682
  792607
  612977
  623147
  543962
  713853
  773908
  729049
  557049
  709450
  555031
  786542
  780327
  779768
  779534
  544028
  707483
  557829
  599641
  621485
  761118
  761817
  761840
  796203
  462455
  509594
  615919
  614494
  613286
  191715
  741699
  492462
  609759
  810291
  609723
  584630
  476678
  514904
  684660
  628633
  432886
  637402
  613319
  563006
  484728
  620001
  623378
  550350
  520803
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (718386, 817559, 778020, 540104, 718053, 727559, 563092, 827630, 816697, 724649, 794638, 782600, 539632, 787859, 799979, 823992, 760168, 579839, 824530, 730641, 823955, 793913, 826703, 716010, 739682, 792607, 612977, 623147, 543962, 713853, 773908, 729049, 557049, 709450, 555031, 786542, 780327, 779768, 779534, 544028, 707483, 557829, 599641, 621485, 761118, 761817, 761840, 796203, 462455, 509594, 615919, 614494, 613286, 191715, 741699, 492462, 609759, 810291, 609723, 584630, 476678, 514904, 684660, 628633, 432886, 637402, 613319, 563006, 484728, 620001, 623378, 550350, 520803);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  191715
  432886
  462455
  476678
  484728
  492462
  509594
  514904
  520803
  539632
  540104
  543962
  544028
  550350
  555031
  557049
  557829
  563006
  563092
  579839
  584630
  599641
  609723
  609759
  612977
  613286
  613319
  614494
  615919
  620001
  621485
  623147
  623378
  628633
  637402
  684660
  707483
  709450
  713853
  716010
  718053
  718386
  724649
  727559
  729049
  730641
  739682
  741699
  760168
  761118
  761817
  761840
  773908
  778020
  779534
  779768
  780327
  782600
  786542
  787859
  792607
  793913
  794638
  796203
  799979
  810291
  816697
  817559
  823955
  823992
  824530
  826703
  827630
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (191715, 432886, 462455, 476678, 484728, 492462, 509594, 514904, 520803, 539632, 540104, 543962, 544028, 550350, 555031, 557049, 557829, 563006, 563092, 579839, 584630, 599641, 609723, 609759, 612977, 613286, 613319, 614494, 615919, 620001, 621485, 623147, 623378, 628633, 637402, 684660, 707483, 709450, 713853, 716010, 718053, 718386, 724649, 727559, 729049, 730641, 739682, 741699, 760168, 761118, 761817, 761840, 773908, 778020, 779534, 779768, 780327, 782600, 786542, 787859, 792607, 793913, 794638, 796203, 799979, 810291, 816697, 817559, 823955, 823992, 824530, 826703, 827630);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  191715
  432886
  462455
  476678
  484728
  492462
  509594
  514904
  520803
  539632
  540104
  543962
  544028
  550350
  555031
  557049
  557829
  563006
  563092
  579839
  584630
  599641
  609723
  609759
  612977
  613286
  613319
  614494
  615919
  620001
  621485
  623147
  623378
  628633
  637402
  684660
  707483
  709450
  713853
  716010
  718053
  718386
  724649
  727559
  729049
  730641
  739682
  741699
  760168
  761118
  761817
  761840
  773908
  778020
  779534
  779768
  780327
  782600
  786542
  787859
  792607
  793913
  794638
  796203
  799979
  810291
  816697
  817559
  823955
  823992
  824530
  826703
  827630
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (191715, 432886, 462455, 476678, 484728, 492462, 509594, 514904, 520803, 539632, 540104, 543962, 544028, 550350, 555031, 557049, 557829, 563006, 563092, 579839, 584630, 599641, 609723, 609759, 612977, 613286, 613319, 614494, 615919, 620001, 621485, 623147, 623378, 628633, 637402, 684660, 707483, 709450, 713853, 716010, 718053, 718386, 724649, 727559, 729049, 730641, 739682, 741699, 760168, 761118, 761817, 761840, 773908, 778020, 779534, 779768, 780327, 782600, 786542, 787859, 792607, 793913, 794638, 796203, 799979, 810291, 816697, 817559, 823955, 823992, 824530, 826703, 827630);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "stepmommy любительск"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'stepmommy любительск';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "stepmommy любительск"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'stepmommy любительск';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "stepmommy amateurs"
  "stepmommy amateurs"
  "stepmommy amateurs"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('stepmommy amateurs') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('stepmommy amateurs')
              AND `query` <> 'stepmommy amateurs'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;