SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392091 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392091 [ RunTime:0.003035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433070,1029120,463544,459927,256437,797570,303084,492049,122085,149686,960604,1031998,983182,228696,579678,236815,108452,908384,289677,782250,663870,566649,224575,758742,766913,489386,657730,783890,807464,143184,707425,534886,446329,742264,501355,326516,844658,112965,675396,123782,254289,706567,470734,550949,942084,1004250,221092,334913,573397,19781,344799,960228,617117,726259,161912,850318,767196,654625,259985,766412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]