SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103530 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103530 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344510,653841,973941,579106,426865,351089,2512,742907,981563,179556,683158,860573,76913,476492,197022,112991,806842,704875,613250,526707,425,548627,503427,296946,406979,411303,916084,270083,723600,110274,512940,326378,1021411,639874,971019,473604,668237,754019,625810,726269,1014350,717065,814003,663382,447013,503428,137475,425326,810760,817943,514829,979339,581566,319914,471530,1037891,182046,657517,447106,473951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]