SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005815s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810028 LIMIT 1 [ RunTime:0.012186s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810028 [ RunTime:0.009929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521104,349675,392535,639271,182152,604529,96027,170093,709314,848953,849902,255878,182764,855483,83987,106086,1029212,606320,1042174,303818,163344,293308,258573,300382,543317,250263,410775,510407,78440,121907,969809,30289,284247,240321,804323,92519,101764,247540,40939,910727,706957,448113,899765,658317,643718,1031062,196894,544747,803396,595709,535595,1012241,108782,946157,724549,226824,704354,995230,782395,366739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006144s ]