SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485601 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485601 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749603,761171,991881,97461,440328,48590,810537,371328,259307,167785,266916,378658,1039303,245979,76983,455661,671182,658772,520579,1044763,369900,1046825,131753,156780,297759,871306,334587,629144,1002595,4949,363541,283809,348295,395331,543918,17423,132003,359115,664798,591520,604438,285393,306558,258424,778097,408341,835376,384055,596207,349982,1005652,519109,742914,886207,308341,805050,117830,924788,343634,134661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]