SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015370 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015370 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973604,718122,986170,336718,794434,327024,594669,572728,612829,419269,40912,327323,139156,240072,526590,318282,634174,951104,580679,762549,1023127,35653,144969,698739,396141,695417,589786,330793,102493,855204,95041,994866,367061,40337,317589,157554,9184,406202,282530,643155,613290,202742,133921,694646,567671,764848,45750,458854,156693,688351,946489,179443,361859,575895,319076,436984,473417,213030,833952,394537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]