SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598840 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598840 [ RunTime:0.003951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19151,211364,332736,342151,146639,454028,893981,954587,85236,766178,59590,409761,578592,811280,1005717,989757,752072,121406,33394,776611,949785,955951,560775,646786,598969,82320,422090,157867,336652,971429,973893,1013571,873937,178837,636624,397431,732079,455911,201023,734939,655664,212511,114145,505820,671848,310443,52205,393778,555328,745113,217199,473630,709130,930057,7625,25339,853030,692579,903982,988191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]