SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455512 LIMIT 1 [ RunTime:0.002903s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455512 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502111,391274,782997,206212,853032,505118,905599,61103,133866,960415,291572,207280,517309,684626,436162,933618,616442,4513,1012754,140586,956313,427451,910010,846572,79085,604326,808179,785489,669070,318152,177830,594023,9712,759123,662001,701009,775306,680224,805744,892615,65789,926389,124967,859679,652271,538595,283245,877473,174340,730150,364848,797210,602769,607259,511564,847435,33650,994752,484818,966311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003080s ]