SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504461 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504461 [ RunTime:0.003308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604376,985788,683969,990802,544132,87260,205119,489170,553363,684713,520347,321694,486007,181919,979646,197109,122737,707439,790016,566459,467656,498155,198992,371128,787314,681779,990955,940007,324779,828224,338373,1010352,1004561,5088,956453,614504,41997,308381,100221,61090,384336,629974,862451,503648,788805,116959,173423,522438,272320,391359,126708,1013429,164120,228629,341672,870342,516942,992583,783118,975490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]