SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030701 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030701 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011187,314549,621219,614020,493489,322737,182994,788706,882821,653471,847716,74593,771686,355296,939021,1026038,666160,873015,734148,521427,826137,991333,21594,383054,418257,809992,434472,1027022,305113,620,470358,5468,991627,503638,293721,696873,194752,592554,981050,930460,152326,72041,42236,10250,918515,837269,215430,688483,581600,762933,830111,59051,765865,272013,865472,920308,687269,165080,926347,484107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]