SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445979 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445979 [ RunTime:0.002369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259946,654257,968489,967380,251911,171102,384944,306906,322099,260855,912647,222014,374700,805137,551259,123713,574478,224338,890580,66357,87932,727857,353058,540702,445043,958571,30002,275999,1015443,1010251,405718,712517,558562,240542,803711,969503,299427,920355,632598,138962,269653,337641,639371,638538,446444,765096,57228,477862,47905,401328,162886,9572,416491,1041262,37418,408067,507246,318155,758391,293889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]