SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541503 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541503 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108694,286992,727261,935909,87151,111033,119539,539190,782883,366487,815678,825258,31109,567550,258426,785593,475907,220026,561433,132379,287943,439085,363043,575119,80815,580756,376685,167278,297002,573144,515781,639700,859426,328405,333676,857815,645501,165432,1015109,1022678,263074,677359,221901,584656,797689,638346,100289,696619,717960,356438,481116,430958,840787,431608,45022,638965,79963,978753,665735,591206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]