SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413657 LIMIT 1 [ RunTime:0.001118s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413657 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119076,274399,245592,489106,617108,451698,524200,1025509,728236,957388,858229,93024,337907,120101,809204,78507,132076,464318,821098,318148,723079,581075,205132,961531,264524,447515,288821,618919,617478,885388,194605,225704,523958,588036,572963,711147,540790,366623,274684,458508,504116,718828,83787,99959,126169,463301,426560,427212,5954,693598,504605,645419,701479,768281,463081,710016,166543,448250,245509,814353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413657 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413657 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]