NSIS (Nucleic acid & Strain Inventory System)

#	코드 ▼	명칭	유전자이름(GOI)	유전자공여생물체	발현형태	내성항생제	등록일	재고 Tube / Vol.	1년 사용량 Tube / Vol.
	RE-R00383	pET21a DpnI-His R.clone	DpnI	S. pneumoniae	C-His	Amp	26-05-07	0/0 μl	0/0 μl
	RE-R00382	pET21a His DpnI R.clone	DpnI R	S. pneumoniae	His	Amp	26-05-07	0/0 μl	0/0 μl
	RE-R00381	pET-His PstI D91A MR.clone	PstI MR	P. stuartii	His	Amp	26-05-07	0/0 μl	0/0 μl
	RE-R00380	pET-His HindIII Q148I MR.clone	HindIII MR	H. influenzae	His	Amp	26-05-07	0/0 μl	0/0 μl
	RE-R00379	StuI MR.clone2	StuI MR	-	Native	Amp Cam	26-01-14	0/0 μl	0/0 μl
	RE-R00378	StuI MR.clone	StuI MR	-	His-Smt3	Amp Cam	26-01-14	0/0 μl	0/0 μl
	RE-R00377	SpeI MR.clone2	SpeI MR	-	His	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00376	pET21b SpeI MR.clone	SpeI MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00375	SnaBI MR.clone	SnaBI MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00374	SmaI MR.clone	SmaI MR	-	His	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00373	SgrAI MR.clone2	SgrAI MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00372	SgrAI MR.clone	SgrAI MR	-	His-Smt3	-	25-12-26	0/0 μl	0/0 μl
	RE-R00371	pET-His SfiI MR.clone2	SfiI MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00370	SfiI MR.clone	SfiI MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00369	SdaI MR.clone	SdaI MR	-	His-Smt3	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00368	pET21a ScaI MR.clone	ScaI MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00367	pET-His Sau3AI MR.clone	Sau3AI MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00366	pET-His SacI MR.clone	SacI MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00365	PvuII MR.clone	PvuII MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00364	PvuI MR.clone	PvuI MR	-	His-Smt3	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00363	pET-His PspGI MR.clone2	PspGI MR	-	Native	Amp	25-12-26	0/0 μl	0/0 μl
	RE-R00362	PspGI MR.clone	PspGI MR	-	His-Smt3	-	25-12-26	0/0 μl	0/0 μl
	RE-R00361	pET-His-Smt3 PstI MR.clone3	PstI MR	-	His-Smt3	Amp	25-12-26	0/0 μl	0/0 μl
	RE-R00360	pET21a PstI MR.clone2	PstI MR	-	Native	Amp Cam	25-12-26	0/0 μl	0/0 μl
	RE-R00359	PstI MR.clone	PstI MR	-	His	Amp Cam	25-12-26	0/0 μl	0/0 μl
1(current) 2 3 4 5 6 7 8 9 10 11 Next Last

s_list SQL Debug - 162 queries / 0.11038 sec

#1 / 0.00048 sec

SELECT *
FROM `T_USER_PIN_CELL`
WHERE `member_id` = 0

#2 / 0.00042 sec

SELECT *
FROM `T_CODE`
WHERE `code_type` = 'host_cell'
AND `is_active` = 1
ORDER BY `sort_order` ASC

#3 / 0.00027 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'host_cell'
AND `code_value` = '1'

#4 / 0.00027 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#5 / 0.00026 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#6 / 0.00806 sec

SELECT COUNT(*) AS cnt FROM T_SAMPLE   WHERE stype = 'na' AND use_type = 'research' AND s_state = 'confirm'

#7 / 0.00735 sec

SELECT * FROM T_SAMPLE  WHERE stype = 'na' AND use_type = 'research' AND s_state = 'confirm'  ORDER BY CONCAT(cate_code, LPAD(s_code, 5, '0')) DESC  LIMIT 0, 25

#8 / 0.00025 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#9 / 0.00015 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#10 / 0.00302 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 2069

#11 / 0.00019 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#12 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#13 / 0.00298 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 2068

#14 / 0.00018 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#15 / 0.00013 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#16 / 0.00303 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 2067

#17 / 0.00018 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#18 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#19 / 0.00297 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 2066

#20 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#21 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#22 / 0.00298 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 754

#23 / 0.00018 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#24 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#25 / 0.00304 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 751

#26 / 0.00019 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#27 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#28 / 0.00300 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 695

#29 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#30 / 0.00013 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#31 / 0.00301 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 694

#32 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#33 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#34 / 0.00295 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 692

#35 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#36 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#37 / 0.00295 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 690

#38 / 0.00022 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#39 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#40 / 0.00289 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 688

#41 / 0.00016 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#42 / 0.00013 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#43 / 0.00299 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 687

#44 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#45 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#46 / 0.00301 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 685

