SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544599 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544599 [ RunTime:0.003388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372187,524785,1032054,314287,418838,552636,76332,652144,109388,499034,951245,958696,729000,302838,383802,433027,463550,2511,761138,76023,43777,846202,154684,216020,600833,397602,480886,169284,847644,291759,795600,482291,254682,842469,402994,899725,50920,951166,216547,791445,628217,790839,130800,403364,360483,317740,316172,7465,343499,521550,125092,716767,169458,453981,615001,205711,530695,330998,716638,1025185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000992s ]