SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34607 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34607 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388716,317408,485915,378004,190393,103366,300161,171051,867718,960459,1036258,72873,465195,538025,395361,510096,124408,137341,948270,828979,607179,348985,983127,561752,396252,387844,902251,73013,602995,861256,467372,45341,660537,726572,129871,257048,875815,895109,347521,822575,371955,558198,970915,715473,41901,505978,230659,40669,982012,773565,177345,321916,1012937,618536,431881,448308,387138,393318,353194,403730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]