SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 660410 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 660410 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022534,648162,623048,371361,643555,804672,833097,704159,875300,175728,842599,279846,186428,229205,250074,890738,291837,598896,218775,201775,415554,1011421,112229,668261,219159,676092,623068,814884,290391,767679,426358,960000,20188,256088,119387,141601,691595,25448,790028,608327,471541,1033615,59462,671863,98651,895683,303755,35980,212083,29950,539054,16489,883099,611953,814856,653494,726107,268935,1032715,361940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 660410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 660410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]