SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10211 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10211 [ RunTime:0.005538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120685,618717,733825,701861,110834,108196,745402,348082,447347,422179,558918,946945,1010489,990850,391679,433262,1036607,435465,286352,224465,165006,662733,77409,369010,851344,842887,262333,942358,999168,661110,227727,356532,877041,106326,267102,809192,727737,312147,578393,464686,583625,775512,852291,595301,550167,103603,204133,812315,923057,202417,685093,840946,448591,612296,386677,590730,531469,308298,740047,151081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]