SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551531 LIMIT 1 [ RunTime:0.001439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551531 [ RunTime:0.004144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411445,981818,228491,900874,724070,513934,772050,738965,577185,735942,62331,145974,390814,901088,216703,775640,790997,109344,115643,640395,602686,895744,704435,743194,376816,495859,567773,28728,447510,276625,241460,222162,577664,196818,646859,730679,839991,1044041,380225,257809,119085,999511,680042,182595,1033667,289315,412364,1004806,483608,422528,646195,709363,845002,38192,730052,953970,839116,373684,339497,978535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]