SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412534 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412534 [ RunTime:0.002567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32534,1010123,434484,442376,562627,696253,208018,622395,449602,410297,14589,337799,614800,558677,322422,391927,961064,572126,717653,649783,639516,943118,558538,311624,629786,608082,184796,723067,948616,902410,40531,392847,168846,593544,134264,284998,704356,351337,696593,406099,336999,425230,722144,34841,145677,756195,638504,242035,818625,580161,664487,664014,283037,223134,598815,446844,665034,652832,382738,1006777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]