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` = 201636 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201636 [ RunTime:0.003244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703234,497525,596994,111926,479319,348138,241224,508074,223121,21251,83805,372981,834213,105390,997822,1025973,905824,410100,307424,956926,421610,456104,541821,260395,50129,825116,950537,368615,66593,444383,363376,999637,652048,431012,883217,977189,549842,351469,563595,291744,18502,432513,454168,309166,743981,129743,230228,735074,992860,226101,829956,542577,906604,352786,9661,465418,838700,840595,412460,192602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]