SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802208 LIMIT 1 [ RunTime:0.001317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802208 [ RunTime:0.002813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410760,442130,621519,999266,312300,569570,425875,611940,841155,159382,700411,858604,491676,893539,981987,839531,180523,803282,230906,818352,524092,881601,478074,346036,771855,624414,742141,5382,884640,1032012,1011015,141738,758416,998295,286421,822847,100578,317817,36781,915780,732890,399185,909537,458819,824047,137477,61172,830762,243341,607960,746753,759234,913741,771347,868007,372456,908299,22656,72045,758803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]