SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474268 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474268 [ RunTime:0.002381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599550,666285,417533,785669,412479,6723,637569,607809,138616,567858,850347,678649,734801,948481,963146,148114,970756,588053,924109,519479,351317,159827,54940,19136,362810,165519,973595,770453,26069,157736,678162,545082,694582,229850,487659,287309,17911,109335,993192,80427,878748,112616,142485,624678,689026,439821,937574,398219,110500,1004331,871181,7857,174619,197854,1024385,661937,570160,77116,144622,699548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]