Input

field	value
Query:	SELECT 'Thinkphp' AS technology_name ,domain ,global_rank ,url_matchable AS url ,created AS first_seen ,last_seen ,CASE WHEN indicator_matchable[2] = 'plain' THEN 'lower(' || indicator_matchable[3] || '.' || indicator_matchable[4] || ') contains ''' || indicator_matchable[1] || '''' ELSE indicator_matchable[3] || '.' || indicator_matchable[4] || ' is regex match of ''' || indicator_matchable[1] || '''' END AS indicator FROM indicator_detection_domain_rollup WHERE (indicator_matchable[1] = 'thinkphp' AND indicator_matchable[2] = 'plain' AND indicator_matchable[3] = 'http_request' AND indicator_matchable[4] = 'response_headers') ORDER BY global_rank ASC NULLS LAST

Query Plan

Download: csv json

Query Plan
Limit (cost=3485.21..3486.06 rows=20 width=117)
-> Result (cost=3485.21..3521.68 rows=858 width=117)
-> Sort (cost=3485.21..3487.36 rows=858 width=168)
Sort Key: global_rank
-> Bitmap Heap Scan on indicator_detection_domain_rollup (cost=61.64..3462.38 rows=858 width=168)
Recheck Cond: ((indicator_matchable[1] = 'thinkphp'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))
-> Bitmap Index Scan on indicator_detection_domain_rollup_indicator_matchable_arr_idx (cost=0.00..61.43 rows=858 width=0)
Index Cond: ((indicator_matchable[1] = 'thinkphp'::text) AND (indicator_matchable[2] = 'plain'::text) AND (indicator_matchable[3] = 'http_request'::text) AND (indicator_matchable[4] = 'response_headers'::text))

Data

Total Results: 663 Download: csv json

Technology Name	Domain	Global Rank	Url	First Seen	Last Seen	Indicator
Thinkphp	so.com	633.0	zhanzhang.so.com	2023-10-17 05:38:00.628739-07:00	2024-12-23 00:29:42.647808-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	thinkphp.cn	7056.0	www.thinkphp.cn	2024-11-27 02:59:13.789941-08:00	2024-12-13 00:35:16.815898-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	memuplay.com	13412.0	memuplay.com	2024-10-12 07:41:51.811937-07:00	2024-11-13 00:51:43.253128-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	qupu123.com	25970.0	qupu123.com	2023-10-15 04:35:18.012042-07:00	2024-12-23 00:38:16.607517-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	securityscorecard.com	34234.0	securityscorecard.com	2024-06-19 10:30:52.238058-07:00	2024-06-19 02:17:05.890903-07:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	zbloghost.cn	39431.0	zbloghost.cn	2023-10-16 01:46:37.479980-07:00	2024-10-06 01:11:02.101563-07:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	51bonjour.com	45380.0	www.51bonjour.com	2023-10-16 01:13:44.105098-07:00	2024-12-12 02:30:57.846924-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	zhizuoh5.com	53178.0	www.zhizuoh5.com	2023-10-16 02:10:05.102012-07:00	2024-12-23 00:55:47.489272-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	vatti.com.cn	60974.0	vatti.com.cn	2023-10-16 02:12:51.151783-07:00	2024-12-23 01:03:58.660434-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	car388.com	62475.0	car388.com	2023-10-16 02:10:05.102012-07:00	2024-12-23 00:57:53.814831-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	educhenggong.com	64895.0	educhenggong.com	2023-10-15 02:41:26.437800-07:00	2024-05-26 02:10:55.068467-07:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	qishunbao.com	66063.0	www.qishunbao.com	2023-10-16 02:10:05.102012-07:00	2024-12-23 01:12:05.434275-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	napai.cn	66688.0	www.napai.cn/index	2023-10-16 02:10:05.102012-07:00	2024-07-08 04:44:51.091339-07:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	zhumeiwang.com	66989.0	www.zhumeiwang.com	2023-10-16 02:15:30.711992-07:00	2024-12-23 01:20:06.156865-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	netis-systems.com	68949.0	netis-systems.com	2023-10-15 02:41:31.500275-07:00	2024-05-24 01:08:01.770654-07:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	goldmax360.com	70296.0	goldmax360.com	2023-11-14 03:07:14.402224-08:00	2024-12-13 01:33:14.890774-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	nnlgjt.com	71019.0	nnlgjt.com	2023-10-16 02:10:05.102012-07:00	2024-12-13 01:32:45.695677-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	jianfc.com	74107.0	jianfc.com	2023-10-16 02:10:05.102012-07:00	2024-09-21 00:50:20.898562-07:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	qixieke.com	75523.0	qixieke.com	2023-10-16 02:10:05.102012-07:00	2024-12-13 01:46:50.939097-08:00	lower(http_request.response_headers) contains 'thinkphp'
Thinkphp	thltd.com	76569.0	thltd.com	2023-10-16 02:15:30.711992-07:00	2024-12-13 01:58:07.918605-08:00	lower(http_request.response_headers) contains 'thinkphp'