SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310954 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310954 [ RunTime:0.005103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169068,899885,643558,643240,1007551,888077,730310,145634,1003036,260041,139355,194398,623499,720704,208939,557817,1042950,524262,131561,180618,599322,326817,856925,239024,514656,73619,273156,630458,168723,92153,556857,729434,738344,100134,126746,250278,909967,424363,924498,129402,960646,800245,581891,181178,867951,82519,467105,836112,126736,187352,76216,766129,58959,689885,284178,624052,119032,923066,573383,282288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.034353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002833s ]