SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410860 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410860 [ RunTime:0.002398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98711,115146,82626,118780,312544,519646,140105,1034495,867483,684576,55646,27222,679873,386631,937967,656861,214071,666379,902871,203657,88909,200842,108015,1032059,735138,12225,749052,930857,421491,131581,615518,190525,61672,481978,975053,813377,600132,400660,731178,591491,416212,895861,117681,579557,5506,113276,423442,1020371,902717,505602,1042970,441588,515137,682429,946088,204092,520952,812745,939867,517207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]