SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001771 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001771 [ RunTime:0.005308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167066,125709,211740,662380,116679,941881,961406,91839,1023277,728863,133701,318504,180929,375299,142626,444149,89809,52294,519345,832619,519795,161970,629449,761440,587759,221124,114640,322766,404371,698709,863676,665730,1007776,890804,952168,170350,106176,877139,484689,229742,1015553,913573,345021,199666,131702,286211,568954,145492,195616,122417,640332,1020894,21937,380783,1043712,82424,212146,784475,688655,292985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]