SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340091 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340091 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385144,1007907,563602,274295,983934,119837,550085,725561,1039760,64265,227483,415067,634788,431328,646714,1048376,428244,744477,404064,258910,166538,645588,919719,221316,206774,531573,934072,534054,821197,908353,753015,40279,30389,767895,520733,41692,551960,398158,46616,482502,781746,589187,767216,56309,721811,787406,299385,939664,540038,287290,235303,181647,967756,541935,335737,829254,123507,661823,293069,418672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002216s ]