SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 639281 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 639281 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648231,814065,593287,541978,911787,408724,755947,1043252,754637,296999,194297,909022,885898,1042072,52517,720775,604527,590436,746040,1006334,860449,798960,491001,121284,101919,590826,321850,110522,948798,697853,475152,269297,241351,372975,565621,859371,39363,228499,409055,681310,339846,17421,538325,470435,74155,204415,1010171,629856,904084,628953,923698,31087,273167,664818,390,959450,55597,518564,903718,486706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 639281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 639281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000345s ]