SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451501 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451501 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229905,635810,875183,937060,872946,981672,376425,183469,857573,925565,27043,934445,386884,1015955,563570,397436,578946,697302,888225,829148,602365,559264,94100,777073,955017,175436,417134,928637,520452,160083,188194,630989,769753,310281,1032697,271392,902313,965749,131999,195843,315996,301647,711369,299443,182819,566721,318728,23807,823072,389183,653922,583523,716449,606682,229615,458976,315304,958450,398458,129776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]