SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401143 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401143 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917655,171662,767816,414400,381784,72294,773394,329381,588243,813700,74341,169630,53602,326088,458873,101172,393300,155206,387246,778659,681344,67109,870108,179511,609256,926833,508971,390094,386854,971051,47854,981159,9011,29529,105971,918383,10062,613056,405948,758113,924687,1019568,348575,242155,670585,556951,370933,90999,407954,669714,811202,985560,23977,270892,571873,624376,219470,768591,838583,823435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]