SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 67250 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 67250 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819050,650029,643238,61335,781740,505395,197098,1032012,156745,1034135,881795,879538,168200,25443,61062,839738,632515,709441,694798,706977,357682,835604,511000,371414,342307,1023974,241912,781729,370560,391368,456735,53631,416589,93601,971963,521523,926550,1044395,583844,727135,449004,695426,571444,237784,509910,753840,703731,716958,774694,48009,338734,878357,615391,826753,611225,582405,15555,704294,991383,652853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 67250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 67250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]