SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401004 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401004 [ RunTime:0.002275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31851,923429,666679,477783,673271,22865,709735,355381,865312,700183,821376,438641,359872,82299,977191,692422,802484,662304,250552,131491,194626,518980,583616,556004,453435,423484,732842,544603,974135,25328,192058,27775,162354,758989,455574,884435,680294,385397,22808,319279,277050,777131,27320,684141,859648,829061,362393,25916,871230,786384,159997,1037760,32972,119378,412959,891571,255409,1048412,979286,913203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]