SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142817 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142817 [ RunTime:0.003209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910803,545661,251825,932842,254447,823074,801172,268854,273805,722152,58429,407347,206395,941947,891690,68160,329150,929993,385782,920699,828046,500392,782348,785892,601792,634873,1011306,761342,37269,268371,69463,240775,264929,770207,500589,283204,437020,65939,676607,733651,131064,522991,1035151,849113,349204,245578,247718,960693,52331,783862,591200,568024,630174,550720,869652,1028673,836297,895262,745752,584531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]