SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416795 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416795 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891218,470290,463959,472083,727528,727114,988117,343553,161056,363705,298204,253324,379091,395522,959049,1028085,44345,211289,784483,596742,263765,971369,832030,433470,99456,504096,30890,495093,806045,389109,644113,661850,362814,519526,680977,531910,280734,190066,963051,441261,90338,205989,6335,1011652,518225,774631,294397,792716,209759,355913,605101,949266,1028516,30273,693209,556269,610910,819155,941853,283576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416795 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416795 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]