SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50366 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50366 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573493,438207,31144,406986,500613,481271,697216,587697,80590,140415,339421,54878,870346,679494,880582,83233,463708,1034401,1017502,155943,274381,701599,914146,964444,65390,670685,399141,540425,857274,655716,864775,115746,242206,620227,798653,877233,805594,765898,69399,68104,372981,580729,204292,286293,290581,444024,291167,876670,440660,882711,426130,129005,761766,672889,136430,860332,963793,330376,487749,696054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]