SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488590 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488590 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359586,601940,1007890,111800,391440,625100,229683,614106,597306,457093,481293,668069,516331,1043441,654283,242314,433312,1022041,171769,556084,256709,918996,1010954,26253,615217,366563,382317,184255,801272,507263,182941,622851,1035161,702647,32383,462992,860147,949776,353010,693887,623363,996471,353952,1030539,618424,1031752,941882,257632,625426,576524,269381,706320,42722,559678,773606,346704,905252,129587,314465,804031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]