SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681757 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681757 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396574,731717,811543,967,349352,672932,954929,861139,173589,673767,161962,32707,703627,517497,959517,523499,35357,303984,652015,845203,1028127,808922,47879,86023,865647,728215,220991,461434,533788,739291,425999,197509,848940,433146,45641,634293,316723,242788,420576,458255,960272,586363,367402,554342,102405,1015098,689671,121600,324751,633742,121033,278741,103329,515378,127490,345693,631525,668269,849283,668983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681757 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681757 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]