SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475559 LIMIT 1 [ RunTime:0.001782s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475559 [ RunTime:0.005643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151980,355115,74577,334737,883176,259131,252846,1010991,439557,403453,877778,854108,490268,538620,983054,272457,171234,160211,141270,923046,963319,689503,8533,1048805,408427,199745,338403,936250,493285,288738,436242,798946,577298,601085,644461,770164,406210,450635,66387,426947,36255,61868,843894,339090,188093,55795,892137,694803,789663,1018403,3007,474170,212652,342381,174303,304076,217354,158390,709063,485246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475559 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475559 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]