SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536893 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536893 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563315,44471,110978,753172,502111,280610,543077,473138,69729,270535,784075,457951,538558,837365,961597,406300,223190,543891,750176,678776,442866,27760,88424,150114,411986,24610,382413,289463,271334,500152,980434,843919,983174,774,190249,714529,930944,294560,165593,725043,275052,505236,265167,127814,751864,427858,471231,975241,150667,176761,876152,98910,958166,8034,475655,723990,825666,520971,131545,752162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001209s ]