SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294980 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294980 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254713,28071,768507,449400,1037678,151908,283618,490398,242380,662986,376746,970434,780962,531878,783059,787893,200769,762371,357233,810481,57339,809756,822673,272149,500467,793437,788198,422049,1014038,985311,161069,145473,312353,1004697,155919,1027422,138292,614925,302929,580279,315137,531711,562938,747403,455553,877709,981567,860969,530259,217537,838563,211011,723117,886371,624027,496271,608244,349598,145505,717553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]