SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411289 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411289 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326211,576647,204551,452095,747523,182606,462366,866246,357161,234007,176570,488579,653269,473706,371739,468880,333268,931761,1025432,1012522,508267,159587,852541,544587,492986,275581,324114,145828,662053,193743,753491,814546,144331,668061,416112,695347,259772,59806,989880,394294,990640,646038,524150,428736,427151,918758,961375,975514,379546,63660,936543,629893,1034830,387324,622254,659193,428600,85713,986739,970005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002733s ]