SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538813 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538813 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984541,781548,394528,934098,301877,458797,721862,218322,917529,383723,180346,996281,119215,1016009,240897,227273,676587,551323,987798,725229,350033,803319,137861,466413,620600,217192,374633,130018,142824,51323,822582,880177,676434,687050,992470,612018,742074,393629,427923,292110,960398,473070,49013,897540,379562,630573,997047,489182,586207,491411,885322,309751,472666,66297,316338,258233,154977,514322,530971,571190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001366s ]