SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432400 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432400 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495106,799799,279048,979497,1039479,739380,810416,305845,477507,423927,383127,403267,181533,535601,448515,878126,298589,160478,803233,161651,448160,34200,608645,585911,704302,42344,501446,149444,176988,283398,294220,1015879,384221,1003428,368287,147087,932141,927612,82718,223304,481239,244397,243339,1045333,241295,902094,52678,170905,633207,1029982,538363,369984,321084,1029778,476814,884710,433106,387876,10417,883060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]