SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53478 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53478 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802613,59054,540268,959955,136559,783599,58597,738433,81074,500363,465901,601241,11272,6707,957793,94965,543602,631781,754760,915960,595263,219921,233275,938644,402617,190013,936550,235705,939030,287887,783390,466326,764765,57580,365903,277694,1030463,910164,525025,1037114,1004270,123264,558409,116936,245960,362545,571551,703299,430468,775924,585805,146383,267579,997035,149196,844675,574262,310230,231965,326694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]