SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 63573 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 63573 [ RunTime:0.003688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003023,122241,365599,10658,857173,457688,475999,761467,346278,348064,710915,967592,734103,216142,493476,275733,931103,1032889,46615,758039,304241,191896,243749,587259,829091,819260,293943,644406,971696,586899,645445,705718,1024827,329950,587202,548660,597801,286331,148101,988281,559363,798946,194649,716487,614878,280027,879363,687924,965764,277736,37040,872506,893636,150739,902354,56186,749378,606728,392451,1039161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 63573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 63573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000802s ]