SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 975489 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 975489 [ RunTime:0.004030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150085,100927,197677,603289,985866,1047714,322690,362817,796106,440755,138427,284865,166426,391093,1001122,903069,111353,259551,538787,841015,862033,1013243,238045,101423,592522,934507,940765,514306,917818,285428,987030,437730,250701,81861,480124,545992,376469,198729,429680,718564,639667,324392,401017,636090,181616,372390,991920,471987,496441,1002374,890314,426921,992467,109827,382986,361268,652591,302139,959355,335688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 975489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 975489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]