SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535427 LIMIT 1 [ RunTime:0.002308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535427 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479151,305874,829884,745163,592646,711740,118871,884855,458458,1013944,275186,981255,89909,486696,551719,691519,888499,1985,549521,481188,314521,767389,617891,250773,715397,518533,346043,547667,220364,58008,901643,853793,176986,752330,388847,635157,944773,587062,881141,383796,839843,958253,683218,594058,245159,965486,313837,532931,189665,56932,949759,354772,567957,691091,674123,597963,919101,299448,279743,312549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001266s ]