SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111681 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111681 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596112,199604,510012,1006040,220102,1010385,505978,289263,415671,378643,406162,240439,601801,944158,695256,427866,855191,280459,533218,985824,951565,561017,624524,643941,15828,825959,375593,924260,497640,721388,724646,70268,600237,170045,883244,926645,945764,118716,793474,1036195,585973,834653,217856,756521,588312,1002646,672057,1042412,796873,297841,577948,958773,379031,122930,147118,999301,833167,179061,64386,962484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001837s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]