SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403139 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403139 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438056,783183,1002777,533665,161092,69395,396890,386296,814574,661869,972659,874706,217237,605675,467566,230260,918627,398507,1047406,951411,754957,417340,794115,871299,683899,62537,673654,633950,563336,835701,555975,748448,222486,725428,102469,209625,354022,469737,905954,980136,699665,829820,331023,622097,934705,242475,794226,227513,683935,231417,74115,639206,874385,819614,571564,396099,343448,524984,57930,197096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]