SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 940101 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 940101 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404942,793386,822289,800685,14502,72151,129434,415250,668083,873109,101043,703233,323646,233010,973173,293471,461328,209722,956107,802424,633137,640959,25137,203729,999237,894594,10501,790849,468804,126470,92754,492066,608388,369240,494740,408861,162457,645579,779118,326428,266654,117901,890649,973299,108939,202786,639945,189083,690029,100086,909252,417990,896581,574090,138364,268022,572405,408976,302656,479116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 940101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 940101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]