SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319423 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319423 [ RunTime:0.002114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544718,433651,603089,476925,394316,446358,937352,754263,232955,198937,256984,397818,812031,118223,750308,231711,73000,59567,646368,726607,867586,644799,1046504,365181,1039651,646665,85817,643994,524667,113355,181931,945751,463132,1036872,788839,580652,996705,126830,457439,865011,1027705,395893,732879,92246,490010,212085,933159,870809,727616,970013,299100,325500,73040,691373,271933,48890,672733,418171,927335,591239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000816s ]