SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519539 LIMIT 1 [ RunTime:0.002218s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519539 [ RunTime:0.002700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19894,758051,414593,921533,327173,737189,96451,468560,221360,784590,832538,41310,716612,304084,777696,489368,397390,915247,201626,61758,191539,460670,296297,835805,778892,385734,313264,497277,817530,82997,284382,677974,306356,883364,682373,749348,182130,133209,541063,296060,357437,896500,386348,22976,135046,159779,1029041,1048862,95565,976221,77648,622244,818751,573095,811325,68047,194405,931160,584953,898982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001210s ]