SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432320 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432320 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514287,242645,250547,79784,738482,432510,1007364,201053,25275,608217,771063,872053,78438,672812,1020560,247779,350085,278049,639616,405934,692466,603432,99610,533928,453133,912831,400300,627893,889061,210240,176811,1007286,599715,813991,72008,836850,742649,412998,35609,54975,541301,571272,522339,642890,801631,1022428,701952,807737,219422,874197,722305,967479,551541,457024,462135,246743,722669,920758,69503,62406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]