SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410234 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410234 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45372,514016,737349,21798,101149,153374,521422,613591,165145,350448,625664,146494,109624,361317,652561,833077,784799,301471,399824,512679,557495,39010,5316,730490,117597,662390,566150,1039109,100446,453851,185803,209232,200861,774556,672440,145778,666032,242616,673896,230913,367759,346972,429658,522829,378079,369558,994751,15709,508826,99535,269573,962709,484288,696663,428479,729974,543879,374842,274370,902738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]