SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118434 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118434 [ RunTime:0.002227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989002,480207,132289,300556,438084,222749,925094,1038378,771593,989649,546491,538199,88131,148612,694178,786657,121965,146512,817909,289989,21568,221161,770774,688842,794019,288304,1040136,193173,368902,1047484,250993,66318,737406,952922,953151,862006,721023,117788,440783,863656,375368,470295,153378,902974,642078,913174,767775,158785,209881,59119,524755,242688,837336,679177,362852,954771,788972,803452,542625,958045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]