SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532032 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532032 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38254,873868,20365,177034,419942,288647,1029542,999858,350126,298168,109012,892354,601540,126936,849151,858453,811633,410074,161193,911130,135088,171342,93433,842350,456330,130898,88845,40022,761633,22312,693149,762699,907773,761907,1046009,318892,185809,859872,615199,855799,634727,773759,95619,303197,146116,627940,961837,198273,188548,488346,406193,455095,993983,606994,429556,191601,120546,379122,374056,3387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]