#47 / 0.00018 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#48 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#49 / 0.00300 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 684

#50 / 0.00018 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#51 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#52 / 0.00301 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 682

#53 / 0.00018 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#54 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#55 / 0.00298 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 680

#56 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#57 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#58 / 0.00298 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 679

#59 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#60 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#61 / 0.00294 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 677

#62 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#63 / 0.00013 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#64 / 0.00288 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 675

#65 / 0.00018 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#66 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#67 / 0.00296 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 673

#68 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#69 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#70 / 0.00301 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 671

#71 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#72 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#73 / 0.00296 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 670

#74 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#75 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#76 / 0.00297 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 669

#77 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#78 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#79 / 0.00297 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 668

#80 / 0.00017 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#81 / 0.00014 sec

SELECT `code_label2`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#82 / 0.00296 sec

SELECT *
FROM `T_GOI`
WHERE `s_pno` = 666

#83 / 0.00065 sec

SELECT t1.sample_id, SUM(CASE WHEN t1.tube_id <> 0 AND t1.inout_state_id = 1 THEN t1.tube_ml ELSE 0 END) AS total_ml, 
                    SUM(CASE WHEN t1.tube_id <> 0 AND t1.inout_state_id = 1 THEN 1 ELSE 0 END) AS total_cnt,
                    SUM(CASE WHEN t1.tube_id <> 0 AND t1.inout_state_id = 1 AND t1.tube_ml - COALESCE((SELECT SUM(t2.tube_ml) FROM T_INOUT_TUBE t2 WHERE t2.pid = t1.id), 0) = 0 THEN 1 ELSE 0 END) AS zero_cnt,
                    SUM(CASE WHEN t1.inout_state_id <> 1 THEN t1.tube_ml ELSE 0 END) AS use_ml
                    FROM T_INOUT_TUBE t1 WHERE t1.sample_id IN (2069,2068,2067,2066,754,751,695,694,692,690,688,687,685,684,682,680,679,677,675,673,671,670,669,668,666) AND t1.tube_id <> 0  GROUP BY t1.sample_id

#84 / 0.00051 sec

SELECT t1.sample_id, SUM(CASE WHEN t1.tube_id <> 0 AND t1.inout_state_id = 1 THEN t1.tube_ml ELSE 0 END) AS total_ml, 
                    SUM(CASE WHEN t1.tube_id <> 0 AND t1.inout_state_id = 1 THEN 1 ELSE 0 END) AS total_cnt,
                    SUM(CASE WHEN t1.tube_id <> 0 AND t1.inout_state_id = 1 AND t1.tube_ml - COALESCE((SELECT SUM(t2.tube_ml) FROM T_INOUT_TUBE t2 WHERE t2.pid = t1.id), 0) = 0 THEN 1 ELSE 0 END) AS zero_cnt,
                    SUM(CASE WHEN t1.inout_state_id <> 1 THEN t1.tube_ml ELSE 0 END) AS use_ml
                    FROM T_INOUT_TUBE t1 WHERE t1.sample_id IN (2069,2068,2067,2066,754,751,695,694,692,690,688,687,685,684,682,680,679,677,675,673,671,670,669,668,666) AND t1.tube_id <> 0  AND t1.confirm_date >= DATE_SUB(CURDATE(), INTERVAL 12 MONTH) GROUP BY t1.sample_id

#85 / 0.00084 sec

SELECT COUNT(*) AS cnt FROM T_ELEC

#86 / 0.00026 sec

SELECT *
FROM `T_CODE`
WHERE `code_type` = 'category_code'
AND `is_active` = 1
ORDER BY `sort_order` ASC

#87 / 0.00016 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#88 / 0.00013 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#89 / 0.00013 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#90 / 0.00012 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#91 / 0.00012 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#92 / 0.00012 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#93 / 0.00012 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#94 / 0.00013 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#95 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#96 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#97 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#98 / 0.00012 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#99 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#100 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#101 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#102 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#103 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#104 / 0.00012 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#105 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#106 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#107 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#108 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#109 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#110 / 0.00012 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#111 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#112 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#113 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#114 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#115 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#116 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#117 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#118 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#119 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#120 / 0.00013 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#121 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#122 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#123 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#124 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#125 / 0.00013 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#126 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#127 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#128 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#129 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#130 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#131 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#132 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#133 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#134 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#135 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#136 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#137 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#138 / 0.00012 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#139 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#140 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#141 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#142 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#143 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#144 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#145 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#146 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#147 / 0.00012 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#148 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#149 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#150 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#151 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#152 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#153 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#154 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#155 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#156 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#157 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#158 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#159 / 0.00011 sec

SELECT `code_label`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#160 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#161 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1

#162 / 0.00011 sec

SELECT `code_label3`
FROM `T_CODE`
WHERE `code_type` = 'max_ml'
AND `code_value` = 'na_r'
AND `is_active` = 1