SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456020 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456020 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681144,37489,366473,1015071,770455,762755,76985,324562,426453,397391,1032483,554094,194063,727426,754201,356915,953238,868997,933003,209899,752334,112656,943471,835692,787781,760818,748081,219925,233856,722839,486084,101783,27872,599501,123023,799701,1032174,358139,1025668,822391,394696,219104,821391,534225,911108,837803,822965,859537,91853,884217,922310,518367,294794,385786,334325,270869,807827,235177,298741,865101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]