SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343075 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343075 [ RunTime:0.002537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184132,836954,198493,832498,111488,1012090,311978,28522,873750,439129,93030,947145,1030213,685285,724773,689580,392165,264114,728335,748385,979265,833861,336173,1027985,510966,799099,96101,382538,316507,487295,718547,275509,304432,138066,209015,956726,309897,978126,236008,212997,630740,820660,998585,435882,257733,163866,793272,52590,470762,998203,253624,244089,78462,959881,608335,587434,692104,844757,420611,702118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]