SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540693 LIMIT 1 [ RunTime:0.001369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540693 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422130,805023,548131,752226,754723,960660,789042,252481,127930,913610,692495,945602,764992,685320,1024874,424978,435849,49343,179724,959360,31269,318877,502493,920599,295356,558014,556939,425315,493902,833544,390791,305593,203174,65294,960705,140864,1045516,427382,12333,398186,783225,385553,105567,349345,178318,893024,459518,459002,424914,532114,447723,675707,279517,600554,670612,22371,926673,428007,686420,269203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]