SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004721s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391399 LIMIT 1 [ RunTime:0.000952s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391399 [ RunTime:0.006569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031745,39586,1025618,27161,871174,929576,458142,849616,72747,669448,1022445,552471,617786,652175,886624,492390,927850,87016,300877,367353,121921,468888,344975,444302,984420,196660,390289,923706,841046,843114,674989,591466,710256,126367,16269,97520,594501,425856,455689,873302,484178,999208,239004,626325,112679,998034,692167,295087,484791,12017,511709,112075,939364,757592,945388,959389,179443,420619,593043,74912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]