SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403803 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403803 [ RunTime:0.002686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212142,489749,1012165,248115,995064,453237,910924,876940,827754,368440,800494,653064,285173,1026359,832716,146582,265528,161915,373529,988183,795423,1005563,870667,633924,879769,69165,696703,450484,938226,650394,109772,824636,146090,813499,225841,453003,644326,66078,197998,752744,753064,47746,513985,995299,997973,731240,629903,834525,299866,278631,12752,472372,880526,481069,683136,632301,507484,269896,566503,408653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001726s ]