SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525834 LIMIT 1 [ RunTime:0.000627s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525834 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310670,633567,946652,39996,302100,435597,428419,168853,1022784,579146,144894,414762,507657,202807,112505,47190,936024,962216,654817,933880,567703,883322,697588,372808,579639,910686,188342,637802,263966,39935,319807,843906,290199,757067,681441,944178,122958,449066,228383,772235,400679,302067,216781,225377,224118,864459,417573,787124,1007279,786205,650443,596166,472987,750729,180766,974238,682951,439844,805409,584842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]