SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194084 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194084 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664759,643162,18102,483264,707594,107253,538276,242246,187585,326362,670134,22227,926654,1023320,431201,72965,254577,557781,543982,871152,1011968,38231,852597,592037,656471,946688,919225,818843,865165,699542,717050,467441,1007774,275439,113305,732861,109334,524781,393929,808977,913989,688120,457360,8237,309178,666292,168669,970975,253094,1015511,819591,195449,84173,920071,477284,374723,399380,870822,59512,985558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]