SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031091 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031091 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286654,1033388,167780,58760,450137,544235,887193,122325,207035,785501,405288,438680,599789,93171,242611,778249,62485,648685,930553,914513,587006,617338,87726,607399,1036269,488625,909559,1028060,584384,898397,60467,936136,190266,813646,846739,109191,39496,199291,914492,951300,34230,119051,458434,473971,271919,181000,199766,681163,35764,1044098,366840,485928,895504,1010178,269435,825578,973065,642339,270428,29494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]