SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 953401 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 953401 [ RunTime:0.002251s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042470,512995,664137,1000072,562234,753139,371114,31639,107887,256631,1022745,125817,532907,832730,440756,814210,980584,861009,209269,971076,775488,191148,914339,356799,408319,1019018,197704,654445,552100,675507,929151,466543,982700,318270,387700,268366,352885,328808,988275,122273,956811,521787,863518,321157,728414,422653,1026494,1043201,865792,430099,44565,980802,442905,531244,289845,247678,90275,808299,279110,12401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 953401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 953401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]