SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311643 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311643 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023060,237636,792131,515601,308731,1173,886435,578925,520415,135906,844829,207475,546236,373367,610324,131317,870357,624333,593196,642969,286991,1002737,214284,903565,237508,257059,659354,177458,529900,218782,242920,131365,338746,37222,646987,574533,63767,177748,849671,414020,605687,467838,755246,691254,852514,936659,586551,155238,643028,942086,897935,581760,472947,273582,791900,162807,175204,158490,176325,601760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]