SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601010 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601010 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4317,332012,701795,920785,923637,404407,376764,1041797,705054,642084,611291,360008,242613,237094,884767,755986,228297,676791,358329,114644,91625,413323,768539,416157,48164,741726,11324,696578,155327,256648,563251,494235,439559,421376,219075,523589,992049,716190,515425,458529,381749,545027,332179,439951,116507,204904,649362,254317,215945,844785,305577,405440,220954,1043252,57474,911605,633540,293204,343085,953609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]