SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105486 LIMIT 1 [ RunTime:0.002185s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105486 [ RunTime:0.002060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443446,757809,711112,1017811,971218,540320,79986,838432,454334,377201,839536,426660,907668,1003235,86125,286595,683078,1044989,7993,907515,1029594,691610,490526,878024,305980,39097,392376,862191,336116,426797,547884,937353,276870,448829,1045814,144367,174626,892098,281584,180488,54024,1022144,796597,203126,570417,10766,395083,329728,229037,708912,194330,23355,578924,821211,273882,49933,656563,961981,930236,1019430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000966s ]