SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002747s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454841 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454841 [ RunTime:0.003312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113859,781635,903275,1024780,520808,40070,879141,967755,652016,151289,1025849,609296,660023,128255,541939,17868,38041,159010,386817,704886,262508,192593,922924,769732,441607,1016810,925930,659498,303878,324386,133679,306746,536479,140958,587766,733601,18080,153102,518840,920612,428990,1039061,209706,728291,603637,639936,1012747,941580,749670,961218,532009,891359,561819,515941,776523,810076,411185,850638,191148,654045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004753s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]