SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645293 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645293 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546967,251236,130060,106876,291899,443384,284563,525740,644713,218748,914064,990904,97065,562656,409196,920947,660052,256319,848689,30103,148026,485858,997142,522001,639371,957584,70849,634225,825052,2801,43900,933587,428108,1009063,808468,998201,791978,675901,657413,26377,937478,1025844,138049,703985,178226,768585,774520,882240,287653,947092,52862,780020,748483,951807,294688,756879,890921,251748,618370,185007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]