SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601939 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601939 [ RunTime:0.002334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630581,491343,1004921,828990,514554,549836,731440,590890,542254,459119,1046090,1048610,55805,743083,591517,490039,551194,960302,270964,22147,509392,278016,559885,569225,221985,926822,1004750,44668,670704,951887,401952,485452,937451,187856,967364,549274,901268,273086,184373,172984,540745,768314,600502,493751,123518,58589,680984,454942,966275,684443,530053,946147,107229,766497,193889,1046224,1032254,110617,313937,429924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]