SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428812 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428812 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13800,206194,215296,662796,1024985,946860,729479,883228,40919,587348,794039,236019,898188,990954,44131,16080,697462,591485,976323,903005,314400,388992,221448,1012061,624462,266761,4360,1194,560827,914124,525169,832700,804398,579917,73662,469094,664982,10086,455145,167569,871891,841375,26381,267292,718031,194705,185681,161068,965114,787081,34563,597843,871390,660586,151882,857147,371271,25368,76928,796383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]