Clear Legal

Clear LegalClear Legal Process Service provides civil process to Harris, Liberty, Chambers, Montgomery, Brazoria, Waller, Fort Bend, and Galveston counties with state and nation wide service available. We deliver citations, subpoena, temporary restraining orders (TRO), temporary protective orders (TPO), and writs. We also create subpoenas and notary service. Contact Us Today!

Here to serve you

nf2If you would like to learn more about us and our services, please call our office, fax; or e-mail us. Our regular business hours are 8:00 AM to 5:00 PM, Monday through Friday.

The choice is clear

For people you can depend on, knowledge you can trust, and quality service; Clear Legal Process Services is The Clear Choice for YOUR Legal Solution

Here to serve you

If you would like to learn more about us and our services, please call our office, fax; or e-mail us. Our regular business hours are 8:00 AM to 5:00 PM, Monday through Friday.

Profile Information

Application 0.000 seconds (+0.000); 0.30 MB (+0.30) - afterLoad
Application 0.037 seconds (+0.037); 1.06 MB (+0.76) - afterInitialise
Application 0.056 seconds (+0.019); 2.36 MB (+1.30) - afterRoute
Application 0.096 seconds (+0.040); 3.04 MB (+0.67) - afterDispatch
Application 0.130 seconds (+0.033); 3.29 MB (+0.25) - afterRender

Memory Usage

3.31 MB (3,465,584 Bytes)

35 Queries Logged

  1. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = 'sjh61v1n7ucpou66jre1sb9hf4'
  2. DELETE
      FROM `jos_session`
      WHERE `time` < 1685673141
  3. SELECT `session_id`
      FROM `jos_session`
      WHERE `session_id` = 'sjh61v1n7ucpou66jre1sb9hf4'
      LIMIT 0, 1
  4. INSERT INTO `jos_session` (`session_id`, `client_id`, `time`)
      VALUES ('sjh61v1n7ucpou66jre1sb9hf4', 0, 1685674041)
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  6. SELECT id, rules
      FROM `jos_viewlevels`
  7. SELECT folder AS type, element AS name, params
      FROM jos_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  9. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
      FROM jos_menu AS m
      LEFT JOIN jos_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      AND m.access IN (1,1)
      ORDER BY m.lft
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=19
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  12. SELECT alias, catid
      FROM jos_content
      WHERE id = 19
  13. SELECT *
      FROM jos_languages
      WHERE published=1
      ORDER BY lang_id ASC
  14. SELECT id, home, template, params
      FROM jos_template_styles
      WHERE client_id = 0
  15. SELECT a.rules
      FROM jos_assets AS a
      WHERE a.id = 1
  16. SELECT b.rules
      FROM jos_assets AS a
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  17. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM jos_content AS a
      LEFT JOIN jos_categories AS c
      on c.id = a.catid
      LEFT JOIN jos_users AS u
      on u.id = a.created_by
      LEFT JOIN jos_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 19
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-02 02:47:21')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-02 02:47:21')
      AND (a.state = 1 OR a.state =2)
  18. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=2
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  19. SELECT b.rules
      FROM jos_assets AS a
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content.article.19'
      ORDER BY b.lft
  20. SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      WHERE a.catid = 2
      AND a.state = 1
      AND a.access = 1
      AND (a.state = 1 OR a.state = -1)
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-06-02 02:47:21')
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-06-02 02:47:21')
      ORDER BY a.ordering
  21. UPDATE jos_content
      SET hits = hits + 1
      WHERE id = 19
  22. SELECT id, title, module, position, content, showtitle, params, mm.menuid
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-02 02:47:21')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-02 02:47:21')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 135 OR mm.menuid <= 0)
      ORDER BY position, ordering
  23. SELECT params
      FROM jos_menu
      WHERE id = 1
      AND params !=""
  24. SELECT params
      FROM jos_menu
      WHERE id = 1
      AND params !=""
  25. SELECT params
      FROM jos_menu
      WHERE id = 1
      AND params !=""
  26. SELECT params
      FROM jos_menu
      WHERE id = 1
      AND params !=""
  27. SELECT params
      FROM jos_menu
      WHERE id = 1
      AND params !=""
  28. SELECT params
      FROM jos_menu
      WHERE id = 1
      AND params !=""
  29. SELECT params
      FROM jos_menu
      WHERE id = 1
      AND params !=""
  30. SELECT params
      FROM jos_menu
      WHERE id = 1
      AND params !=""
  31. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_contact'
  32. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,cc.title as cattitle
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-02 02:47:21' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-02 02:47:21' )
      AND a.id IN (19)
      AND a.access <= 1
      AND cc.access <= 1
      AND cc.published = 1
      ORDER BY ordering
      LIMIT 0,1
  33. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,cc.title as cattitle
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-02 02:47:21' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-02 02:47:21' )
      AND a.id IN (18)
      AND a.access <= 1
      AND cc.access <= 1
      AND cc.published = 1
      ORDER BY ordering
      LIMIT 0,1
  34. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_contact'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_contact' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=3
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  35. UPDATE `jos_session`
      SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685674041;s:18:\"session.timer.last\";i:1685674041;s:17:\"session.timer.now\";i:1685674041;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1685674041
      WHERE `session_id` = 'sjh61v1n7ucpou66jre1sb9hf4'

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 8 × SELECT params FROM jos_menu
  2. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions
  3. 3 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  4. 2 × SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  5. 2 × SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,cc.title as cattitle FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid
  6. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  7. 1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
  8. 1 × SELECT a.rules FROM jos_assets AS a
  9. 1 × SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid
  10. 1 × SELECT * FROM jos_languages
  11. 1 × SELECT id, rules FROM `jos_viewlevels
  12. 1 × SELECT `session_id` FROM `jos_session`
  13. 1 × SELECT folder AS type, element AS name, params FROM jos_extensions
  14. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
  15. 1 × SELECT `data` FROM `jos_session`
  16. 1 × SELECT alias, catid FROM jos_content
  17. 1 × SELECT id, home, template, params FROM jos_template_styles
OTHER Tables:
  1. 1 × UPDATE `jos_session` SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685674041;s:18:\"session.timer.last\";i:1685674041;s:17:\"session.timer.now\";i:1685674041;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1685674041
  2. 1 × UPDATE jos_content SET hits = hits + 1
  3. 1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('sjh61v1n7ucpou66jre1sb9hf4', 0, 1685674041
  4. 1 × DELETE FROM `jos_session`