SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 604993 LIMIT 1 [ RunTime:0.000585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 604993 [ RunTime:0.004706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544957,181028,431846,46872,391543,296526,931269,413627,310702,258822,255678,794530,809771,545835,393638,432901,239612,73209,385423,245598,917452,155385,94727,28431,70747,309041,425410,626551,429079,853552,847839,210069,376896,990759,588101,280012,1009430,1031011,502704,275901,34659,412667,265511,821730,504857,557942,531369,401410,362765,814082,541272,829894,433316,107053,397987,94715,669846,784925,185404,586992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 604993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 604993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]