SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002954s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409013 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409013 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373433,994023,974479,541936,435045,973130,1010398,862058,479985,1039782,209793,464123,366069,670636,225733,1024943,972772,48981,393347,908349,130650,5032,178541,641615,401586,389277,709475,983685,683562,476018,812252,816303,1018477,760857,402612,401428,212850,340716,459555,756690,886816,48069,949098,925571,987028,146999,801215,715880,830510,686220,872017,961703,728320,830278,467030,504368,209431,830106,225678,872185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]