SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577430 LIMIT 1 [ RunTime:0.001558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577430 [ RunTime:0.002398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612713,244294,533673,1021312,353969,529873,9685,230624,107068,581603,958746,741334,931251,837450,856860,737398,712756,636126,922153,81696,77670,306896,919712,252424,211573,358160,257495,892668,4159,732388,87691,956961,206889,846975,962256,14919,366154,351701,22460,227537,442772,147061,304634,368642,768674,522348,301686,1003802,428808,2853,932486,954661,203372,1056,992301,262208,345381,5865,756752,1008308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]