SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589876 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589876 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280798,754607,352302,408395,523389,647018,695690,308393,830853,406190,728601,98635,207176,1036320,916154,315604,140659,45648,459234,598023,388764,908846,991094,284661,368433,798976,937494,400984,521400,671553,831406,785366,133363,428415,1029885,519157,945664,1037947,707125,526590,890397,385413,936953,472136,816215,921148,195000,91835,864970,28016,923502,705599,945985,499247,689648,1038023,757138,871898,359323,306726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000355s ]