SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511985 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511985 [ RunTime:0.002410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409797,615389,850698,582232,100000,663107,414064,1043855,992569,986221,443345,912361,45143,985600,945893,875914,416621,723848,818552,688752,528316,674297,116799,959526,625207,701516,292622,418901,451983,974128,457253,855472,244551,292081,685448,753924,232438,972200,160980,556951,517556,1002457,414329,13743,888531,162225,654392,499475,505136,291043,321501,152725,749046,963839,960209,397559,103098,214442,802417,482176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]