SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446217 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446217 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031874,402190,689521,295970,517836,86670,783579,540854,791177,371731,726020,331114,93373,890993,33584,284345,475208,824626,767299,173877,905857,130029,73217,313797,539197,103207,670135,99246,636302,329996,108959,150970,995390,951118,416795,302549,35690,835811,712464,708788,12449,751669,684430,538089,296539,180284,294676,582459,1002165,765918,692464,329011,564788,768352,388591,593696,957883,242146,283136,324748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]