SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452560 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452560 [ RunTime:0.003290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537705,640508,667269,466165,716816,799469,394759,990053,637369,884929,144125,976499,971093,813704,270865,431873,152188,801449,654029,387916,430716,340403,591620,569328,766682,323926,1002561,250758,134233,62198,146837,999093,517366,187765,562631,201672,204603,710373,883948,952263,428469,884123,866294,906525,206735,56450,905934,720216,202937,553804,479087,702850,917898,179807,113080,121249,122065,666333,941253,214805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001102s ]