SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440941 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440941 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745493,489673,1010055,325578,737670,523022,290190,529570,351758,265287,42142,467451,641551,288124,834768,119003,594904,714601,91240,1018610,987558,242851,974834,125813,690142,948669,27391,494529,692431,381253,879175,72656,997472,468461,584653,889848,83650,799488,61123,707332,184968,628111,950144,722245,177813,875256,198067,111015,81973,438711,69598,845908,583975,247539,351475,978060,823581,22711,272189,469104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]