SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104617 LIMIT 1 [ RunTime:0.000613s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104617 [ RunTime:0.002359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595954,148105,280909,1017190,171165,717752,277056,885789,601235,904904,510647,242335,541942,456770,238176,721821,81756,521755,923067,115039,487397,686265,254089,882447,677147,29628,501456,136350,985969,820624,177416,84661,140261,1020275,151897,684851,719128,46277,793370,642400,201586,1042291,258472,940635,673347,719178,373014,959145,969012,90013,945293,356802,816024,595072,514948,353410,316006,474070,289311,292551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]