SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20908 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20908 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459820,1045189,966761,652091,74508,421812,823044,778914,697714,197976,366822,986091,275805,908575,590970,83497,262005,34187,421033,502164,632995,1013929,567143,436032,843699,203509,516126,916413,816232,632783,783856,54769,913962,462543,301129,109909,830900,1034204,700122,2974,506158,601379,119850,682707,332565,732123,1013385,686508,913769,548382,138419,393038,734962,608960,340559,133008,244980,360461,329187,911138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]