SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417071 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417071 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862035,987571,1032811,907061,409035,335110,989063,1008486,198272,453434,482977,353364,461574,689677,762143,33006,995544,118177,1032504,633346,683843,154868,747524,246016,317589,522973,833970,356889,965821,731698,607957,173060,412027,776265,625754,139145,181115,713027,222662,909914,680284,116780,995802,5236,283660,419516,367385,724571,554997,961893,1009894,573849,316025,475955,245362,926214,723775,314262,215054,927349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]