SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 721400 LIMIT 1 [ RunTime:0.001162s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 721400 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865226,1025433,149645,113765,553107,354817,55311,581943,133322,999357,779459,640346,117904,799815,451730,345006,245757,1024235,717997,549661,28072,454969,19589,546695,660958,887022,217941,538782,691269,983144,454666,694989,348025,886857,1004045,1038408,873117,543329,574077,118279,759028,566937,825735,375715,652664,89105,756505,627350,109384,245459,964370,717009,401110,963727,1010094,129809,381222,224864,758003,910649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 721400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 721400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]