SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002837s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283991 LIMIT 1 [ RunTime:0.001620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283991 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963340,343679,290361,891742,783685,1036516,929909,200808,609207,588699,953021,984378,56712,5072,77869,493744,568281,646288,405959,256001,962041,873355,891978,416571,901849,952598,876810,550367,245697,841025,861088,620529,102630,132830,585896,923272,607629,509275,1037131,117042,1037868,158058,474313,861460,219676,260748,22357,301554,723960,544847,930960,466668,293616,414300,1039993,598179,254617,703197,454993,1009274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]