SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285328 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285328 [ RunTime:0.002584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834099,148811,558716,192937,733926,624999,835163,336411,539225,490143,282079,619379,1026091,36416,271406,350848,804160,15233,676437,139101,248970,529302,35289,1006746,903656,1037434,601197,275289,780914,711631,79709,537486,84400,241732,407387,466613,1028919,240554,485380,729872,505961,797142,646843,930952,472547,12601,802330,750327,925985,115280,226331,879490,566889,272310,608137,559950,236752,842672,54426,159258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]