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` = 170829 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170829 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466286,1035996,284496,1024520,106578,143967,98545,553378,874527,999432,595539,306221,60056,573222,856845,981218,387463,194230,410332,784206,459096,714774,887075,638000,794357,251715,629492,375367,141380,121165,522890,942520,92317,402405,1045307,546555,153426,387144,299619,696436,654902,232744,708316,981461,341588,223477,199524,849075,883957,557015,729297,365727,171422,648787,948892,27023,120474,180535,486384,430033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]