SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003683s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398530 LIMIT 1 [ RunTime:0.002549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398530 [ RunTime:0.001376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496724,436894,1025439,888517,405288,507107,680338,207136,544257,554561,255387,333451,223297,648922,760529,689441,250418,287380,854435,75085,834486,205277,14684,342217,362948,517560,265552,660833,148988,826600,1038398,338201,872842,234587,446023,682296,423609,487251,630795,642081,221540,113862,964835,54243,533788,607573,485255,982182,691876,853632,389118,309374,546345,556975,910675,19078,850502,546210,914948,1001874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]