SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004662s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574451 LIMIT 1 [ RunTime:0.002882s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574451 [ RunTime:0.009435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281292,935537,989842,442045,215920,425398,382733,616034,342356,139835,418326,823763,445966,105423,392769,570041,696846,899682,286162,898833,596371,264485,51804,984098,613170,861050,540437,579830,588427,680934,86439,607164,158089,49667,153979,556356,152340,28151,222128,527305,463157,520294,795970,85956,27612,164575,45643,483440,27880,27296,271795,406704,809033,662309,898345,388610,690544,1038026,875262,369472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]