SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107523 LIMIT 1 [ RunTime:0.004537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107523 [ RunTime:0.006729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9155,10627,768690,501298,161560,328206,574070,635304,25661,406664,549226,976289,474512,783833,477301,732302,733280,141,971742,1018962,150815,489004,646607,503816,834716,223375,773395,395226,126700,259200,491228,308035,856537,593619,430491,208515,392039,314432,815924,364476,337055,465474,364963,113742,994909,469507,432474,214429,153824,270887,634536,967180,574346,376253,189212,350086,286280,592355,15347,298409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]