SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424358 LIMIT 1 [ RunTime:0.003892s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424358 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902867,635993,400600,701516,641984,154043,865727,516285,698068,463350,733485,83504,1004743,116670,888391,589302,571043,1046894,892464,672670,565529,342197,657612,434073,192263,291284,205062,744410,741702,271074,1008497,141795,122974,573747,553215,375205,29197,92947,853444,842601,415738,811457,71531,386711,155429,251130,558718,714895,555084,445642,751342,139556,662618,324933,814558,855074,304053,639049,288815,681771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]