SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524264 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524264 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940738,343164,811130,291599,705841,123730,636430,99822,109098,839988,297252,1043279,1005691,1045022,203554,961328,627248,1016242,689988,432320,95272,99752,1001938,969012,288541,810643,774646,222300,942073,370533,284466,442358,863678,647757,476687,163606,251208,914444,854713,627212,403304,1007193,991803,1018110,18034,709873,836549,724360,112179,505399,821160,86870,896369,224235,34470,533893,547823,163929,329764,296397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]