SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405561 LIMIT 1 [ RunTime:0.001561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405561 [ RunTime:0.003576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991759,506090,33337,245052,992885,456497,689960,696127,445028,151388,380495,600189,893442,17821,696095,389532,832921,662152,470353,692063,76202,279698,917008,798604,765760,351345,992505,488829,896328,818043,519518,761092,872316,1036688,477440,191676,14246,520185,281315,770442,951375,181701,908590,122117,922787,587357,149776,47647,257723,946586,69188,308089,638553,252249,78627,254057,820646,256830,230498,357748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]