SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486056 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486056 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140093,954859,22299,38487,597603,74222,363426,360622,142923,415782,969933,958835,492028,491,899383,368188,118591,362017,904242,438022,473701,605888,415092,419640,404781,1030924,25462,717449,462052,719738,636505,283659,758816,465588,85416,1021520,428390,120076,891504,998839,678646,967552,367330,980087,260269,859580,237397,258327,346911,134476,306955,216468,343188,310093,71383,128135,127832,752672,227188,89736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]